The 2003 version of Microsoft's spreadsheet application.

**27**

votes

**2**answers

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

**12**

votes

**5**answers

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

**11**

votes

**1**answer

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

**8**

votes

**1**answer

9k views

### allow two possible values in a 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?

**8**

votes

**1**answer

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

**7**

votes

**5**answers

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

**2**answers

93 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

**5**answers

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

**6**

votes

**4**answers

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

**6**

votes

**1**answer

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

**6**

votes

**2**answers

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

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

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

**4**answers

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

**5**

votes

**3**answers

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

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

**3**answers

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

**4**

votes

**1**answer

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

**1**answer

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

**4**

votes

**2**answers

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

245 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

**2**answers

562 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

**2**answers

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

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

**3**answers

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

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

**1**answer

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

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

**4**answers

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

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

**1**answer

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

**2**

votes

**6**answers

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

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

93 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

**4**answers

9k 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 in Unicode format, the text which contains the double ...

**2**

votes

**5**answers

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

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

530 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

513 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

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

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

319 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

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

**2**

votes

**5**answers

5k views

### How to make multiple Excel files open in ONE window/instance of Excel 2003 in Win 7

I'm running Excel 2003 on my new Windows 7 machine. (There is also a Excel 2010 starter pre installed that I do not use).
I'm a heavy user of Excel. I use it all day every day. I often have 10 or ...

**2**

votes

**4**answers

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

**3**answers

147 views

### Convert Excel data

I've made a survey in Sharepoint and want to convert the results into something useful in Excel 2003. My problem is the format the responses are in for some questions.
An example of two responses ...

**2**

votes

**5**answers

306 views

### Converting date format in formulas in Excel

what is the formula which would enable me to calculate the difference between 2 dates and 2 times? Example: In the same cell, I have 01 January 2005 07:30 and in a second cell i would have 06 January ...

**2**

votes

**2**answers

2k views

### Refresh values in Excel 2003

I have an excel file with three worksheets(ws), the first two have raw data and the third one contains formula to compare the data in other two ws. For example, here is an example of my comparison ...

**2**

votes

**2**answers

478 views

### Using excel sheet as a function

I wonder how I can use an excel sheet as a function.
Let's say I have a complex calculation in Sheet1 with one parameter I would like to iterate over a range like [1 to 400] in a second sheet to ...