Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help
how do i change prices, eg add 10% to all the prices on the page in microsoft
excel ?. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help
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) "david" wrote in message ... how do i change prices, eg add 10% to all the prices on the page in microsoft excel ?. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help
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 SpecialMultiply -- Regards Roger Govier "david" wrote in message ... how do i change prices, eg add 10% to all the prices on the page in microsoft excel ?. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|