The 2003 version of Microsoft's spreadsheet application.

**3**

votes

**9**answers

38k views

### Adding more than 15 digits in Excel

I want to add more than 20 digits in an Excel cell.
The current format of the cell is general, it converts the number to an exponential format. I tried with a number format and accounting, but when I ...

**21**

votes

**7**answers

84k views

### Export an Excel spreadsheet to fixed-width text file?

Excel has the functionality to import fixed-width text files where it presents a dialog that lets you choose where the begins and ends of fields are which it puts into columns.
Does it also have ...

**1**

vote

**1**answer

656 views

### Microsoft Excel 2003 - Merge by Column

I'm trying to merge two excel files, here is the structure of the files:
[A] [B]
I want to add the column B from one file to another as column C, but the thing is that they have some rows under A ...

**63**

votes

**6**answers

271k views

### Cells not updating automatically

I have a formula in a cell which counts the values in 2 other cells. Normally, after entering in the values in these 2 other cells, the formula cell updates automatically when Enter is pressed or when ...

**0**

votes

**4**answers

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

**50**

votes

**3**answers

13k views

### Excel: how to undo in current file only?

Microsoft Excel's undo / redo feature behaves unlike any other program I know. The undo stack seems to be global across all open files, so that undoing sometimes switches to another file and undoes ...

**7**

votes

**4**answers

27k views

### Why is Excel removing leading leading zeros when displaying CSV data?

I have a CSV text file with the following content:
"Col1","Col2"
"01",A
"2",B
"10", C
When I open it up with Excel, it displays as shown here:
Note that Cell 2A attempts to display "01" as a ...

**5**

votes

**4**answers

35k views

### How to avoid double quotes when saving Excel file as Unicode?

I have an Excel file with Unicode content of which some cells contain text inside double quotes, for example "text".
When I save the Excel file to a text file in Unicode format, the text which ...

**1**

vote

**1**answer

2k views

### COUNTIF Duplicate Detection

I have created a formula (excel 2003) to output a "1" if duplicates are found in a column.
=IF(COUNTIF(A$2:A$10750,A2)>1,"1","")
For some reason this formula does not mark the last duplicate in the ...

**3**

votes

**5**answers

49k views

### How to get excel row numbers to skip the header

This is really a cosmetic question. Excel by default starts counting from line one which is the header. Is there some way to have it start counting from the real line one (the line after the header). ...

**3**

votes

**1**answer

4k views

### Excel (.xls) files not opening in Excel when launched from Explorer

I appear to have done something to Excel (2003) whereby whenever I double-click on an Excel file (.xls) in Windows Explorer, Excel launches OK, but the corresponding workbook doesn't open, and I'm ...

**2**

votes

**1**answer

335 views

### how to determine which values in a given set of cells will add up to a numerical range

In other words, I'm looking for a sum range that consists of combinations of cells from an array. Given a set of numbers:
1 720 56 17 59 120 153 203 39 1 690 583 582 561 256 310 232 95 108 16
26 ...

**0**

votes

**1**answer

59 views

### Weird Excel bar diagram behaviour

I have a very simple question. I wanna have a diagram with the
following table
Apple 30 40 50
Pears 200 300 400
Bananas 10 20 30
The weird thing, when I try to draw a bar diagram the order ...

**9**

votes

**4**answers

57k views

### Select each nth row in Excel

