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
3answers
4k views

How do I add content to Excel cells?

How can I add a T to the content of each cell in a certain column (that contains 10000 cells) without typing it manually?
1
vote
3answers
3k views

How can I compare columns in Excel?

If I have two columns of data with 10000 cells in each, and only three of the rows are not identical in both columns, how can I locate the different ones (without comparing each pair of cells)?
2
votes
2answers
6k views

Excel - Dynamic row reference based on the row I paste a formula into?

I have a simple, oft-used formula that I paste as plain text into spreadsheets I receive. It looks something like this: =IF(D8="FOO", "BAR", "BAZ") It looks in D8 for the word "FOO". If it finds it ...
1
vote
1answer
941 views

Keyboard shortcut to insert into cell in MS Excel (2008) on a Mac?

Keyboard shortcut to insert into cell in MS Excel (2008) on a Mac? In Windows, F2 will put the cursor at the end of a cell's text. What's the keyboard shortcut to do this on a Mac?
4
votes
3answers
6k views

How to use WinMerge Excel plugin?

I know this works, because of this question - How do I compare two Excel documents? I have installed Newest WinMerge and http://freemind.s57.xrea.com/xdocdiffPlugin/en/index.html newest plugin(I ...
0
votes
1answer
524 views

Excel DataFlow UML Viewer/Navigator/Visualiser tool/ hint

Not sure what to call it but, is there a birds eye view tool for excel to show the data flow between excel sheets/cels etc? I have inherited some huge reports and looking at each cell to see where ...
0
votes
1answer
866 views

Select graph data to display using checkbox

I dont know if this can be done in excel or not. I tried to look around but could not find anything. Here is a simple example - There is a simple column graph for sales, expenditure and profits. There ...
0
votes
1answer
761 views

How can I prepare a pie chart in excel with a result based on 100%?

I have the total I've earned last year which should represent the 100% of the pie. Then I have my insurance expenses and I want to understand, graphically, how much of my total income went to pay ...
3
votes
3answers
19k views

How do you update an Excel file (Data Refresh and update formulas) WITHOUT opening the file?

I have an Excel file that want to update and save automatically with out having to open it or manually interact with. Manually, I open the file up and hit data refresh which goes and does a SQL query ...
2
votes
1answer
1k views

Macro name being changed in Excel

I am creating VBA macros in my Excel spreadsheet. I notice that from time to time (after saving the spreadsheet and reopening it, usually) one or more of the macro names is being changed from ...
1
vote
3answers
8k views

How do I assign a new keyboard shortcut in Excel 2010

I need a keyboard shortcut for Merge & Center. I'd like it to be ControlShiftM. I am unfamiliar with Macros as was suggested in another answer and when I go to Options, I can't find ...
3
votes
3answers
6k views

Formula in table header cells

I have a table in Excel 2007 that I want to summarise, in a similar fashion to a Pivot Table, but for various reasons I can't use a pivot table. I like the "Format as table" features of sort and ...
2
votes
3answers
790 views

How to copy a formula in excel without the cell number getting updated

I am trying to achieve the following scenario. value of G1 has formula set to (=F1) When I copy the formula to other cells in column G, I want the formula to saty same (=F1) instead of dynamically ...
1
vote
1answer
7k views

Excel Help: Fill Tool - Drag to the side (across columns) but increase the formula by Row Number

There are answers out there to this question, but all of them have been under explianed so hence to difficult to coprehend and use them to my advantage. I want to do the seemingly simple (but not) ...
2
votes
1answer
861 views

Two Spreadsheets, Merge Data?

I was wondering what is the best way to merge two spreadsheets which have the name id's e.g: One sheet has: apple 5 dog 3 cat 2 Second sheet: dog 4 apple 7 cat 3 I would ...
0
votes
1answer
3k views

Excel 2010: Create Graph From List

I have created a drop down list for use in each row (for the purpose of categorising). I'd like to graph the selected data (i.e the column of drop down lists) into a graph, probably a pie chart. If I ...
1
vote
2answers
3k views

How do I get a new column from a Sharepoint list into Excel?

I've been using Excel to process data from a Sharepoint list for a while now. However, I recently added a column to the Sharepoint table, and when I refresh the data in Excel, I don't get the new ...
2
votes
1answer
15k views

