Protecting Cells
It allows us to set Protection options to prevent editing (or even viewing) of all or parts of a workbook. This can be very useful while sharing a spreadsheet with others or even to prevent accidental altering of labels and formulas once they are all completed.
It is necessary to set an option to unlock cells that may still require change after a worksheet is protected. By default every cell has its Locked property set to true. For unlocking cells:
1. Select the block of cells to be unlocked.
2. Choose the Cells option from the Format menu. The Format Cells window appears as shown in figure.
3. Click on the Protection tab.
4. Click in the box next to Locked to remove the check mark.
5. Click OK. The Locked property for these cells is now disabled.
