changing the value of each cell in a range by a certain percentage

[Guest]

Hello,

Is there an easy way to select a range of cells and change the value of each
cell by the same percentage without adding formula columns?

Thank you,
Aaron

 

[Frank Kabel]

Hi
try:
- put 1.05 in an empty cell (for a 5% increase) and copy this cell
- select your values
- goto 'Edit - Paste Special' and choose 'Multiply'

 

[Faulk]

Hello,

Is there an easy way to select a range of cells and change the value of each
cell by the same percentage without adding formula columns?

Thank you,
Aaron

Yes, in a seperate cell, enter 1 plus the percentage change you wish to
add. for example, if you want to increase your range by 10%, enter 1.1
in a cell, copy it, then select your entire range, Edit, Paste Special,
under Operation, select Multiply, then OK. Your range will be
incremented by the percentage you indicated.

 

[Bernard Liengme]

Let's say you want to increase the vales in A1:A10 by 15%
In empty cell (we'll call it Z1) type 1.15
Copy Z1; select A1:A10 and use Edit | Paste Special specifying Multiply in
the popup dialog box.
Your numbers have been increased.
All that remains is housekeeping - delete Z1

best wishes

 

[Guest]

Hello, and thank you.

Is there a way for it to not overwrite the existing formats in the selected
range?

Thank you,
Aaron

 

[Gord Dibben]

Aaron

When doing the Paste Special check "Formulas"(under Paste) as well as
"Multiply"

Gord Dibben Excel MVP