Can I globally add to a worksheet?

O

oldsquid

I have a work sheet 10 columns wide and 150 rows. I need to increase each value 1.25%, but do not want to do this manually cell by cell, is this possible?
 
C

Chip Pearson

Enter 1.0125 in some unused empty cell and copy that cell. Then select all
the cells whose value you want to increase. Then go to the Edit menu, choose
Paste Special, and select the Multiplication operation. Click OK.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

I have a work sheet 10 columns wide and 150 rows. I need to increase each
value 1.25%, but do not want to do this manually cell by cell, is this
possible?
 
E

Elkar

In any blank cell, enter the value 1.0125
Copy that cell
Select your range of cell to increase
From the Edit Menu, select "Paste Special..."
Check the "Multiply" option
Click OK
Delete the 1.0125 you entered originally

HTH,
Elkar
 
Top