How to lock a cell or selected cells in excel sheet
1. First select the entire sheet, in which you want to lock or unlock the cell.
2. Go to "Format -> Cells->Protection" in the menu bar.
3. In that you will find the Check Box "Locked" with Tick in it. Remove
the check first (by default all the cells will be in lock position).
4. Select the cells which you want to lock.
5. Repeat the steps 2 and put the Tick in the Check Box.
6. Go to "Tools->Protection->Protect Sheet" in the menu bar.
7. You have to give password for protection and save.
8. Now try to enter data in the locked cells, it will not allow you to
enter, whereas you can enter data in remaining cells.
No comments:
Post a Comment