Thanks for this step by step. Now with my manual, as an extra guide I think I
can do it!

Happylady

"muddan madhu" wrote:

Col A - Price list of products

if u want to replace in old price then
in Cell C1 type 1.05
then copy it
Select the range that you want to replace
now go edit | pastespecial | paste : all | operation : multiply | ok

Or

It you want the increased value in separate column then,

Cell B1 put this formula and drag it down =A1+A1*5%




On Jan 31, 12:07 pm, happylady
wrote:
I have received an across the board price increase for all the products in
the line I distribute. I want to put my product price list in Excel and be
able to increase all the products prices by 5%. Otherwise I have to type in
the price change on each individual product. Can I do this in Excel and how?

happylady