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

A

Aaron

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
 
F

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'
 
F

Faulk

Aaron said:
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
Click to expand...

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

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
 
A

Aaron

Hello, and thank you.

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

Thank you,
Aaron
 
G

Gord Dibben

Aaron

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

Gord Dibben Excel MVP
 
Top