Excel

P

Printworks

I have a price list done in Excel and I want to increase all prices by 5
or10%. I know there's an easy way to do this but I can't remember how to do
it. Can someone please help.
 
F

FSt1

hi
in a cell off to the side, enter 1.1 for 10% increase or 1.05 for 5% increase.
copy the cell. high light your price list then paste special multipy.
done.

regards
FSt1
 
K

Kevryl

Here's one way:

Use the "Paste Special" option.
In Excel 2000, to increase a whole column by 10% I would...

1) Find a blank cell and type the value "1.1" (without quotes of course).
2) Copy it to the clipboard (Ctrl-C).
3) Select the entire column or range to be increased by 10%
4) Select Edit/Paste Special/Values/Multiply
5) Hit enter.

If the range to be changed hold formulae rather than finished values, "*1.1"
will be added to the formulae.

Cheers
 

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