Importing CSV files into Excel using a macro

I want to develop a macro where in my Excel worksheet I type a date in a specific cell, and the macro will go into a folder containing text files. A database you could say. I want it to find the ...
12
votes
1answer
40k views

How do I put logical operators in an Excel =IF Formula?

I'm trying to enter a formula to display text according to an IF condition. The best I can manage is something like... =IF(myval>=minval & myval <= maxval, "OK", "Not OK") But this ...
1
vote
1answer
89 views

Using Conditional Formatting with Formulas

I have a spreadsheet with approximately 2000 rows. I want to color code the rows based on the following conditions: If T2 is less than U2, color the row red; if T2 is greater than U2, color ...
3
votes
2answers
572 views

Copy paste character limits between Access and Excel 2007?

I'm trying to copy-paste a query result from Access 2007 to Excel 2007 but some text columns that appear OK in Access are "cut-off" when pasting to Excel. How to paste this correctly, avoiding the ...
1
vote
2answers
10k views

Color drop down in Excel cell (with no text)? e.g. bgcolor = Red-Green-Amber-unknown

I have an Excel sheet that I'm using to keep track of the status of certain things. I want to have a column which consists of cells containing a repeated drop down that allows you to select (as ...
1
vote
2answers
10k views

Excel - Chart that sums the values in multiple rows for each series

Suppose I have a spread sheet that looks something like this... Now, I'd like to create a column chart that has 3 series, one for each country. Then, I want series for each category, but I want to ...
0
votes
3answers
1k views

When opening any file in excel, a 1 is added to ther name, and the default is to save a new copy…

Ok... I've searched a lot for this, but it's not an easy question to search for! When I open any files (xls, or xlsx) in Excel 2007, excel acts like it's a read only file, essentially creating a new ...
2
votes
1answer
190 views

Excel Help: Data Input Help

Everyday I download data from a site that will have rows each filled with individual data for clients. I'm able to input the data into excel as a whole but after that I'm having trouble figuring out ...
0
votes
1answer
104 views

Tools for reformatting a spreadsheet into PDF?

I'm looking for an easy way to produce nicely formatted PDF documents using a subset of data available in a spreadsheet. Ideally, I would be able to produce one or more PDF documents for each row int ...
2
votes
2answers
2k views

Merging duplicate rows in Excel 2003

I have a spreadsheet with two columns in the format: title A 300 title B 345 title A 25 title C 105 I would like to merge the rows with duplicate titles while totaling the numeric value so ...
6
votes
3answers
20k views

How can header cells in Excel be “pinned” or “frozen”? [duplicate]

Possible Duplicate: Excel: Keep part of a spreadsheet up during navigation How can you "pin" or "freeze" cells in the top row and/or leftmost column of an MS Excel sheet, so that they ...
1
vote
4answers
18k views

How to create a Wind Rose plot in Excel 2007?

I am attempting to create a wind rose graph, i.e. My data is wind speed and cardinal wind direction in separate columns: Wind (mph) Wind Direction 3.66 SE 2.69 SE 2.62 SW ...
6
votes
4answers
59k views

How to change x-axis min/max of Column chart in Excel?

Here i have a column chart of binomial distribution, showing how many times you can expect to roll a six in 235 dice rolls: Note: You could also call it a binomial mass distribution for p=1/6, ...
3
votes
2answers
1k views

How do I stop Excel from adding double quotes to my formula?

this works: {=MEDIAN((Table1[MonthFinish]=201012)*(Table1[Days]))} but if I put 201012 into cell A3, this doesn't done work: {=MEDIAN((Table1[MonthFinish]=A3)*(Table1[Days]))} when i do Evaluate ...
2
votes
5answers
372 views

Converting date format in formulas in Excel

what is the formula which would enable me to calculate the difference between 2 dates and 2 times? Example: In the same cell, I have 01 January 2005 07:30 and in a second cell i would have 06 January ...
1
vote
1answer
977 views

Advanced cell reference in excel

I would like to reference the cell "n" rows above the current cell, where n is an variable. I tried the "cell" function, but it doesn't allow me to use string as argument as I must pass the reference ...
1
vote
2answers
1k views

Merge two Excel sheets

