Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Password protection
Resolved · Low Priority · Version 2003
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.
|
|
Excel tip:Finding your worksheets quicklyThe arrows to the left of the worksheets are used to move between one sheet at a time or first / last worksheet, but if you right click on the arrow buttons it gives you all worksheets in your workbook. |
TrustScore
4.9
/ 5
2076 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.1 secs.
