Microsoft Office Tutorials and References
In Depth Information
Click Format in the
A menu appears.
Click Protect Sheet.
l The Protect Sheet dialog box appears.
Enter a password, if you wish to
passwordprotect your worksheet.
Click to select the options you want to allow
the users to perform (
l The Confirm Password dialog box appears.
Reenter your password.
Excel locks the cells in your worksheet and
hides the formulas in the selected cells.
l Users receive a message if they attempt to
Did You Know?
You can protect a workbook from unwanted changes.
Click the Review tab, click Protect Workbook in the
Changes group, and then click Protect Structure and
Windows. The Protect Structure and Windows dialog
box appears. Select Structure ( changes to ) to
protect your workbook from the moving, addition, and
deletion of worksheets. Select Windows ( changes
to ) to protect your workbook from changes in the
size and position of windows. Optionally, require a
password to remove these protections.
Did You Know?
If you click the Review tab and then click Allow Users
to Edit Ranges in the Changes group, the Allow
Users to Edit Ranges dialog box appears. Use this
dialog box to specify the ranges users can modify.
Click the New button and complete the fields in the
New Range dialog box. You can password-protect
each range you allow.
Chapter 8: Protect, Save, and Print