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?
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?
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
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.
