How to Update Prices in Excel by %

pgh - Dec 19, 2009 at 07:33 PM
 pgh - Dec 20, 2009 at 03:06 AM
I have a lengthy spreadsheet (Office 2007) with stocked items and their prices, the prices are simply entered in a cell when I created the spreadsheet, and now number well over 2000, so to save manually working out a price increase for each individual cell, how do I automatically increase all the prices by say 30%?

Thanks in advance for your kind assistance.

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Dec 19, 2009 at 09:20 PM
suppose your data (sample) is like this from A1 to A5

in B1(or any other empty cell in the same row) copy this formula
now copy B1 down

easy way of copying this is select B1 and take the cursor to bottom right of the cell where cursor turns into +
click this + then automatically B1 will be copied down provided there is no gap in the data.
Thanks, much appreciated. It is easy when you know how. :-)