ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - help (https://www.excelbanter.com/excel-worksheet-functions/174851-help.html)

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

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 ?.

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 ?.