Super User
Super User

Questions tagged [microsoft-excel-2000]

The 2000 (9.0) version of Microsoft's spreadsheet application, included in Office 2000.

6 questions
3
votes
1 answer

Toggled Hyperlink with If:Then formula

I'm attempting to make a formula that will toggle a hyperlink on or off depending on the argument. Basically, I want to make it argue the following: If there is text in (Tab A, Cell A), then create a hyperlink with the title (Text of Tab A, Cell A)…
Lochlainn
  • 31
2
votes
2 answers

Selecting cells shows count, not sum

I have a PC with Excel 2000 and when I select the numbers from some cells, it shows in the status bar the Count of the cells. I need to make it to show the Sum of that cells. Does anyone have any idea how to fix this?
Remus Rigo
  • 3,038
1
vote
0 answers

Remove Rows Not Part of Filter

I am filtering a large Excel spreadsheet. I want to remove all rows on the sheet that are not a part of the filter. I know I can copy the rows and paste them into another spreadsheet. But I would rather apply the change directly to the same…
Linger
  • 3,332
  • 10
  • 38
  • 47
1
vote
1 answer

How can I add an image in the page header when printing Excel 2000 spreadsheets?

I'm using Excel 2000. I have a spreadsheet document that covers several pages when printed. I am able to add page numbers and basic text to the header (and footer) of the printed sheets, but I would really like to add an image to the header in…
James Eichele
  • 848
1
vote
0 answers

Excel Viewer limits cells to 255 characters when copying

I am running MS Office 2000. I needed to open and work with a xlsx file. I tried to install the Microsoft Office Compatibility Pack and it didn't work. So I installed the newest Excel viewer. The viewer opens the file correctly and I can only view…
Linger
  • 3,332
  • 10
  • 38
  • 47
0
votes
1 answer

How to make a sheet-wise replacement of cell contents depending on the cell to the left?

I have a sheet with a table, with two columns. In the first column is a number of the compartment, and in the second the name of the compartment. ID NAME 121 Fore peak 224 Enterance (s) . . etc. Since those tables were composed in short time…
Rook
  • 24,289