Protection of cell in excel

  • Thread starter Thread starter Sanjay Sharma
  • Start date Start date
S

Sanjay Sharma

Hi,

I would like to protect some particular coloum, I was using formate
cell->protection->Lock, but it was not working, Kindly let me know how do I
do it?
 
All cells are locked by default, but locking does not mean anything until
you protect the worksheet from Tools>Protection menu.

--First select any cells that a user is allowed to change
--Hit Ctrl+1 and go to the 'Security' tab to unlock these cells.
--Go to Tools->Protection->Protect Sheet, and you can assign a password
(optional)

If this post helps click Yes
 
Back
Top