Add percent to group of numbers

J

jwswaco

I have pricing sheets that have been created in Excel. We are
increasing our pricing and I need to increase all the prices in the
worksheet by 7 percent. Does anyone have a suggestion as to how to do
this to the entire sheet at once instead of individually? Thanks in
advance -James
 
B

Bernard Rey

[email protected]:
I have pricing sheets that have been created in Excel. We are
increasing our pricing and I need to increase all the prices in the
worksheet by 7 percent. Does anyone have a suggestion as to how to do
this to the entire sheet at once instead of individually?
Click to expand...

In a free unused cell, type the value "1.07" (without the quotes). Copy the
cell. Then select the cells you want to modify, in the "Edit" menu "Paste
special" item check the "Multiply" button, click the "OK" button and you
should be through.
 
Top