protection
The UK's Number 1 for Microsoft Office Training
Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Recommend training98.1 %
recommend us
More live stats...

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

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

See also:
Hints and tips
Forum topics

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.

Protection

resolvedResolved · Low Priority · Version 2007

replyReply Thu 5 Nov 2009, 16:34Delegate Efua said...

Efua has attended:
Excel Intermediate course

Protection

How do I protect a worksheet

For upcoming training course dates see: Pricing & availability

replyReply Fri 6 Nov 2009, 09:50Trainer Amanda said...

RE: Protection

Hello Efua

Thank you for your question and welcome to the forum.

To apply protection to a worksheet, go to the Review tab, and click the Protect Sheet button.

Create a password (if you wish), and tick any actions that you want people to be able to perform even when protection is applied.

If you have entered a password, you will be prompted to enter it again.

Click OK to apply protection.

Kind regards
Amanda

 

Excel articles

· Going Against The Grain With Multiple Radio Buttons In Excel
· How To Create An Excel 2010 Chart To Show Both A Number And A Percent Data Series
· Where Is Your Business Heading? Let Excel Help You To Understand!
· Create Contrasting Coloured Rows In Excel
· How to Create Better Excel Spreadsheets: Part One

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

Excel tip:

Finding cells that have data restrictions

Click anywhere on the worksheet.
On the Edit menu, click Go To.
Click Special.
Click Data validation.
Click All.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. infomst
All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy