Add percent to group of numbers

[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

 

[Bernard Rey]

(e-mail address removed):

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?

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.

 

[jwswaco]

Thank you so much for your assistance!
James