Thread: Increasing a whole Spreadsheet by a percent
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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?

Reply With QuoteReply With Quote