Updating price sheets

  • Thread starter Thread starter -Lawless
  • Start date Start date
L

-Lawless

Well as the topic implies, I'm trying to update some price sheets
created in Excel.

I have several cells with prices in them and I'm trying to increase all
of the cells by 5%.

Can someone tell me the easiest way to do this?

I'm sure I've done this before but I'm at a loss.

Thanks!
 
Format an empty cell as Number. Enter the number 1.05. Edit>Copy. Select
your prices. Edit>Paste special, check Multiply.
 

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

Back
Top