D david Jan 29, 2008 #1 how do i change prices, eg add 10% to all the prices on the page in microsoft excel ?.
R Ron Coderre Jan 29, 2008 #2 These steps will increase values by 10%: .. Enter 1.1 in a cell and select that cell (eg A1) .. From the Excel Main Menu: <edit><copy> .. Select the range of cells to be impacted (eg C1:C1000) .. <edit><paste special> .. Check: Multiply .. Click [OK] Press [ESC] to stop Copy Mode Does that help? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP)
These steps will increase values by 10%: .. Enter 1.1 in a cell and select that cell (eg A1) .. From the Excel Main Menu: <edit><copy> .. Select the range of cells to be impacted (eg C1:C1000) .. <edit><paste special> .. Check: Multiply .. Click [OK] Press [ESC] to stop Copy Mode Does that help? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP)
R Roger Govier Jan 29, 2008 #3 Hi David in a spare cell on the sheet enter 1.1 Copy that cell. Mark the range of cells whose values you want to increase by 10%>Paste Special>Multiply
Hi David in a spare cell on the sheet enter 1.1 Copy that cell. Mark the range of cells whose values you want to increase by 10%>Paste Special>Multiply
