security

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

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

Security

resolvedResolved · Low Priority · Version 2002/XP

Amie has attended:
Excel Intermediate course

Security

I'm confused about the order in which you protect a worksheet and activate the protection - I think there are two steps to the lockng process and I'm getting them mixed up. I just want to protect entire worksheet, apart from one column.

RE: Security

Hello Amie,

Hope you enjoyed your Microsoft Excel course with BEST Training.
Thank you for your question regarding locking worksheets

Yes, there are two steps.

1. CELLS
First step is to lock or unlock the cells you want to protect.
All cells are LOCKED by default.

To unlock a cell (or column in your case), simply select the cells you want to leave open for editing, and then RIGHT-CLICK > FORMAT CELLS. Then Select the last tab called PROTECTION.
Untick the box that says locked.

2. WORKSHEET
Once you have set the cells, you can then protect the worksheet.
Select TOOLS > PROTECTION > PROTECT WORKSHEET
Add a password, then OK.
This will switch the worksheet protection on.
Test your settings, by clicking on cells and try to edit them.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer


 

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function



View all Excel hints and tips


Server loaded in 0.09 secs.