Microsoft Office Tutorials and References
In Depth Information
Keeping Workbooks Secure
Prevent Formula Changes
Unprotecting a Worksheet
A good reason to protect a worksheet is to
prevent accidental changes to formulas.
To unprotect the worksheet, choose
Review>Changes>Unprotect Sheet. Enter the
password if prompted.
2. Make sure the option Protect Worksheet and
Contents of Locked Cells is checked.
When users attempt to change a locked cell, they
see an error message such as the one shown in
3. Optionally, in the Password to Unprotect
Sheet text box, type a password. For privacy
reasons, only a series of dots appears.
Passwords are case-sensitive.
4. From the Allow All Users of the Worksheet To
box, select any options a user is allowed to
change without unprotecting the worksheet.
No access is allowed to locked cells in a
Selecting Locked Cells
You may have a worksheet in which you want only
yourself or others to enter data in specific cells and
to not have access to formulas or other definite
data. You can designate the cells you want editable
and leave the remainder of the worksheet protected.
Deselecting the Select Locked Cells option
doesn’t allow an unauthorized user to even
click a locked cell. All cells are considered
locked unless you unlock them, as you see in
the next section.
Select the cells you want users to be able to modify
and choose Home>Cells>Format>Lock Cell (see
Figure 12-5). Because, by default, Excel locks all
cells, choosing this option turns the Lock Cells
option off. Click the option again to relock the
cells again. Protect the worksheet to protect all but
the unprotected cells.
5. Click OK.
6. If you generated a password, a Confirm
Password dialog box appears. Retype the
password and then click OK again.