View Single Post
  #2   Report Post  
Niek Otten
 
Posts: n/a
Default

In an empty cell, enter =1+YourPercentage, (like =1+4%)
EditCopy
Select your data
EditPaste Special, Check Multiply

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"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