The 2003 version of Microsoft's spreadsheet application.

**2**

votes

**8**answers

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

**1**

vote

**1**answer

581 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 ...

**55**

votes

**6**answers

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

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

**45**

votes

**3**answers

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

**19**

votes

**7**answers

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

**6**

votes

**3**answers

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

**5**answers

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

**8**

votes

**5**answers

59k views

### How to get time difference as minutes in Excel?

I have time values in two cells in an Excel sheet and I need the difference of
the times in minutes.
The cells in the Excel are like below:
A B C
1 6:38 8:23 1:45:00
A is ...

**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 ...

**2**

votes

**1**answer

315 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

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

**9**

votes

**2**answers

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

**18**

votes

**1**answer

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

**11**

votes

**2**answers

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

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

**3**

votes

**4**answers

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

637 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

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

**3**

votes

**4**answers

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

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

195 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

613 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

810 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 ...

**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

27 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

105 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 ...