Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Sharing Your Work with the Outside World
1. Select the cells you need to unlock.
2. Right-click and select Format Cells.
3. On the Protection tab, as shown in Figure 19-6, deselect the Locked check box.
4. Click OK to apply the change.
Figure 19-6: To ensure that a cell remains unlocked when the worksheet is protected, deselect the Locked
Applying worksheet protection
After you’ve selectively unlocked the necessary cells, you can begin to apply worksheet protection.
Just follow these steps:
1. To open the Protect Sheet dialog box, click the Protect Sheet icon on the Review tab of the
Ribbon (see Figure 19-7).
2. Type a password in the text box (see Figure 19-8) and then click OK.
This is the password that removes worksheet protection. Note that because you can apply
and remove worksheet protection without a password, specifying one is optional.
3. In the list box (see Figure 19-8), select which elements users can change after you protect the
When a check box is cleared for a particular action, Excel prevents users from taking that
4. If you provided a password, reenter the password.
5. Click OK to apply the worksheet protection.
Figure 19-7: Select Protect Sheet in the Review tab.