Make column uneditable

B

bharath_pepala

Hi Friends,
Can any one help me how to make column uneditable in Excel ?

Thanks in Advacne

Thanks,
Bharath
 
B

Bernard Liengme

Use Format |Cells to format all cells other than Column X as Unlocked (so
user can edit them)
Tools|Protect -> protect sheet
Need more details?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"bharath_pepala"
 
A

Alan

Protect it! Tools > Protection > Protect Sheet > Add a password
Regards,
Alan.
"bharath_pepala"
 
Top