Administration and Executive AssistantTier 1115 minadvanced

Protect a Master List with Two Deliberate Exceptions

Combine an allowed exception with a denied one on the same protected sheet.

What you will learn

• Protect a sheet with more than one deliberate permission decision at once
• Explain why a master list is usually re-sortable but not re-formattable by everyone who opens it
• Read a real Protect Sheet dialog and map its checkboxes to specific outcomes

Excel skills

Protect Sheet - Multiple Exceptions · Sheet Protection

The task

This supplier master list gets re-sorted often by different people, but its formatting (column widths, colours, styles) should never change no matter who opens it. Protect the Suppliers sheet, allow sorting, and make sure cell formatting specifically stays locked.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free