microsoft excel courses - locking column

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses - Locking a column

microsoft excel courses - Locking a column

resolvedResolved · Low Priority · Version Standard

Laura has attended:
Access Introduction course
Excel Intermediate course

Locking a column

How do I hide and lock one or more columns without locking the whole sheet. I know with hide that the person can then simply unhide so I need a way to lock the columns and make them untouchable?

RE: Locking a column

Hi Laura

Once you have hidden the column, simpy put a password on the sheet

TOOLS > PROTECTION > PROTECT SHEET
add a password
verify password

When you do this, the other user will not be able to make a modification to the sheet, unless they have your password.

Regards

Richard

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Line breaks in a cell

You can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it.

Click the cell where you want the label or heading to appear.
Type the first line of information.
Press ALT+ENTER.

View all Excel hints and tips


Server loaded in 0.11 secs.