field increase

J

Jeff

I am not good at excel. We have price list in excel
format and I would like to increase them all by the same
percentage. Is this possible?
Thanks in advance.
Jeff
 
B

Biff

Hi Jeff!

In an mt cell, enter the amount of the increase. For
example, the increase is 10%, in cell A1 enter 1.1.
Then select cell A1 and copy it. Now select the range of
prices that you want to increase. Now select Paste
Special>Multiply>Ok.

Biff
 
Top