increase an entire spreadsheet by a percentage

T

tb

I would like to increase an entire spreadsheet of numbers by a percentage
without changing each cell.
 
N

Niek Otten

Make a copy of your workbook before trying this

If you want to increase all numbers by 5%:
In an empty cell, enter the number 1.05
Edit>Copy
Select all your numbers
Edit>Paste special, check Multiply
 
J

Jacob Skaria

--For example if you need to increase 10% enter 1.1 in a cell. Copy the cell
--Keeping the copy select the range of cells
--Right click>PasteSpecial>
--Select 'Multiply' and click OK.

If this post helps click Yes
 

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

Resource name inside resource sheet: per person, work per hours per week 0
Excel does not accept text format! 0
Clicking link tasks again increases duration 0
MS Project. Real progress of the project, % complete 1
Percentage Increase 11
Found few bugs in my daily routine of work in excel for MAC 0
Adding 1
complicated excel formula may need an algebra wiz 1

Top