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

excel document protection

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

Excel document protection

ResolvedVersion 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!

Excel tip:

Working with 3D formulas

You can only use fill-down if you remove $ for Absolute References.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.