ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to increase a group of cells by the same percentage at once (https://www.excelbanter.com/excel-discussion-misc-queries/183696-how-increase-group-cells-same-percentage-once.html)

Tammy Dean

how to increase a group of cells by the same percentage at once
 
How do I increase a group of cells containing numbers by the same percentage
at one time.

T. Valko

how to increase a group of cells by the same percentage at once
 
Try this...

Say you want to increase the numbers by 5%.

Enter 1.05 in an empty cell.
Copy that cell: EditCopy
Select the numbers you want to increase.
Then, EditPaste SpecialMultiplyOK
Delete the 1.05

--
Biff
Microsoft Excel MVP


"Tammy Dean" <Tammy wrote in message
...
How do I increase a group of cells containing numbers by the same
percentage
at one time.





All times are GMT +1. The time now is 08:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com