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
 

Ask a Question

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.

Ask a Question

Top