By default, when you protect a worksheet, all the cells on the worksheet are locked, and users cannot make any changes to a locked cell.
Apr 27 2014 04:15 PM
To set a password to protect cells, follow the steps given below:
1) Go to REVIEW tab and click on "Protect Sheet" option.
2) Excel opens the Protect Sheet dialog box. By default, Excel selects the Protect Worksheet and Contents of Locked Cells check box.
3) Select any of the check boxes in the Allow All Users of This Worksheet To list box (such as Format Cells or Insert Columns) that you still want to be functional when the worksheet protection is operational.
The Select Locked Cells and Select Unlocked Cells check boxes are selected by default.
4) Type the password in the 'Password to unprotect Sheet' text box.
5) Click OK.
6) Excel opens the Confirm Password dialog box. Re-enter the password in the Reenter Password to Proceed text box and then click OK. Notice that if you try to edit a cell, Excel displays an error message.
-- To remove worksheet protection, click the Unprotect Sheet button in the Changes group on the Review tab. You’ll be prompted to type the password that you had set for protection.