excel document protection

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel document protection

Excel document protection

resolvedResolved · Low Priority · Version 365

Jacqueline has attended:
Excel Intermediate course

Excel document protection

I created an excel document with three different sheets. Is there any way of protecting access to just one of the sheets?

RE: Excel document protection

Hi Jacqueline,

Thank you for the forum question.

If you right click on the sheet tab and click Hide sheet. Then you can protect the sheet to be unhidden by go to the Review tab on the ribbon and click Protect Workbook in the Protect group.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Excel document protection

Thanks, Jens!

 

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:

Switch between workbooks ni EXCEL.

use Alt-TAB to switch between workbooks.

View all Excel hints and tips


Server loaded in 0.09 secs.