I have an Excel spreadsheet with thousands of rows. I want to select every 7th row from that spreadsheet. (By "select," I mean delete all of the other rows, or copy the selected rows into a new ...

**10**

votes

**2**answers

34k views

### Hyperlink font in Excel always changes to the default font face/size

For cells containing hyperlinks the font changes automatically into the default one (even though I have selected all cells and applied a different font).
How can you configure Excel to use the same ...

**20**

votes

**1**answer

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

**13**

votes

**2**answers

58k views

### Merge two excel files using a common column

I have two excel sheets. I have to merge the two such that the values in one match with the other. For eg.
The first excel, the 2nd excel
1 t 1 tes1
2 5 3 ...

**3**

votes

**2**answers

38k views

### Fill an area between two lines in a chart in Excel

There are a lot of hacks to fill the area between two lines in a chart; however, I want one that works seamlessly between 2003/2007 and mac 2011. Preferably, something that is not a hack.

**4**

votes

**4**answers

12k views

### Using two conditions with a SUMIF function in Excel 2003

For a given row on Sheet1, I use the SUMIF function to see if the value from the first cell of that row is on a list of historical values in Sheet2.
That will basically summarize all the values on my ...

**1**

vote

**5**answers

662 views

### Unable to create charts for all values in an entire column in Excel 2003

My Excel data looks like this: (it's a lot bigger in fact)
code1 code2 01/08 02/08
X A 12 10
X B 8 15
Y A 52 0
Y B 5 5
Every day I ...

**0**

votes

**2**answers

1k views

### Remove duplicate rows in excel when not all the columns are the same

How can I automatically remove duplicate rows in Excel when data->filter doesn't work, because the columns aren't all the same?
I believe the picture explains what I need, but I can probably supply a ...

**5**

votes

**2**answers

21k views

### How to change font color in Excel based on cell value?

How do you change the font color of a column of cells based on their entered value? I've got a column with the heading at row 1 and the values starting at row 2 going on down. I want to change font ...

**4**

votes

**4**answers

34k views

### Too much text for an Excel cell — how to make the cell scrollable

What do I do when I have more text in an Excel cell than I want to show in the allocated space?
Something making it "scrollable" would be preferred.

**2**

votes

**1**answer

942 views

### Automatically select last row in a set in Excel

In Excel 2003, I am trying to keep track of some petty cash, and have it set up with the denomination along the top row, along with a sub total and difference column. I want a small section that shows ...

**2**

votes

**1**answer

1k views

### In Excel, how to group data by date, and then do operations on the data?

I have Excel 2003. My data is like this:
01/10/2010 0.99
02/10/2010 1.49
02/10/2010 0.99
02/10/2010 0.99
02/10/2010 0.99
03/10/2010 1.49
03/10/2010 1.49
03/10/2010 0.99
etc. In fact it is a list of ...

**1**

vote

**0**answers

208 views

### Opening an Excel 2003 workbook in Excel 2010 32-bit causes bogus circular reference and crashes

We have a workbook that we have been using daily for many years in Excel 2003.
We are now migrating to Excel 2010, and have encountered the following problem.
When the workbook is opened in 2010 ...

**1**

vote

**0**answers

671 views

### Opening an Excel 2003 workbook in Excel 2010 32-bit causes bogus circular reference and crashes

We have a workbook that we have been using daily for many years in Excel 2003.
We are now migrating to Excel 2010, and have encountered the following problem.
When the workbook is opened in 2010 ...

**1**

vote

**1**answer

2k views

### How to use multiple criteria with COUNTIF?

INPUT:
This is the format of the OUTPUT desired:
OUTPUT for example INPUT:
The problem is, I don't know how to use COUNTIF with several criteria.
The "dream function" [that doesn't work] ...

**1**

vote

**4**answers

1k views

### calculate time differences in excel 2003

I have a goal of 2h47m00s minutes per month. If I attend let's say 1h20m00s and when my Excel cell format is:
[Red]-[m]:ss;[Blue][m]:ss
...then it gives me in red color 87 minutes time difference ...

**0**

votes

**1**answer

28 views

### How do I copy list to another spreadsheet only if items have been paid?

I have a list of invoices. I want only the invoices that have been paid to be copied to another worksheet. My column headings are:
Inv. # / Date of Inv. / Amount / Customer Name / Date Paid / ...

**0**

votes

**1**answer

122 views

### How to extract reminder of a match in MS Excel 2003

I tried using various combinations of functions but it seems that there's no specific function can return non-searched/matched values. Doing it manually takes days cause of the large amount data that ...