Microsoft Office Tutorials and References
In Depth Information
Putting on the Protection
To return a workbook to fully automatic recalculation mode, click the
Automatic option on the Calculation Options button’s drop-down menu on the
Formulas tab (Alt+MXA).
Putting on the Protection
After you more or less finalize a worksheet by checking out its formulas and
proofing its text, you often want to guard against any unplanned changes by
protecting the document.
Each cell in the worksheet can be locked or unlocked. By default, Excel locks
all the cells in a worksheet so that, when you follow these steps, Excel locks
the whole thing up tighter than a drum:
1. Click the Protect Sheet command button in the Changes group on the
Review tab on Ribbon or press Alt+RPS.
Excel opens the Protect Sheet dialog box (see Figure 6-13) in which you
select the check box options you want to be available when the
protection is turned on in the worksheet. By default, Excel selects the Protect
Worksheet and Contents of Locked Cells check box at the top of the
Protect Sheet dialog box. Additionally, the program selects both the
Select Locked Cells and Select Unlocked Cells check boxes in the Allow
All Users of This Worksheet To list box below.
Figure 6-13:
Protection
options in
the Protect
Sheet dialog
box.
2. (Optional) Click any of the check box options 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.
3. If you want to assign a password that must be supplied before you can
remove the protection from the worksheet, type the password in the
Password to Unprotect Sheet text box.
Search JabSto ::




Custom Search