98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses - Locking a column
microsoft excel courses - Locking a column
Resolved · Low Priority · Version Standard
Thu 6 Sep 2007, 10:19Delegate Laura said...
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?
Fri 14 Sep 2007, 10:02Trainer Richard said...
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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Line breaks in a cellYou 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. |
