Make column uneditable

  • Thread starter Thread starter bharath_pepala
  • Start date Start date
B

bharath_pepala

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

Thanks in Advacne

Thanks,
Bharath
 
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"
 
Protect it! Tools > Protection > Protect Sheet > Add a password
Regards,
Alan.
"bharath_pepala"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top