The 2003 version of Microsoft's spreadsheet application.

**51**

votes

**6**answers

134k views

### Cells not updating automatically

I seem to have a problem with an excel file. I have a formula in a cell which counts the values in 2 other cells, however, normally after entering in the values in the 2 other cells, the formula cell ...

**40**

votes

**2**answers

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

**18**

votes

**7**answers

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

**17**

votes

**1**answer

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

**12**

votes

**1**answer

23k views

### Allow two possible values in an Excel cell

I would like to create a cell format for one cell to only allow the value "yes" or "no" for this cell.
How could I do this?

**9**

votes

**4**answers

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

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

**9**

votes

**2**answers

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

**8**

votes

**7**answers

20k views

### Excel's date format without a year

I'm putting in employees' birthdays, but they come without years for sensitivity reasons. But when I put the month and day in, Excel automatically adds 2012 as the year! Obviously this is not right. I ...

**7**

votes

**5**answers

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

**7**

votes

**4**answers

67k views

### How to open ods files in Excel?

What is the best way to open ods files in Excel 2003?
Is there some plug-in available? Should I use some convertor to xls? Or would it be best if I just used LibreOffice (or OpenOffice)?
The file I ...

**7**

votes

**2**answers

99 views

### Migrating from VBA Excel 2003

I have a series of big excel files that work like a program, but I hate beeing tied up (stuck in VBA for excel 2003), so...
Whats the best way to implement a gui over a excel vba program (office ...

**6**

votes

**3**answers

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

**3**answers

5k views

### Converting decimal number of hours into time

I need to convert number of hours, such as 156.90 to 156:54 in excel 2003.
All of the conversions I found did this incorrectly. The number of hours shouldn't be changed, only the decimal.

**5**

votes

**4**answers

11k views

### Make Excel 2003 Open Spreadsheets in new instances

In Excel 2003, It seems to be putting each spreadsheet I open into the existing Excel application as a new window. this makes it very difficult in a dual monitor set up to put one spreadsheet on each ...

**5**

votes

**5**answers

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

**5**

votes

**2**answers

8k views

### How do I force a user to use a specific format when entering time data?

I need to ensure the users of a particular spreadsheet are entering the time data in military time. I'm finding some folks are omitting the colon, and it's causing problems. Is there a way to force ...

**5**

votes

**3**answers

12k views

### Excel 2010 data validation warning (compatibility mode)

We have some legacy worksheets that were created in Excel 2003, which are used by LabVIEW-based test automation software. The current LabVIEW software can only handle the legacy .xls format, so we're ...

**5**

votes

**3**answers

3k views

### How can I change the z-order of data series on the secondary y-axis relative to those on the primary y-axis in Excel 2003?

In Excel 2003, it's possible to change the z-order (i.e. what plots on top) of data series plotted on an axis by right-clicking a point of one of the series, choosing "Format Data Series", and then ...

**4**

votes

**2**answers

14k views

### How to copy a single cell into multiple worksheets in Excel?

I have about 30 worksheets, and I need to put my name on the top left corner (cell A1). Is there an easy way to do this without having to write it or paste it into every worksheet?

**4**

votes

**1**answer

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

**2**answers

8k views

### Restrict and validate date format in Excel

I'm trying to put together a 'Data Validation' formula which restricts the user to entering a date in the following format: dd-mm-yy.
From the research I've done, I've come across what I thought ...

**3**

votes

**2**answers

328 views

### Excel cutting out down over 1024 characters

I am using Excel 2003 to save a large file as a CSV.
But when saving cells that contain over 1024 characters, it cuts out the characters beyond 1024.
Per a previous question, I am using this ...

**3**

votes

**4**answers

18k views

### How do I convert all the cells of an excel sheet to text?

Given an existing Excel 2003 document with cells of any type (integers, text, decimal, etc), how do I convert the contents of every cell to text?
And save all these changes in the same excel ...

**3**

votes

**2**answers

2k views

### How to prevent users to change cells but allow VBA to change them

I'm using a Excel spreadsheet to record staff resource. In column B, there is a value of "Enter your name", which instructs the user where to start entering their information. Then, when the user ...

**3**

votes

**4**answers

11k views

### Move to end of selection in MS Excel (2003)

I have a large set of data that I update regularly by copy/pasting and overwriting old data. I do this for 10k-15k records at a time. Once I have pasted, I manually scroll down to the last line of ...

**3**

votes

**4**answers

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

**3**

votes

**3**answers

6k views

### 255 Character limit on VLOOKUP

Using excel 2003, the formula:
=VLOOKUP(D1 ,A1:B135, 2)
fails if the length of D1 exceeds 255 characters (i.e. the list has some text longer then 255 characters, D1 has the same text value, and ...

**3**

votes

**2**answers

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

**3**

votes

**1**answer

3k views

### Excel 2003: open spreadsheet and run macro from command line

The need: run a macro within an excel 2003 file every week, automatically, than save the file.
The approach: add an action to task manager for every week, calling the file with command line ...

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

**3**

votes

**2**answers

4k views

### Excel 2003 - how do I dock\fixate a row\column?

how do I create a docked row\column so that when I scroll down\right, I can still see that row?

**3**

votes

**4**answers

6k views

### Excel formula to display a string of text and numbers

I need one column to show the following text: prxyz,(data1 here),0699,ABCD(data2 here),xxx
data1 is in column A and data2 is in column B.
the format of data1 needs to be 5 numbers (sometimes ...

**3**

votes

**3**answers

5k views

### How do I exit Excel full screen after switching desktops using MSVDM

When I switch desktops with MSVDM (Microsoft Virtual Desktop Manager) Excel goes into some kind of full screen mode, where no tool bars or menus are visible in the Excel window. Then I can not find ...

**3**

votes

**2**answers

2k views

### Need formula or lookup command to find the next highest date in a list in Excel 2003

I have an excel spreadsheet that uses a variety of formulas and returns the dates that certain events will happen - actually, dates that I need to do certain things. The spreadsheet is in no order ...

**3**

votes

**0**answers

253 views

### Why is the maximum row height in Excel 546px?

The maximum height of a single row in Excel 2003 is 546 pixels, or 409.5 points:
http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx
I'm curious as to why ...

**2**

votes

**8**answers

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

**2**

votes

**5**answers

4k views

### Stop MS Excel 2003 closing all open workbooks

I have noticed that when I have multiple workbooks open with MS Excel and I close one, excel will attempt to close them all. This is extremely frustrating and has resulted in me losing work on many ...

**2**

votes

**2**answers

108 views

### Why is this simple Excel calculation not netting Zero?

It's supposed to be zero but for some reason the result produces a peculiar series of digits at the end.
Also, here's the .xlsx of it: http://83.212.111.36/Book1.xlsx

**2**

votes

**5**answers

2k views

### Excel not properly recalculating values

I have an Excel sheet with values in it (this sheet is generated by a custom perl script, but I don't think that's where the problem lies). In it, I have a formula:
...

**2**

votes

**3**answers

13k views

### Excel 2003 upgrading to Excel 2010, will it break our models?

My office is upgrading from Excel 2003 to Excel 2010 and we have a lot of tools in Excel 2003 (complex custom formulas, named ranges, VBA, pivots... almost every feature of excel can be found in at ...

**2**

votes

**2**answers

28k views

### Excel: how to add cells to named range

I have a named range for 3 cells in excel 2003
I need to insert 1 more cell into this named range
how do I achieve this in excel 2003

**2**

votes

**2**answers

742 views

### Rearranging a 15 X 25 Excel matrix into three columns

In Excel I have data in cells from A1 to O5 (15 X 25).
I wish to rearrange things such that I have the following
[A1][B1][C1]
[D1][E1][F1]
[G1][H1][I1]
[J1][K1][L1]
...

**2**

votes

**1**answer

664 views

### Is there a keyboard shortcut to circularly switch sheets in Excel?

In this question, he was asking about keyboard shortcut to switch tabs. But this shortcut moves the sheet backward or forward, which means that pressing Ctrl+PageUp on the last sheet doesn't move the ...

**2**

votes

**3**answers

3k views

### Excel Pivot Table Date Range as Columns

I have the following data which I wish to pivot:
Student JoinDate ReleaseDate
John 01/05/2011 05/05/2011
James 02/05/2011 04/05/2011
I would like to create a pivot table which ...

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

**2**

votes

**2**answers

19k views

### Converting excel 2007 files to excel 2003

I'm currently using a library named http://www.codeplex.com/ExcelPackage>ExcelPackage to generate a large number of excel files.
Unfortunately it saves in an xlsx format, the Excel 2007 OOXML format. ...

**2**

votes

**5**answers

367 views

### troublesome microsoft excel 2003

Hi I have a problem with my excel .. I want to paste one bunch of rows to another excel document and I can't do it with simple copy/paste ..
I can copy then paste to notepad then
copy again and ...

**2**

votes

**1**answer

3k views

### Is there an Excel formula that can conditionally sum rows based on column headers?

I need to be able to put a formula into the last cell of a row (shown by = in the image) that totals the values in that row that don't have a cell with the text 'Done' at the top of the relevant ...