Increasing a whole Spreadsheet by a percent
 

How do you increase every number in a spreadsheet by a certain percent with
out changing each one individually?

Increasing a whole Spreadsheet by a percent
 

Nicole

Enter 1.1 in an empty cell.

Copy that cell and select all the other cells.

EditPaste SpecialMultiplyOKEsc

All cells will be increased by 10%

Clear the cell with the 1.1

Adjust the number to suit.


Gord Dibben MS Excel MVP

On Tue, 10 Oct 2006 12:41:02 -0700, Nicole
wrote:

How do you increase every number in a spreadsheet by a certain percent with
out changing each one individually?