Microsoft Office Tutorials and References
In Depth Information
Protect a Worksheet’s Data
13
chapter
Collaborating with Others
6 Click the check box beside
each action that you want to
allow unauthorized users to
perform (
changes to
).
7 Click OK.
Excel asks you to confirm the
password.
8 Type the password.
9 Click OK.
If you want to make changes
to a worksheet, click the
Review tab, click Unprotect
Sheet ( ), type the unprotect
password, and then click OK.
When I protect a worksheet, no
one can edit any of the cells. Is
there a way to allow users to edit
some of the cells?
Yes. First, unprotect the sheet if it
is currently protected. Select the
range you want to unlock, click
Home , click Format , and then
click Lock Cell to turn off that
option for the selected range.
When I protect a worksheet, can I configure a range
to require a password before a user can edit the
range?
Yes. First, unprotect the sheet if it is currently
protected. Select the range you want to protect, click
the Review tab, and then click Allow Users to Edit
Ranges . In the Allow Users to Edit Ranges dialog box,
click New to open the New Range dialog box. Type a
title for the range, use the Range text box to type a
password, and then click OK.
Search JabSto ::




Custom Search