We're Talking Basic (I think)

  • Thread starter Thread starter gwhayduke
  • Start date Start date
G

gwhayduke

I am creating a price list. BIG. I want to be able to go into
the price list and apply a percentage increase throughout every
cell that has a dollar value. :rolleyes: Change the prices by th
percent desired, drag and drop into a layout, print and send t
customers.:confused:

I have no Excel experience to speak of and no "User handbook"). :eek:

What say? Anyone who can help? :confused:

Thank you.

G
 
I am just searching through posts and there are alot of people in m
shoes. Hopefully I can get what I need from previous posts
 
Assuming you want all prices raised by 10%

Enter 1.1 in an unused cell.

Copy that cell. Select all the other cells with prices.

Edit>Paste Special>Multiply>OK>Esc.

Delete cell with the 1.1


Gord Dibben MS Excel MVP
 

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