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
|