Excel

[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.

 

[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

 

[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