Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
password protection

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Password protection

Password protection

ResolvedVersion 2003

William has attended:
Excel Intermediate course

Password protection

How do you protect a worksheet

RE: Password protection

Hi William

To protect the contents of an Excel worksheet you do the following:

1. In the Tools menu, Select Protect
2. Click Protect Sheet

A dialog box appears allowing you to enter a password (although this is optional)

3. Enter the password and click OK

4. A new dialog box will ask you to Confirm the password.
5. Re-enter the password and clickOK.

NB. This will protect the contents of that entire worksheet. This is because Excel protects worksheet cells that are "Locked"- and all Excel worksheet cells come locked as a default.

Hope this helps

Carlos

Wed 3 Jun 2009: Automatically marked as resolved.

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.14 secs.