Super User Stack Exchange
Super User Stack Exchange

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.

276 questions
152
votes
5 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
  • 9,820
  • 6
  • 34
  • 42
102
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,690
  • 14
  • 62
  • 79
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
  • 1
  • 4
  • 4
38
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,925
  • 5
  • 24
  • 33
26
votes
7 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
  • 599
  • 3
  • 6
  • 13
17
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
  • 923
  • 4
  • 13
  • 25
13
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
  • 141
  • 1
  • 2
  • 4
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
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
  • 291
  • 2
  • 4
  • 13
11
votes
6 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,094
  • 9
  • 29
  • 41
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,492
  • 7
  • 33
  • 46
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
  • 664
  • 3
  • 10
  • 29
9
votes
4 answers

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 want to open shouldn't contain anything fancy, so I…
svick
  • 927
  • 1
  • 8
  • 26
1
2 3
…
18 19