**32**

votes

**9**answers

39k views

### Is it possible to “unpivot” or “reverse pivot” in Excel?

I have data that looks like this:
Id | Loc1 | Loc2 | Loc3 | Loc4
------------------------------
1 | NY | CA | TX | IL
2 | WA | OR | NH | RI
And I want to convert it to this:
Id | ...

**15**

votes

**5**answers

75k views

### Need two excel windows side by side, on different monitors, in the same instance

I have to do work between two spreadsheets and I need to view them side by side.
I can't just open the workbooks in separate instances because I need to make use of features like paste formatting, and ...

**6**

votes

**4**answers

47k views

### How to combine values from multiple rows into a single row in Excel?

I have a data dump in Excel that consists of annual customer data for two different values. The data was provided with a separate row for value for every year and customer. I.e. it looks like this:
...

**12**

votes

**2**answers

65k views

### Run an SQL Query With a Parameter from Excel 2007

I have a query in an excel table. I followed this to do it.
But how can I add a parameter from a cell into my query?
I am looking for a way to do this
select *
from dbo.Customers
where CustomerID ...

**7**

votes

**2**answers

36k views

### Excel: Find a subset of numbers that add to a given total?

I have a column of numbers (lets say it's A1:A100) and I need to find a subset of them that sum to a certain total.

**13**

votes

**9**answers

63k views

### Excel Auto-Fill Without Mouse (Keyboard Only)

So when I want to extend a series or something along those lines, I can highlight a group of cells, then click on the bottom right corner of the highlighting box and drag down. Excel will then ...

**4**

votes

**2**answers

4k views

### Excel 2007 transpose/combine multiple rows into one

I have data like so:
1001NCCN 3618127
1001NCCN 208478
1001NCCN 207316
1001TEMN 409889
1001TEMN 801651
1001TEMN 273134
1001TEMN 208478
1001TEMN 207316
I need to ...

**3**

votes

**1**answer

16k views

### In excel, cannot figure out why background color for a cell will not change?

Ok, so I inherited an excel workbook full of excel forms to modify. I am not the original author of the form. I cannot for the life of me figure out why it wont let me change the background color of ...

**19**

votes

**7**answers

80k views

### Excel: Find Items in one column that are not in another column

I have two columns in excel, and I want to find (preferably highlight) the items that are in column B, but not in column A.
What's the quickest way to do this?

**12**

votes

**16**answers

83k views

### How to get the current column name in Excel?

What is the function to get the current line number and the current column name for a cell in Excel?

**9**

votes

**1**answer

11k views

### How can you make Excel 2007 stop formatting large numbers as scientific notation?

Kind of the inverse of this question.
I frequently download CSVs from outside sources as part of my programming work. I like to examine their data in Excel because, let's face it, Excel is an ideal ...

**3**

votes

**5**answers

34k views

### Can I split a spreadsheet into multiple files based on a column in Excel 2007?

Is there a way in Excel to split a large file into a series of smaller ones, based on the contents of a single column?
eg: I have a file of sales data for all sales reps. I need to send them a file ...

**8**

votes

**6**answers

38k views

### How to turn hundreds of text URLs in Excel into clickable hyperlinks?

How do I turn a column of urls into hyperlinks, so that users can click on the url in a cell and have it open in a browser?
I pasted 100 urls and each went into its own cell. When I double-click in ...

**4**

votes

**2**answers

5k views

### Excel-Count number of visible cells containing certain string

I have a sheet in which I first apply a filter to a certain column to show "Unique records only". Now I have a column which contains, for e.g., values like:
Applepie
Applesauce
Crabapple
Banana
Mango
...

**6**

votes

**0**answers

8k views

### How can I force Excel 2007 on Windows 7 to always open another instance of the application? [duplicate]

I want to be able to compare to large spreadsheets side by side...
Since you can not natively expand to all monitors I would like to have the two documents open in two instances. These files are ...

**4**

votes

**1**answer

350 views

### Excel: Dual graded color scales

Is it possible to do conditional formating for two graded color scales over the same cells?
For example I wish to conditionally format a cell such that its color is:
Green to Blue graded scale for ...

**3**

votes

**2**answers

672 views

### Find the number of occurrence of a word in Excel 2007

How can I count the amount of occurrence in Excel 2007? The desired outcome should be something like:
apple 1
berry 2
coconut 3
donut 2
grape 1
lime 1
I have tried =COUNTIF($A:$A,A7), but that ...

**2**

votes

**1**answer

11k views

### Formatting a column based on another columns cell TEXT (not value) in Excel [duplicate]

Possible Duplicate:
Excel 2010 conditional formatting: selectively highlighting duplicates
I have dates that are running off a formula in that column based on information it's collecting ...

**1**

vote

**3**answers

9k views

### How to identify cells in Column A that contain any of the values in Column B

First off, I'm not that advanced of an Excel user. I'm certain Excel can do what I'm about to ask, but I've yet to find a way in any of my attempts or searches.
My question is very similar to Find if ...

**0**

votes

**2**answers

2k views

### Comparing two columns in Microsoft Excel

I'm attempting to compare two columns of data. One column (column G) is a "master" list with all account numbers in it and the other column (column A) only has a partial list of account numbers.
I'm ...

**10**

votes

**2**answers

22k views

### How can I prevent the privacy warning in Excel?

I have Excel 2007. When I want to save a spreadsheet, I often see this message:
I've seen this with macro spreadsheets (using the .xlsm extension) and with non-macro sheets (using the .xlsx ...

**2**

votes

**3**answers

3k views

### “Remove Duplicates” feature does not remove all duplicates

When the Data Tools>Remove Duplicates command is used on the following list, some duplicates are not removed:
Key
46509
46509
51442
51442
73367
73367
80048
80048
88396
88396
102576
102576
108095
...

**3**

votes

**3**answers

17k views

### Subtracting cells only if they have a value in Excel

I want to subtract two cells in excel but only if both cells have a value. More specifiaclly in my case the formula in cell E2 is currently =D2-C2 but I only want this to be calculated when D2 has a ...

**1**

vote

**1**answer

106 views

### Get Excel not to equally space values along the y-axis

I am graphing the height above sea level obtained by GPS at 12 measuring stations, which are distributed along a straight line but NOT equidistantly.
Excel does a nice job of creating a suitable Y ...

**9**

votes

**2**answers

7k views

### Keyboard shortcut to switch between sheets in Excel

Does Excel 2007 have a keyboard shortcut that switchs between worksheets?

**4**

votes

**1**answer

27k views

### Inserting a (jpg) picture into a cell in Microsoft Excel 2007

Is it possible to insert a jpg image inside a cell, or do Excel cells only display alphanumeric characters (or references)?

**3**

votes

**1**answer

2k views

### possible to have two Y axes and two X axes on same chart

Is it possible to have a chart with
left Y axis
right Y axis
top X axis
bottom X axis
all on same chart?

**3**

votes

**2**answers

328 views

### Drawing sample points versus time in Excel

I have a set of data as follow:
As you can see the first column has either R or P, the second column is a measured value, and third one is obviously time.
I need to present this in a chart (I ...

**0**

votes

**3**answers

2k views

### custom format for cells with nothing in them without using conditional formatting

if a cell is blank I would like to add text using a custom format. I've seen where text is added if a value is above or below a certain value. Can you add text to the cell if the cell is blank? I've ...

**12**

votes

**3**answers

32k views

### Turn off scientific notation in Excel

I would like to prevent Excel behavior that any large number I enter is stored as a number, then abbreviated to scientific notation.
Is it possible to tell Excel 2007 to stop doing this?

**5**

votes

**4**answers

9k 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 ...

**4**

votes

**6**answers

14k views

### How can I make Excel documents open in different windows?

Office 2007, Windows Server 2008 x64.
How can I make Excel so that when I double-click a document, it opens in a new Excel instance, so that I can easily view them side-by-side as separate windows ...

**3**

votes

**1**answer

3k views

### Show Excel column filter information in cells

We have a sheet with a huge number of columns and filtering is often used to navigate to the correct data. The problem is that sometimes its not obvious that the filter has been applied , the visual ...

**2**

votes

**1**answer

980 views

### How do I filter on bold, struck through or italic text in Excel 2007?

Is it possible to filter an Excel column based on the format of the text, such as whether it's bold, italic or struck through?

**2**

votes

**3**answers

12k views

### Excel ran out of resources while attempting to calculate one or more formulas

I received the error message
"Excel ran out of resources while attempting to calculate one or more formulas"
on ONE of my computers (Out of 2).
My worksheet contains: (Inside a single worksheet, not ...

**2**

votes

**1**answer

6k views

### Compare 2 text cells and show difference in the third cell

If cell A1 = abcd, cell B1 = abcdefg, then what formula to use in order to get the text difference efg?

**2**

votes

**1**answer

16k views

### Excel, how to find column number of min value?

I have a table in Excel.
Can anyone help me find the column number of the cell where the min value of the row is?
Example: 200 is the min value in row1 and has the column number 1.
Is there a ...

**2**

votes

**1**answer

245 views

### Is Workbook.FileFormat available to the Excel UI (specifically when the file type can't be saved)

As a programmer I eventually located the file type of a .d extension file loaded successfully by Excel 2007 by interrogating Workbook.FileFormat via VBA, but can a normal user determine it is a DBF4 ...

**2**

votes

**2**answers

13k views

### Excel cells - show text different to the actual value?

Is it possible in Excel to have a cell show text that is different from its value?
I would like to have a a cell that has the value 1,2,3 ... or 7 but it will show day of the week as text - but when ...

**2**

votes

**1**answer

7k views

### Strip out all HTML Tags from an excel file

I have an excel file that has cells with text that includes HTML tags.
The data was exported from a database and the HTML tags were included.
The HTML is stored as text, but I need it gone.
Is ...

**1**

vote

**1**answer

28 views

### can someone help me with my Formula Excel need it show blank

=IF(NOW()-B4>=15,"OK","Warning - Time to Renew")
that is the formula, but can it stay Blank until a date is put into cell B4
thanks

**1**

vote

**1**answer

752 views

### How to compare cell contents in Excel?

I have an Excel sheet. Row number 2 contains date values in each cell. For each cell in the sheet I want to check if the value in row 2 in my column equals some cell (let's say EG67, also dates).
How ...

**1**

vote

**2**answers

3k views

### Excel: Merge two tables based on one column

I have two Excel 2007 sheets A,B with the same columns.
B contains less rows, but has a column with updated data (i.e. data in this column is newer than in the same column in A). I want to take every ...

**1**

vote

**2**answers

2k views

### View linked Excel 'Windows' on separate screens

A colleague had a problem where he couldn't link a cell in his destination workbook with a series of cells in a source workbook. The problem was that in order to link workbooks, he had to open them ...

**1**

vote

**1**answer

1k views

### Excel 2007 Conditional Formatting is not properly using custom formula provided

In Excel 2007, I want to conditionally color a row if it is odd numbered and then vary the coloring depending on if a specific cell (in column E) in that row contains a number (green) or empty(red). ...

**0**

votes

**1**answer

24 views

### How to merge to excel column into one from two sheets in third sheet?

As mentioned in image from the link here How to merge two Excel columns into one? and the solutionis from the same sheet. I am looking for the merging of column A in 'sheet 1' and column A in 'sheet ...

**0**

votes

**1**answer

3k views

### How to Find and Replace worksheet name in a formula?

I have 100 worksheets with different names saved in a folder. I have another worksheet in another folder where I conduct analysis of data from one of those 100 worksheets. In this analysis worksheet, ...

**0**

votes

**1**answer

207 views

### MS Query unresponsive after launching in Excel 2007

User is launching MS Query from within Excel 2007 querying a database and then MS Query becomes unresponsive staying minimized to the task bar. Any assistance would be appreciated, the user is able to ...

**0**

votes

**4**answers

3k views

### Excel 2007 user warning when opening xls files

I am getting the following error warning when opening an .xls file generated using 'CarlosAg.ExcelXmlWriter.dll' in Excel 2007:
The file you are trying to open,'', is in a different format than ...

**0**

votes

**2**answers

4k views

### Excel Sum that excludes duplicates

I have data in the following format:
Id Value
------------
1 20
2 40
3 20
3 20
4 50
I want to sum the value column while excluding duplicates from the id column. In this ...