Aaron

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

Gord Dibben Excel MVP

On Wed, 15 Dec 2004 12:31:04 -0800, "Aaron"
wrote:

Hello, and thank you.

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

Thank you,
Aaron

"Faulk" wrote:


Aaron wrote:
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.