View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
James Silverton James Silverton is offline
external usenet poster
 
Posts: 182
Default How to increase the value of a whole column of cells by a percentage?

Hello, !
You wrote on 15 Oct 2006 13:43:40 -0700:

c How would I increase the values of a whole column of cells
c by a percentage?

c e.g. I want to change the values in cells A1 .. A200 by
c increasing them all by 20%?

Look into Paste Special to multiply by 1.2.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not