Microsoft Office Tutorials and References
In Depth Information
7
Click Format in the
Cells group.
A menu appears.
7
8
Click Protect Sheet.
8
l The Protect Sheet dialog box appears.
9
Enter a password, if you wish to
passwordprotect your worksheet.
0
Click to select the options you want to allow
the users to perform (
changes to
).
!
Click OK.
l The Confirm Password dialog box appears.
@
Reenter your password.
9
@
0
#
Click OK.
Excel locks the cells in your worksheet and
hides the formulas in the selected cells.
l Users receive a message if they attempt to
change data.
#
!
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
181
 
Search JabSto ::




Custom Search