View Single Post
  #4   Report Post  
Bernard Liengme
 
Posts: n/a
Default

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
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Aaron" wrote in message
...
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