The 2010 version of Microsoft's spreadsheet application.

**3**

votes

**2**answers

5k views

### How do I use Excel 2010 Personal Macro Workbook?

I want all of my macros that I've written to always be available to me when I'm using MicroSoft Excel 2010. How can I do this?

**4**

votes

**1**answer

2k views

### Excel 2010 conditional formatting: selectively highlighting duplicates

I'm using Excel 2010 and would like to know if there's any way I can choose conditional formatting to highlight only instances of duplicates when it's found in ALL the columns I chose?
For instance, ...

**5**

votes

**1**answer

1k views

### Conditional formatting to highlight the whole row

I would like to highlight the whole row 5 if J5="T".
I used to do it with the old Excel, the 2010 conditional formatting ignores it. So my rule is like this and it does not work. I used the formula ...

**9**

votes

**2**answers

16k views

### How to control CSV import into Excel 2010

When I open CSV files in Excel 2010 I get entire rows in cells, not distributed according comma separation.
How to control this?

**24**

votes

**13**answers

164k views

### How to make Excel's “Auto Fit Row Height” feature actually auto fit the row height?

For every generation of Excel I can remember (including 2010, which I'm using now), Excel's "Auto Size Row" features sometimes fails to actually auto size a row when the cell contains wrapped text. ...

**4**

votes

**1**answer

3k views

### Why does Office 2010 fail to open an Excel file?

I have a excel file I've put on a file server. When required i access it via a dll, fill it with some data in background only (through ExecuteExcel functionality).
It used to work before. Recently I ...

**6**

votes

**3**answers

16k views

### Excel Scatter Chart with Labels

I have three columns of data. Column 1 has a short description, column 2 has a benefit number and column 3 has a cost. I can create a cost/benefit scatter chart, but what I want is to be able to ...

**1**

vote

**2**answers

10k views

### Microsoft Excel 2010 How to reference a table to another sheet

I am using Excel 2010.
I got a sheet name "March"
I would like to duplicate it[This is a table] (with reference / link) to another sheet called "Summary"
which included January, Feb, and March.
In ...

**12**

votes

**3**answers

3k views

### How to insert a date into an Excel spreadsheet?

I want to insert date and time into a cell of an Excel spreadsheet. NOW() and TODAY() don't fit my needs. These functions insert dynamic date. But I want static: if I insert the date it won't change ...

**4**

votes

**3**answers

5k views

### Why is Excel truncating my 16-digit numbers?

If I type in a 16 digit number (format: number, no decimals) it changes the number on me. Example: 1234567812345678 changes the view to 1234567812345670.
If I type it in as a general format it ...

**6**

votes

**4**answers

14k views

### Diagnosing slow Excel spreadsheets?

A client contacted me, complaining of Excel spreadsheets that were taking far too long to open. They use Excel for creating invoices, so they have hundreds of Excel spreadsheets with light formatting ...

**3**

votes

**1**answer

13k views

### Excel 2010: Can I hide columns without excluding the data from a graph?

In Excel 2010, is it possible to hide columns but still have the values show up in a graph?
I have a graph of monthly data going back to 2005, with each month's data in a column. If I hide the ...

**2**

votes

**2**answers

357 views

### Duplicating formula in Excel 2010

I have a bunch of formulas in a column that I wish to duplicate exactly into another column, where I will go through and tweak them so that a different function is run on the same parameters. When I ...

**1**

vote

**0**answers

2k views

### create Macro in VBA with colors if the value of the cell is greater than 100, the macro will change background color of the cell to blue

How can I create a macro in VBA that accomplishes the following: For the active cell, if the value of the cell is greater than a number, the macro will change background color of the cell .

**1**

vote

**2**answers

8k views

### Display Blank when Referencing Blank Cell in Excel 2010

I have an Excel 2010 workbook that contains a number of individual worksheets. The cells on one of the sheets are linked to individual cells on two other worksheets in the same workbook. I'm using a ...

**0**

votes

**2**answers

16k views

### How do you write an Excel formula that will paste a specific value in a different cell?

So basically I want to write a formula that will check a condition, and if that condition is met, then I want to paste a specific line of text in a different cell. I should note that I do not want the ...

**0**

votes

**2**answers

1k views

### How to convert column data into rows, grouped by identifier

I have data as shown below in two columns and I need to arrange them horizontally in a row for each individual.
Baker 17
Baker 37
Baker ...

**5**

votes

**3**answers

29k views

### convert text string to date/time format

I have a column that is text formatted like 20110408_2041. How can I format it to date/time format?

**4**

votes

**4**answers

6k views

### Why does this Excel file keep asking to save?

A client sent me some Excel .xlsx documents, and every time I open one of them and then close it, Excel asks if I would like to save changes, even if I didn't make any. This doesn't happen with any ...

**3**

votes

**1**answer

10k views

### Conditional formatting of TRUE / FALSE values in an Excel 2010 range

I have a range containing formulas that evaluate to TRUE or FALSE.
How would one apply conditional formatting to this range, so that TRUE cells are Green, and FALSE cells are RED?

**3**

votes

**3**answers

12k 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

**4**answers

13k views

### Why does Excel 2010 automatically reformat numbers?

Excel 2010 is automatically reformatting numbers/cells where a specific number format has already been applied. Whenever I access or modify the cell contents, Excel reformats by changing the number ...

**2**

votes

**3**answers

3k views

### Ctrl + Shift + Arrow stopped working

When I work with a big amount of data, I introduce formulas in Excel by using the shortcut: Ctrl+Shift+arrow. That shortcut allows me to select a whole set of data to the left, right, up or down. ...

**2**

votes

**1**answer

2k views

### Excel copy-paste is only copying as values, but I want it to copy formulas [closed]

In Excel, imagine the following numbers in these cells:
A1: 5
B1: 6
C1: =A1+B1 [Displays 11]
A5: 7
B5: 8
C5:
If I copy cell C1 and paste into C5, rather than copy the formula, which is what I ...

**2**

votes

**3**answers

17k views

### How to toggle Scroll Lock in Excel 2010 without a Scroll Lock key in the keyboard

I have a notebook with no Scroll Lock key (or any shortcut using the 'Fn' key).
Somehow Excel 2010 got the Scroll Lock on. I see it left down in the status bar and now I can't navigate through cells ...

**1**

vote

**1**answer

53 views

### Comparison of accounts in Excel windows 7 between two different sheets and combining in one list

'm an accountant and have two different sheets of different and/or the same accounts. I need from all those combine one total list (some are in both but some accounts only in one) - with vlookup I ...

**1**

vote

**2**answers

2k views

### Drawing a line graph in Excel with a numeric x-axis

In Microsoft Excel 2010, I'm trying to draw a line graph with three different lines. I've got the graph looking the way I want, with one exception: Excel is treating my X-axis column like text ...

**1**

vote

**1**answer

61 views

### Sorting cells in a column is easy. But how to sort cells in a row?

Assume school language learning exercise, based on making right order of words in a scrambled sentence.
Then put numbers into the next row, specifying the order the words should be in.
Now select ...

**1**

vote

**2**answers

4k views

### How to make a dropdown list such that… (see details)

I want to plot the stock prices of certain companies VS the S&P500. I have all the price data downloaded in my excel sheet already.
I want to create a line graph in Excel. One line is fixed and ...

**1**

vote

**2**answers

5k views

### COUNTIFS does not seem to count blank cells

I am trying to build a COUNTIF statement in Excel 2010 using a total of 4 sets of criteria. I would ideally like it to look something like this:
COUNTIFS(range1,value in a1,range2,value in ...

**0**

votes

**3**answers

160 views

### Conditional Formatting: 3 color scale showing text relevance in Excel for Mac

Is there a way to use conditional formatting in the following manner in Excel? (For those who are curious, I am using Excel 2010 for Mac)
I want Cell B2 to be green when A2 says "John likes green ...

**0**

votes

**1**answer

50 views

### Excel count all rows that contain certain values for certain fields

I have a sheet with a couple hundred rows. Each row has an 'owner' and a pass/fail field. I am making a second sheet that has statistics for the users. So for each user it will count the number of ...

**0**

votes

**1**answer

119 views

### Combination of multiple lists using formula

I have already asked a very similar question here, but I now want to do it automatically (using functions etc).
I'm an accountant and have two different sheets of different and/or the same accounts. ...

**-1**

votes

**1**answer

124 views

### How to get data from separate worksheets displayed in a single separate worksheet

I am working on a spreadsheet in Microsoft excel 2010. In the spreadsheet I have 3 worksheets. These are known as:
1st
2nd
Cases
Now in the 1st and 2nd Worksheets, there is a table at the bottom ...

**16**

votes

**7**answers

28k views

### Easiest way to open CSV with commas in Excel

CSV files are automatically associated with Excel but when I open them, all the rows are basically in the first column, like this:
It's probably because when Excel thinks "comma-separated values", ...

**3**

votes

**1**answer

156 views

### Randomize table guests in Excel

I have a list of people:
Column A:
person A,
person A guest,
person B,
person C,
person C guest,
...
Column B:
1,
1,
2,
3,
3,
...
So in column A ...

**7**

votes

**4**answers

14k views

### Is there an Excel function to create a hash value?

I'm working with a number of data lists that are keyed by document name. The document names, while very descriptive, are quite cumbersome if I need to view them on (up to 256 bytes is a lot of real ...

**4**

votes

**2**answers

2k views

### How can I alternate grid background color in excel when a value of a single column changes?

How can I alternate grid background color in excel when a value of a single column changes?
Such as this:
I would want to do this with conditional formatting, but I can't figure out how to.

**8**

votes

**2**answers

1k views

### Prevent Excel from clearing copied data for pasting, after certain operations, without Office clipboard

Whenever you copy a cell or a range of cells in Excel (my version is 2010 on Windows 7), and then do something else like insert new sheet row or simply edit another cell, Excel removes the clipboard ...

**6**

votes

**6**answers

80k views

### How do I resolve the error “Excel found unreadable content in (filename)”?

Has anyone else seen this? Sometimes when I open certain worksheets in Excel 2010 I see the message in the title. Excel then asks if I want to repair the file. I say "Yes" and Excel reports that ...

**4**

votes

**9**answers

26k views

### Copy Excel worksheet and maintain relative cell reference in formulas

Another copy problem in Excel:
How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula =B!23 becomes ...

**4**

votes

**1**answer

4k views

### Using INDIRECT and AND/IF for conditional formatting

I am having some issues with using INDIRECT to apply conditional formatting.
I have column G which carries a percentage. I want to conditionally format column H based on the percentage being greater ...

**3**

votes

**2**answers

6k views

### Alternate grid background color in excel when a value of a single column changes?

I need a formula for conditional formatting to make an Excel 2010 spreadsheet alternate highlighting when a single column changes. This question, "How can I alternate grid background color in excel ...

**12**

votes

**3**answers

49k views

### What is the maximum allowed rows in a Microsoft Excel .xls or .xlsx

Is there a limit? I couldn't find one posted.

**6**

votes

**1**answer

2k views

### How do I keep Conditional Formatting formulas and ranges from automatically changing?

I've found that Conditional Formatting formulas and ranges will automatically adjust when you copy, delete, or move data around in a spreadsheet. While this is a nice idea, it tends to break things ...

**3**

votes

**2**answers

8k views

### How do I split one row into multiple rows with Excel?

I have a product database in Excel with several hundred entries, each of which has from 1 to 3 "tiers" of pricing: Standard, Deluxe, and Premium. Each tier has its own SKU (A, B, or C added on to the ...

**3**

votes

**1**answer

7k views

### Excel generate and format horizontal error bars

I have been trying to generate and format horizontal and vertical error bars in Excel 2010, and there is no problem with the vertical ones, but I cannot figure out how to manage horizontal error bars.
...

**3**

votes

**1**answer

2k views

### Coloring partial text within cell in Excel

In Excel there are several ways to dynamically color a full cell based off of its value, but is there any way to dynamically color only part of the cell based on its value?
For example, say I am ...

**3**

votes

**2**answers

11k views

### Comparing Similar Text Strings in Excel

I am currently trying to reconcile “Name” fields from two separate data sources. I have a number of names that are not an exact match but are close enough to be considered matched (examples below). ...

**2**

votes

**1**answer

122 views

### Any way to have Excel 2010 treat a quoted value “08540” as text not number when opening a CSV

I have a CSV with data like this:
"08540",1,"PRINCETON","NJ"
I know that it is possible to specify "Text" when using the Import Wizard and defining columns. But is there a way to tell Excel to ...