Super User
Super User

Questions tagged [microsoft-excel-2003]

The 2003 version of Microsoft's spreadsheet application.

Microsoft's lifecycle support has ended for excel 2003 source.

Support ended in 2014. If you're having issues with excel 2003, please keep in mind that this version has many limitations compared to later versions and there may not be a workable solution.

278 questions
159
votes
6 answers

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 something you didn't want to undo. And if an edit…
Hugh Allen
  • 10,120
104
votes
8 answers

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 the cells are clicked out of. However, for some…
oshirowanen
  • 1,776
43
votes
2 answers

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 tes3 3 t 4 tes4 4 g Notice that…
Indy
  • 533
43
votes
1 answer

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?
Josemalive
27
votes
1 answer

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 to work exactly wrongly, displaying OK when myval is out of…
Brian Hooper
  • 1,987
27
votes
8 answers

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 functionality where, given an existing spreadsheet,…
RationalGeek
  • 609
18
votes
7 answers

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 worksheet.) What's the easiest way to do that in Excel…
Patrick McElhaney
  • 943
14
votes
11 answers

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 enter more than 15 digits it gets converted to…
user111921
  • 151
13
votes
7 answers

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 without a leading "0". When I format rows 2…
Ivan
  • 2,364
12
votes
10 answers

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 was able to format the cells to just show month…
Brendan
  • 301
11
votes
5 answers

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). In the attached screenshot socks is row one but…
Gullu
  • 868
  • 1
  • 8
  • 10
11
votes
4 answers

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 contains the double quote is saved as three double…
karthik
  • 111
  • 1
  • 1
  • 3
11
votes
2 answers

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 font face/size as you selected for the entire…
Nicu Zecheru
  • 5,572
9
votes
5 answers

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 data that was just pasted in order to mark/highlight…
Gaffi
  • 438
9
votes
4 answers

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.
Olav
  • 694
  • 3
  • 10
  • 31
1
2 3
…
18 19