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