View Single Post
  #3   Report Post  
Fredrik Wahlgren
 
Posts: n/a
Default


"BayComp" wrote in message
...
How di i change the value of all data in a column by a given percentage?

e.g
i want to increase an entire columns entered values by a percentage i

choose.


TIA


Snipped from http://www.j-walk.com/ss/excel/usertips/tip059.htm


1.. Enter 1.05 (percentage) into any blank cell.
2.. Select the cell and choose Edit, Copy.
3.. Select the range of values and choose Edit, Paste Special.
4.. Choose the Multiply option and click OK.
5.. Delete the cell that contains the 1.05.
/Fredrik