Microsoft Office Tutorials and References
In Depth Information
Protect the Data in a Worksheet
Chapter 9: Protecting Excel Data
6 Click to select the check
box beside each action
that you want to allow
unauthorized users to
7 Click OK.
Excel asks you to confirm
8 Type the password.
9 Click OK.
Excel protects the
You can protect the worksheet at the same
time as you configure a range with a
password. In the “Protect a Range with a
Password” section, follow steps 1 to 9 to
create the password-protected range.
When you return to the Allow Users to Edit
Ranges dialog box, click Protect Sheet and
then follow steps 4 to 9 in this section.
If you no longer need to protect a
worksheet, you should turn off the sheet
protection to make the sheet data easier
to work with. Display the worksheet you
have protected, click the Review tab, and
then click Unprotect Sheet. In the
Unprotect Sheet dialog box, type the
unprotect password and then click OK.