Microsoft Office Tutorials and References
In Depth Information
Protecting the Worksheet
When building a worksheet for novice users, you should protect the cells in the worksheet
that you do not want changed, such as cells that contain text or formulas.
When you create a new worksheet, all the cells are assigned a locked status, but the
lock is not engaged, which leaves cells unprotected. Unprotected cells are cells whose
values you can change at any time. Protected cells are cells that you cannot change.
You should protect cells only after the worksheet has been tested fully and the correct
results appear. Protecting a worksheet is a two–step process:
1. Select the cells you want to leave unprotected and then change their cell protection
settings to an unlocked status.
2. Protect the entire worksheet.
At ﬁ rst glance, these steps may appear to be backwards. Once you protect the
entire worksheet, however, you cannot change anything, including the locked status of
A name can be assigned
to two or more
After selecting the ﬁ rst
range, hold down the CTRL
key and drag through the
additional ranges of cells
to select them before
entering the name in the
In the Loan Payment Calculator worksheet (Figure 4–55), the user should be able to make changes to only
ﬁ ve cells: the item in cell C3; the price in cell C4; the down payment in cell C5; the interest rate in cell E2; and the
years in cell E3. These cells must remain unprotected so that users can enter the correct data. The remaining cells in
the worksheet should be protected so that the user cannot change them.
The following steps show how to protect the Loan Payment Calculator worksheet.
• Select the range C3:C5.
• Hold down the CTRL key and
then select the nonadjacent
ranges C3:C5 and
• Right–click one of the selected
ranges to display the shortcut
menu (Figure 4–55).