T
Tammy Dean
How do you raise multiple cells containing numbers at one time by a percentage.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard Liengme
Let's say you want 7%
In some empty cell (say Z1) type 1.07 and copy this value
Select the range the be changed and use Edit | Paste Special with Multiply
checked off in the dialog; click OK
Now you can delete Z1
Back up you file before you start this in case you err.
best wishes
In some empty cell (say Z1) type 1.07 and copy this value
Select the range the be changed and use Edit | Paste Special with Multiply
checked off in the dialog; click OK
Now you can delete Z1
Back up you file before you start this in case you err.
best wishes
T
Tammy Dean
Thank you so much.
Bernard Liengme said:Let's say you want 7%
In some empty cell (say Z1) type 1.07 and copy this value
Select the range the be changed and use Edit | Paste Special with Multiply
checked off in the dialog; click OK
Now you can delete Z1
Back up you file before you start this in case you err.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
D
Dennis
Enter your number in a blank cell e.g. for 50% enter 1.5 as the multiplying
factor
With this cell highlighted click Copy
Highlight all the cells you wish to raise by this percentage.
Select Edit - Paste Special - Radio button Multiply - Click OK
All the cells highlighted will be multiplied by 1.5 i.e. raised by 50%
factor
With this cell highlighted click Copy
Highlight all the cells you wish to raise by this percentage.
Select Edit - Paste Special - Radio button Multiply - Click OK
All the cells highlighted will be multiplied by 1.5 i.e. raised by 50%