# Questions tagged [microsoft-excel-2003]

The 2003 version of Microsoft's spreadsheet application.

275
questions

**102**

votes

**4**answers

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

**97**

votes

**7**answers

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

**33**

votes

**2**answers

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

**29**

votes

**1**answer

107k views

### Limit an Excel cell to one of two possible values

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?

**27**

votes

**1**answer

122k 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 appears ...

**24**

votes

**7**answers

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

**15**

votes

**6**answers

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

**12**

votes

**11**answers

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

**11**

votes

**10**answers

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

**11**

votes

**2**answers

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

**9**

votes

**6**answers

45k views

### Why is Excel removing 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 A2 attempts to display "01" as a number ...

**9**

votes

**2**answers

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

**9**

votes

**4**answers

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

**9**

votes

**4**answers

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

**8**

votes

**5**answers

118k 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). ...

**8**

votes

**1**answer

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

**7**

votes

**4**answers

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

**7**

votes

**4**answers

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

**7**

votes

**2**answers

118 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 2003)...

**5**

votes

**3**answers

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

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

**2**answers

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

**5**

votes

**2**answers

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

**5**

votes

**4**answers

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

**4**answers

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

**5**

votes

**3**answers

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

**2**answers

42k views

### Excel - Chart that sums the values in multiple rows for each series

Suppose I have a spread sheet that looks something like this...
Now, I'd like to create a column chart that has 3 series, one for each country. Then, I want series for each category, but I want to ...

**5**

votes

**3**answers

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

**5**

votes

**2**answers

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

**4**

votes

**2**answers

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

**4**

votes

**2**answers

13k views

### Changing line insert default formatting

When you insert a new row in a current spreadsheet, it automatically formats that row with the formatting from the line above. Is there a way of changing this so that it enters the formatting from the ...

**4**

votes

**1**answer

25k views

### Excel “This workbook contains links to other data sources”

I am getting this pop-up in Excel 2003, "This workbook contains links to other data sources", with the options to "Update" or "Don't Update". The workbook is using VLOOKUP to get information from ...

**4**

votes

**1**answer

4k views

### Zero values in Excel logarithmic chart: Can the warning be suppressed?

I'm plotting data in an Excel 2003 chart with a logarithmic scale on the Y axis. Some data points are occasionally missing, and this is represented by blank cells. The resulting graph looks like the ...

**4**

votes

**2**answers

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

**4**

votes

**4**answers

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

**2**answers

295 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

**3**

votes

**4**answers

56k 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 document?...

**3**

votes

**2**answers

506 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

**3**answers

5k views

### Lost VBA when downgrading from Excel 2013 to Excel 2010

I am on Windows 7. In the past I was using Excel 2003. I installed Office 2013 and found that my Office 2003 was intact and I could run both versions. I made updates to some worksheets using Excel ...

**3**

votes

**2**answers

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

23k views

### Can I use “Fill Down” to make a vertical series reference a horizontal series?

Say I have a data series going from A1 to E1. I would like to make a second copy of these cells going vertically, for instance from G1-G5. I can achieve what I want just by typing =A1 into G1, =B1 ...

**3**

votes

**3**answers

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

**3**answers

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

**3**

votes

**3**answers

13k views

### How to find the last value in a column in excel?

I am tracking rooms booked in a hotel on a daily basis in Excel. Every day I input the number of rooms booked in a column to show a trend of pick up over a period. I'd like to return the value of ...

**3**

votes

**5**answers

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

**3**

votes

**1**answer

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

**3**

votes

**2**answers

38k views

### How do I group rows in a spreadsheet and keep them together after sorting?

I have a spreadsheet with the information set up as such:
ORDER PLU/Recipe # Name/Desc Components
2 27905 CINNAMON CRUMB CAKE SQUARES
2.01 ...

**3**

votes

**1**answer

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

**1**answer

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

**3**answers

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