About Locking and protection of Cells in Excel

[chaithra]

Hi All,

If you want to lock particular cell and unlock some other cells in an
excel sheet.Just click on the cell,right click on it,click on format
cell than click on protection on that enable locked option if you
want particular cell to be locked and if you need some other cells in
same sheet to be unlocked right click on those cells,go for format
cells,in that click on protection and disable locked option .Than on
excel worksheet go for review in that click on protect sheet,you will
get a list of options in that click on to select only unlocked cells
and give password for it.With this the others can edit the cells
which are unlocked other data which are protected cannot be edited by
others.