Microsoft Office Tutorials and References
In Depth Information
More About Worksheet Protection
• Click the Protect Sheet button on
the Ribbon to display the Protect
Sheet dialog box.
• When Excel displays the Protect
Sheet dialog box, make sure the
Protect worksheet and contents
of locked cells check box at the
top of the dialog box and the ﬁ rst
two check boxes in the list contain
check marks (Figure 4–58).
What do the three checked check
With all three check boxes selected,
the worksheet is protected from
changes to contents (except the
cells left unlocked). The two check
boxes in the list allow the user to
select any cell on the worksheet,
but the user can change only
sheet text box
users can do
• Click the OK button in the Protect
Sheet dialog box.
• Click the Save button on the Quick Access Toolbar.
1. Click Format Cells
Dialog Box Launcher,
click Protection tab,
remove check mark
from Locked check box,
click OK button
All the cells in the worksheet are protected, except for the ranges C3:C5 and E2:E3.
The Protect Sheet dialog box in Figure 4–58 lets you enter a password that can be used
to unprotect the sheet. You should create a password when you want to keep others from
changing the worksheet from protected to unprotected. The check boxes in the list in the
Protect Sheet dialog box also give you the option to modify the protection so that the user
can make certain changes, such as formatting cells or inserting hyperlinks.
If you want to protect more than one sheet in a workbook, select each sheet before
you begin the protection process or click the Protect Workbook button on the Review tab
on the Ribbon, instead of clicking the Protect Sheet button (Figure 4–57). If you want to
unlock cells for speciﬁ c users, you can use the Allow Users to Edit Ranges button on the
Review tab on the Ribbon.
When this workbook is put into production, users will be able to enter data in only
the unprotected cells. If they try to change any protected cell, such as the monthly payment
in cell E4, Excel displays a dialog box with an error message as shown in Figure 4–59 on
the next page. An alternative to displaying this dialog box is to remove the check mark
from the ‘Select unlocked cells’ check box in the Protect Sheet dialog box (Figure 4–58).
With the check mark removed, the user cannot select a locked cell.
To unprotect the worksheet so that you can change all cells in the worksheet, unprotect
the document by clicking the Unprotect Sheet button on the Review tab on the Ribbon.
You can move from
one unprotected cell to
another unprotected cell
in a worksheet by using
the tab and SHIFT + TAB
keys. This is especially
useful when the cells
are not adjacent to one