incrementing cost in excel???

C

cerebro

Hi, I have a list of wholesale prices for a range of products and I want
to change the price to retail to sell through an ebusiness and was
wondering if I could use excel to increment all the wholesale costs by
say 20 without having to do each by hand. Is it possible to update all
the prices with a few commands or am i going to have to change all 1000
of them by hand. thanks for any help.
 
J

JE McGimpsey

Enter 20 in a blank cell. Copy the cell. Select your prices. Choose
Edit/Paste Special, selecting the Values and Add radio buttons. Click OK.
 

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