Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

0
votes
1answer
13 views

Excel text to convert date format

I have a batch of data with several columns which the date is formatted like this: May-31-2014. I'm trying to figure out a way to convert that into a useful date format 05/31/2014. Any ideas?
0
votes
3answers
2k views

Run excel macros (vba) from vbscript file

I have a vbs file that pulls information from my database and exports the data to an Excel file (C:\file.csv). Once this is done, I run a series of macros (vba) to format this data. These macros are ...
2
votes
4answers
56 views

Dynamic monthly excel calendar

I want to create a monthly calendar (1 month per sheet) where only the year could change (and so the date). My template of the calendar is already created. All I want is to add a formula that change ...
0
votes
1answer
15 views

Excel data rearranging into another sheet

I'd need to make excel copy/refer and restructure data from sheet 1 into sheet sheet 2. Sheet1 has the following structure: ...
6
votes
6answers
26k views

When embedding an Excel chart on a PowerPoint slide, why does the text look awful?

I have a recurring problem with Excel 2003/PowerPoint 2003, where I have a nice-looking chart in Excel and try to embed it on a PowerPoint slide. Quite often, the text in the chart (labels, axis ...
1
vote
3answers
30 views

How to show negative time in excel?

Is it possible to show negative time in a cell? eg: if I need to calculate work hours balance day 1 : from 8:00 to 16:00 (8:00 hours = standard) day 2 : from 8:00 to 19:00 (+3 hours) day 3 : from ...
5
votes
6answers
17k views

Using excel, how can I count the number of cells in a column containing the text “true” or “false”?

I have a spreadsheet that has a column of cells where each cell contains a single word. I would like to count the occurrences of some words. I can use the COUNTIF function for most words, but if the ...
4
votes
2answers
3k views

How to add a checkbox for a row in Excel?

I would like to add a checkbox at the end of each row and then evaluate if the checkbox is checked or not in another cell. Is there an easy way to do this without a macro? If this is possible only ...
1
vote
1answer
552 views

On copying a sheet, a warning mentions an undefined name range

When I'm attempting to save an Excel 2007 document I get an error saying: A formula or sheet you want to move or copy contains the name <...> which already exists on the destination worksheet. ...
-1
votes
1answer
867 views

How to make this formula to work in Excel 2007?

How would one make this formula =MAX(LEN(A2:A9)) work in Excel 2007? I want the value of the longest field in A2:A9 range. I found this link: http://www.mrexcel.com/td0021.html, but it's old now.
0
votes
1answer
917 views

Excel : How to display a list if value not equal to zero from another list

Say source data is like: col1 col2 a1 2 b1 b2 2 c1 1 d1 d2 2 d3 I want to make another list that looks like: col1 col2 a1 2 b2 2 c1 1 d2 2 How ...
2
votes
1answer
9 views

Excel table from Outlook: Fill Series directly

I have inserted a new table directly from Outlook, and I want to fill series as we would normally do in Excel. Is there any way of doing that from Outlook itself? Or simply we have to go back to Excel ...
3
votes
2answers
75 views

Using data from a table in another table

By example: table1 Position Salary Seller 150 Management 200 Technical 120 Maintenance 100 table2 (in same sheet or in a different sheet that doesn't matter) Name Position ...
1
vote
2answers
444 views

How can I search by row number in Excel?

How can I find out the row number in an Excel spreadsheet?
4
votes
1answer
964 views

Excel 2003 : How to lock the whole template except a few cells?

I want to lock the whole template/sheet except for a few cells that are to be filled manually. To lock the template I used "Tools / Protection / Protect Sheet " I am using Excel 2003 spreadsheets. ...
0
votes
1answer
13 views

How can I import a TAB delimited file with double quote text qualifier into Excel if a cell value already contains a double quote?

I am trying to import a TAB delimited file with the following format into Excel 2013 "Column A" "Column B" "tjc0056421151r" "I\gs]hü"nsf^f\F*lqog\düûWp" "tjc0058088269r" ...
0
votes
1answer
53 views

Creating folders and subfolders from Excel cell values

I'm trying to create a directory named as the value in column E within a directory (c:/Site Information), then create a further directory called the concatenated value of column A, B, C, and D. This ...
2
votes
0answers
23 views

How to enable macros on an external hard-drive

I have an external hard-drive that I have mapped locally to the e:\ drive. There is a subfolder that contains Excel sheets with macros that I am unable to run. In File->Options->Trust ...
0
votes
2answers
5k views

How to sort only part of multiple columns in Excel

I want to highlight, for example, rows 5-15 across columns C, D, and E, and sort only that block in ascending order by one of the columns. The trick is that I want all included columns to follow suit ...
0
votes
1answer
51 views

Excel colon in function

I am learning excel functions and modeling from Google and trial and errors so just want to clarify the following point to get my fundamental understanding correct: When it comes to colon in excel, I ...
1
vote
0answers
12 views

Undoing excel default / automatic delimiting [duplicate]

I have a large data export that is going through the end user for spot-checking. The data was formatted with tab delimiter, as it contains a lot of prices and measurements containing commas. The ...
0
votes
1answer
23 views

Excel- find match between to columns but copy a different cell

I would like to be able to find matches between two columns in Excel. Lets say Column A and Column C. However Column A's values are linked to Column B. When a match is found in A, can it copy the ...
1
vote
1answer
25 views

Get a value from the most recent previous record where some text appears in either of two columns

I'm trying to more fully automate the calculation of values and summary data in a spreadsheet I keep about the results of matches in a pool league. I have a table with lots of information about each ...
0
votes
1answer
2k views

Relocate filters on an Excel worksheet with a Pivot Table

In my worksheet where I have my pivot table I have many different filters to chose between. To the eye it doesn't really look nice and I want to be able to maybe split that long list of filters into ...
0
votes
0answers
10 views

How to make a counter on the number of time a file using a certain template has been used?

I would like to make an external counter that counts the number of time I've created a file using a given template. I would like to be able to reset this counter automatically every new month. This ...
10
votes
2answers
8k views

Keyboard shortcut to switch between sheets in Excel

Does Excel 2007 have a keyboard shortcut that switchs between worksheets?
2
votes
4answers
48 views

How to identify duplicates within text in two columns in Excel

I have a worksheet where column A has various names in varying formats: A1   John Smith A2   Jones, Mary A3   Sally Gomez A4   The Gonzalez family Column B has similar data: B1 ...
0
votes
1answer
3k views

Automatically Updating a cell in Excel from another sheet's data, based on another cell's value

So, I have setup a drop down menu with a list of names in A1. What I want to happen, is have the Data in F34 change based on what A1 is reading. I want to have F34 update with data from another sheet. ...
1
vote
1answer
918 views

How to convert two columns into one column of CSV?

This is how my columns currently look. There are two columns, each having a name. I want something as shown below in the expected section, for better processing of a parsing task. Current Col A ...
0
votes
1answer
302 views

How do I change value in filtered cells?

I have a spreadsheet full of different vacancies and they go in order of the date advertised, but they have different departments within that and I need them numbered. I only need the filtered ...
0
votes
2answers
53 views

From column to matrix

I have few addresses in a single column. Need to move it to rows as below: name1 street1 city1 state1 phone1 email1 name2 street2 city2 state2 phone2 email2 NAME ADDRESS PHONE EMAIL name1 ...
0
votes
0answers
46 views

Auto-numbering in Excel - stable along modifications

I would like to have some kind of unique, static and automatic number in an ID column of a table. Unlike this question, I would need it to be stable once it has been set (it should not change with ...
0
votes
1answer
23 views

“lastcell” issue with formula in complete column in Excel

I'm currently using a formula throughout a column in an Excel 2010 worksheet. It works fine, but I'm not really using the entire worksheet, I only don't want to have to worry about adding the formula ...
1
vote
2answers
157 views

Count unique values in column B with respect to column A [duplicate]

I have two columns in Microsoft Excel, A and B. The input is displayed below A B ABC 1 ABC 1 ABC 2 ABC 2 ABC 2 DEF 1 DEF 3 DEF 3 CDE 1 CDE 2 CDE 3 CDE 4 I ...
1
vote
2answers
9k views

How to Superimpose 2 Stacked Column Charts in Excel

I have two stacked column charts (with no gaps between the columns) that have identical X- and Y-axes with same intervals. One graph is displayed in red, while the other graph is displayed in blue. ...
1
vote
1answer
66 views

Select column by number in Excel

I have a small issue with Excel. I doing transformations for some columns in the dataset. I know the number of the columns I want, but I wasn't able to use them in a formula. For example I want to add ...
42
votes
5answers
90k views

How to expand all columns in Excel spreadsheet?

I have a spreadsheet with many columns. The columns are all a small standard width. Double-clicking the partition line between columns will expand the column width to encompass the longest string in ...
2
votes
1answer
2k views

How do I create a PivotChart from a subset of PivotTable data?

As part of a dashboard, I've created a PivotChart from a PivotTable in Excel 2010, but the PivotTable includes extra columns that are cluttering up the chart. But when I adjust the values list on the ...
2
votes
2answers
1k views

Paste html into Excel 2010 without Excel parsing the html

I'm running a query on SQL. Typically I can easily copy and paste the results from the query into Excel and it preserves the columns, rows etc. However, in this case I'm selecting a bunch of emails ...
1
vote
2answers
24 views

Excel - Find ID-related Value and fill in another workbook

I'm working in a small hospital in India having following problem: For a special drug we're having a list with DATE,ID,DOSE,DURATION,NEXT VISIT which we us as a daily working list (workbook 1), means ...
6
votes
3answers
9k views

How to Label / Tag Items in a Spreadsheet

I'm a novice at spreadsheets, so I hope you'll forgive me if I'm asking a super obvious question. Is it possible to use tags in Excel/Google Spreadsheet? I'm creating a spreadsheet to log all the ...
0
votes
1answer
18 views

Excel 2007. I can't enable macro when I open document for second time

The document work perfectly on my computer with office 365, windows 7. But when I copy it to another computer with office 2007 and windows 7, it start normally ( I enable macro and it make everything ...
0
votes
1answer
26 views

Extract data from more than 100 hyperlinks of web page

I am using this website which has hyperlink for a number of companies. I want to extract the details of the companies. When I click the company, there is a hyperlink "Certificate" which has the name, ...
2
votes
2answers
21k views

Finding X on Excel scatter plot/trend line

If I have some data in an scatter plot in Excel, e.g. X Y 1 10 2 20 3 30 4 40 5 50 and I want to find the Y value for X = 10, or X=3.5, or whatever (obviously this is a simplified example) I've ...
0
votes
1answer
32 views

how to separate long text data of cell into two columns

I have Name and Address two details in one cell: NKG JAYANTI COFFEE PVT. LTD. 501 QUEENS CORNER, "A" 3 QUEENS ROAD, BANGALORE -560 001.KARNATAKA STATE. ALLANASONS LIMITED, CHANCO RESIDENCY NO.1/2 ...
1
vote
2answers
2k views

Cyrillic export from Excel to CSV

I have an application where I upload some content in CSV format, however the main document where I have my data is an Excel document. I use Save As » CSV in order to make a CSV file, but it is not ...
0
votes
1answer
50 views

Hierarchical data structure in pivot - blank rows

I have a data set with a structure in style of: Fruit Type Organic Sales Banana 15 Apple Green Apple Organic 20 Apple Red Apple ...
3
votes
2answers
4k views

Excel chart won't update, based on calculated cells

I have an Excel document (2007) with a chart (Clustered Column) that gets its Data Series from cells containing calculated values The calculated values never change directly, but only as a result of ...
36
votes
5answers
138k views

How to remove the print preview lines in Excel 2010?

Somehow or other I have managed to switch on the print margin lines in Excel 2010. I cannot seem to turn them off. I went to Page Layout->Page Setup->Print Area->Clear Print Area but the lines remain ...
1
vote
4answers
25k views

Excel or PPT: How to have two pie charts, but one legend

I would like to design a slide that shows two pie charts of the same size side-by-side, but with a single legend that is centered on the page beneath both charts. I can easily create one of the pies ...