Thread: help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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 ?.