Protection

Resolved · Low Priority · Version 2003

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

Karen has attended:
Excel Intermediate course
Excel Advanced course

Protection

How do you password protect a document?

Thu 23 Oct 2008, 18:00 Trainer 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

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips