View Single Post
  #5   Report Post  
Aaron
 
Posts: n/a
Default

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.