microsoft excel courses tate - password protection
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses tate - Password Protection

microsoft excel courses tate - Password Protection

resolvedResolved · Low Priority · Version Standard

replyReply Wed 17 Oct 2007, 10:52Delegate Rebecca said...

Rebecca has attended:
Excel Advanced course

Password Protection

I have added a password protection to my document, however the user can still delete the contents. What can i do to resolve this?

For upcoming training course dates see: Pricing & availability

replyReply Wed 17 Oct 2007, 11:33Trainer Richard said...

RE: Password Protection

When you added password protection, did you lock the worksheet or the workbook?

You must protect the workbook to lock the contents.

Let me know

Richard

replyReply Wed 17 Oct 2007, 11:34Delegate Rebecca said...

RE: Password Protection

No I didn't lock the worksheet, how do I do this?

replyReply Wed 17 Oct 2007, 11:53Trainer Richard said...

RE: Password Protection

TOOLS > PROTECTION > PROTECT SHEET

Enter a password
Confirm Password

Done.

 

Excel tip:

Deleting a range of cells using the autofill handle

Firstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard