**0**

votes

**3**answers

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

**3**answers

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

**2**answers

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**3**answers

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

**3**answers

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**2**answers

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

**3**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**3**answers

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

**4**answers

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

**4**answers

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

**2**answers

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

**5**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**4**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**4**answers

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

**1**answer

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

**2**answers

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?