Microsoft Office Tutorials and References
In Depth Information
Protecting the Worksheet
2
Click Format Cells on the
shortcut menu.
check mark
removed
from Locked
check box
Custom Lists
dialog box
When Excel displays the Custom
Lists dialog box, click the
Protection tab, and then click
Locked to remove the check mark
(Figure 4–56).
What is the meaning of the
Locked check box ?
Excel displays the Protection
sheet in the Custom Lists dialog
box with the check mark removed
from the Locked check box
(Figure 4–56). This means the
selected cells (C3:C5 and E2:E3)
will not be protected when the
Protect command is invoked later.
Protection tab
OK button
Figure 4–56
3
Click the OK button and then
select cell H22 to deselect the
ranges C3:C5 and E2:E3.
Review tab
Protect
Sheet
button
Click the Review tab on the
Ribbon (Figure 4–57).
Protect
Workbook
button
Figure 4–57
 
 
Search JabSto ::




Custom Search