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

Adding 1
Increasing all values in spreadsheet by same percentage. 1
how to increase a group of cells by the same percentage at once 1
how do i increase the value of numbers in a column by a percentage 5
Increase by percentages 6
Wanting to Create QueryUpadate 0
Wanting to Create QueryUpadate 0
Percentage Increase 13

Top