Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft. Use this tag for problems specific to Excel 2007 for Windows.

learn more… | top users | synonyms (1)

40
votes
11answers
51k 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 | ...
19
votes
5answers
107k 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 ...
15
votes
2answers
83k 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 ...
8
votes
2answers
55k 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.
6
votes
4answers
66k 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: ...
20
votes
10answers
103k 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 ...
5
votes
2answers
8k 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 ...
4
votes
2answers
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 ...
4
votes
1answer
21k 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 ...
3
votes
1answer
6k 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 ...
4
votes
1answer
610 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 ...
26
votes
8answers
111k views

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?
13
votes
16answers
108k 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
6answers
46k 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 ...
9
votes
1answer
13k 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 ...
8
votes
3answers
37k views

Color Cell Based On Text Value

An Excel column contains a text value representing the category of that row. Is there a way to format all the cells having a distinct value a unique color without manually creating a conditional ...
6
votes
4answers
30k views

How do I merge two tables in Excel that have identical columns?

In Excel, I have a spreadsheet that pulls data from a SQL Database into a table and then generates a report based on that data. Unfortunately, the data in this SQL database is incomplete and I want to ...
4
votes
5answers
45k 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 ...
0
votes
4answers
3k 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 ...
6
votes
0answers
9k 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 ...
3
votes
2answers
1k views

How to save duplicate images in Excel to different JPEGs

I have an Excel sheet with images which are stored as objects in one column and product names in another. I was trying to extract all the images to JPEG files. I was able to achieve this by saving the ...
3
votes
2answers
1k 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 ...
3
votes
1answer
19k 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
3answers
87k views

How to Merge Data From Multiple Excel Files into a Single Excel File or Access Database?

I have a few dozen excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 master file which must have just 2 of the 4 worksheets. The ...
1
vote
3answers
15k 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
1answer
1k views

How do you plot time on the X axis in excel?

I need to plot the decay of my phone's battery against time over night. My starting time is 23:17:47 and my ending one is 07:05:49. I don't have any issue in changing the time format in the current ...
0
votes
2answers
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 ...
80
votes
4answers
37k views

Is it possible to paste CSV formatted data into Excel 2007?

I want to copy and paste CSV formatted text into Excel 2007. Is there a way of doing this without saving it to a temporary file first? I'm sure in previous versions of Excel there was a way to ...
25
votes
17answers
85k views

How to make cells perfect squares in Excel?

In Microsoft Excel, I want to make the height of first three rows and first four columns (12 cells in the top left corner) such that these cells are squares. How can this be done? Surprisingly, ...
13
votes
2answers
33k 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
3answers
6k 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
1answer
559 views

Replace cell references with values without F9 using macro

This is an Excel macro question. Given a series of formulas such as the following: = A1 + A2 = B2 + B2 etc., ... I would like to replace each of these cell references with the values without ...
3
votes
3answers
26k 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
1answer
117 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 ...
11
votes
2answers
10k views

Keyboard shortcut to switch between sheets in Excel

Does Excel 2007 have a keyboard shortcut that switchs between worksheets?
4
votes
1answer
36k 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
1answer
4k 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
2answers
411 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 ...
3
votes
3answers
13k views

How to sum numbers in a range that only have a particular cell color [Excel]?

I would like to put a formula in Excel that would sum all the numbers of a specific range that have a specific cell background color.
0
votes
2answers
6k views

How to automatically update values referenced from one sheet to another in excel

Here is my problem. I have 2 to 3 worksheets, and I need to make a master worksheet. The 2-3 worksheets contain the sales made in the day and the customer name. The problem is that new customers come ...
17
votes
3answers
59k 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?
13
votes
2answers
2k views

How can I get Excel's undo/redo functionality to work in a more traditional *per window* manner (and not for the entire instance of Excel)?

This has been driving me crazy lately. I'm not used to having having a program have a global undo/redo functionality (as in when I undo something, it will undo the last action in any currently open ...
6
votes
6answers
19k 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 ...
5
votes
4answers
15k 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
1answer
22k 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 ...
3
votes
2answers
15k 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 ...
3
votes
1answer
8k 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 ...
3
votes
1answer
3k views

Is there any way to suppress the Excel 2007 warning “in a different format than specified by the file extension”?

We have an application that exports data using the older Office XP/2003 XML Spreadsheet format. These files are saved with a .xls extension so that they can be launched directly, without having to ...
2
votes
1answer
3k 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
4answers
19k 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 ...