Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Protection

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Protection

Resolved · Low Priority · Version 2003

Reply Thu 23 Oct 2008, 15:40Delegate Karen said...

Karen has attended:
Excel Intermediate course
Excel Advanced course

Protection

How do you password protect a document?

For upcoming training course dates see: Pricing & availability

Reply Thu 23 Oct 2008, 18:00Trainer Katie said...

RE: Protection

Hi Karen,

Thank you for your question.

Protecting a worksheet with password is only useful if you have locked a group of cells (usually the ones with formulae).

This is how you use it:
1) Since Excel by default locks all cells, you should select all the non-formulae cells > Format menu > Cells > Protection tab > clear checkbox "Lock" > OK

2) Select Tools menu > Protection > Protect Sheet > set a password > click OK

It is better if you test on a sample file first before you set it on your working file.

kind regards,

Katie Woo
Microsoft Certified Trainer

Excel articles

· Create An Improvised Bar Chart In Excel
· How To Create A Macro In Excel 2010
· Tell AutoFill What To Do And It Will Oblige
· Chart Creation Simplified - in 4 Simple Steps
· Excel and Inventory Management

Please browse our web site to find out more about
excel/courses/london and other Microsoft training courses.

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips