Increasing a whole Spreadsheet by a percent

G

Guest

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

Gord Dibben

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
Weighted Average 1
Format Question 5
Help with a formula 2
How can I change all values in a spreadsheet by a certain percent 3
percentage 3
how to increase value in several cells by a percentage 4
increase an entire spreadsheet by a percentage 2

Top