Increasing a whole Spreadsheet by a percent

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Enter 1.1 in an empty cell.

Copy that cell and select all the other cells.

Edit>Paste Special>Multiply>OK>Esc

All cells will be increased by 10%

Clear the cell with the 1.1

Adjust the number to suit.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Increasing by a percent 1
How can I change all values in a spreadsheet by a certain percent 3
Monthly Percent Increase 1
column to show certain percent positive AND negative 3
increase an entire spreadsheet by a percentage 2
Help with a range formula 4
how to increase value in several cells by a percentage 4
Formula for subtracting percentages?? 1

Back
Top