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

learn more… | top users | synonyms

3
votes
1answer
302 views

Toggled Hyperlink with If:Then formula [duplicate]

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 ...
2
votes
1answer
840 views

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 ...
0
votes
1answer
23 views

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) . . ...
1
vote
1answer
315 views

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