Back in the DOS days, I used a program called Enable. It was the DOS equivalent of MS Office, in that it had all the modules (spreadsheet, database, word processing, etc.) and you could have multiple modules open in multiple windows.
One wonderful feature of the spreadsheet was that you could highlight a range of cells, and apply a factor to all the values in the range. E.g., if I wanted to change hourly rates in a range of cells to annual salaries, I could highlight the range, enter the factor "*2080", and all the values in that range were instantly multiplied by 2080.
I can find no way to do that in Excel 2000. Is there?
One wonderful feature of the spreadsheet was that you could highlight a range of cells, and apply a factor to all the values in the range. E.g., if I wanted to change hourly rates in a range of cells to annual salaries, I could highlight the range, enter the factor "*2080", and all the values in that range were instantly multiplied by 2080.
I can find no way to do that in Excel 2000. Is there?