Excel
in [General]
|
From: Printworks on 10 Mar 2010 21:20 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.
From: FSt1 on 10 Mar 2010 22:46 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 "Printworks" wrote: > 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.
From: Kevryl on 10 Mar 2010 23:03 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 "Printworks" wrote: > 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.
|
Pages: 1 Prev: drops leading zeros on SAP download Next: Display fields side by side on the Pivottable |