I have two 'tabs' in my Excel file and I would like to merge the two tabs into one sheet (in the same file). The two files look somthing like: artnr language description price artnr ...
8
votes
1answer
7k views

Stop Excel recognizing a dash

How can I stop my text cells which start with a dash from turning into cells where Excel expects a formula?
2
votes
1answer
1k views

Pasting to Excel from Word - stop a Word new line being converted into a new cell

So I have a table in MS Word which has two columns. In the second column the text is spread on multiple lines, ie I have pressed 'Enter' to achieve this. When I paste into Excel, it converts these ...
3
votes
4answers
6k views

Running Excel 2007 as admin on Windows 7 causes “There was a problem sending the command to the program”

I am running Excel 2007 on Windows 7 64-bit. I need to run Excel as administrator so I have the "Run as Administrator" box in the Excel shortcut checked. Now, when I try to open an Excel file by ...
0
votes
2answers
5k views

Converting date format in formulas in Excel

I have a column of dates in the following format ddd mmm dd hh m:s "EST" yyyy. In another cell in another sheet, I wish to have the dates in the format dd/m/y. How can I do this? I already tried the ...
4
votes
1answer
5k views

Custom Validation - Dependent Drop Down Lists

I've two columns in a sheet that are interdependent and I want to use validation, drop-down lists, on both as follows: Column A (TYPE) | Column B (Sub-TYPE) ...
0
votes
2answers
736 views

interpolation chart in excel

My data is about real estate lots: area and price. The data is not sorted. How can I create a chart so that I can see the correlation between area and price? For example for: 500 1,000,000 450 ...
0
votes
1answer
1k views

Excel - “send to Mail recipient” creates 2nd copy of EMail in Inbox

When sending Excel sheets using the menu item "File" -> "Sent To" -> "Mail recipient (as attachment)" I get additional copies of the email in the Inbox. When I press "send" then I get 2 copies of the ...
2
votes
2answers
2k views

How to make Excel retain the contents of its clipboard

I'm making a list in Excel where many rows have the same data in a number of columns, enough so that I'd like to hit Ctrl-C once on this set of common data, and then just hit Ctrl-V every time I make ...
4
votes
1answer
98 views

Is it possible for Excel print consistently with any printer? avoid awkward page breaks?

Our organization has a hundred printer makes and models. We all use Office 2007, and we all print to letter size (8.5" x 11") paper. However, when someone distributes an Excel spreadsheet across our ...
0
votes
1answer
854 views

I have scanned a bunch of receipts and I want to scan/OCR their data into an excel file. How would I do this?

All the receipts have the same layout (i.e. their order list, transaction dates). I was wondering if my OCR program (Omnipage 17) could go to a certain co-ordinate and recognize the data, then some ...
1
vote
1answer
124 views

Is there a formula that I can use so that I can get a cell on Sheet 1 to have exactly the same formatting as a cell on Sheet 2?

I am using an excel spreadsheet to record skill competencies of staff. Sheet 1 will act as a "master" sheet reflecting the skill competencies of all staff (ie different employee in each column) and ...
2
votes
3answers
627 views

How can I single out unique values in Excel

I'm not sure unique is the right term but what I'm looking for is if I have column A with values 1,2,3,4,5 and column B with 3,4,5,6,7 I want the result to display 1,2,6,7.
1
vote
1answer
3k views

create tree structure in excel 2010 pivot table

I have a employee details data as follows: Name Reporting To Emp 1 Emp 10 Emp 2 Emp 10 Emp 3 Emp 1 Emp 4 Emp 2 Now, I want to pivot the data like Emp 10 -Emp 1 --Emp 3 -Emp 2 ...
11
votes
4answers
4k views

Is it possible to get the sheetname?

How can I get the sheet name in a cell? (I have more than one sheet, I want to get the current on each sheet)
2
votes
1answer
3k views

How to refresh pivot data in Excel 2010? (= F9 in 2003)

In Excel 2003 pressing F9 was refreshing the data in pivot table. How to achieve the same in Excel 2010?
1
vote
2answers
221 views

Excel merge columns problem

I have two columns that a client has sent me... unfortunately some contents are on another column. I want to make it so that all the data lines up in just column... how do I make this happen?