help

[david]

how do i change prices, eg add 10% to all the prices on the page in microsoft
excel ?.

 

[Ron Coderre]

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)

 

[Roger Govier]

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