incrementing cost in excel???

  • Thread starter Thread starter cerebro
  • Start date Start date
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.
 
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.
 
Back
Top