Microsoft Office Tutorials and References
In Depth Information
Protect a Range with a Password
Chapter 9: Protecting Excel Data
The New Range dialog
5 Type a title for the range.
6 Use the Range Password
text box to type a
7 Click OK.
Excel prompts you to
reenter the password.
8 Type the password.
9 Click OK.
Excel adds the range to
the Allow Users to Edit
Ranges dialog box.
0 Click OK.
Note: Remember that the range
password does not go into effect
until you protect the worksheet; for
more information, see the section,
“Protect the Data in a Worksheet.”
If you want to change the range
password, the range title, or the
range coordinates, click the Review
tab and then click Allow Users to Edit
Ranges to open the Allow Users to
Edit Ranges dialog box. Click the
range, click the Modify button, and
then use the Modify Range dialog box
to make your changes.
To avoid having to enter the range password
yourself when the sheet is protected, you can
configure the range to allow your Windows
user account to edit the range. Click the
Review tab and then click Allow Users to Edit
Ranges to open the Allow Users to Edit
Ranges dialog box. Click the Permissions
button, click Add, type your username, click
OK, and then click OK again.