Administration and Executive AssistantTier 1110 minintermediate

Protect a Tracker, but Allow Filtering

Lock a shared ticket list while leaving AutoFilter usable.

What you will learn

• Protect a sheet while explicitly allowing one action (Filter)
• Recognise that sorting and filtering are separate permissions, not one setting
• Choose the right exception for the way a sheet is actually going to be used

Excel skills

Protect Sheet - Allow Filter · Sheet Protection

The task

This ticket list is shared read-only, but people still need to filter it down to just their own open tickets. Protect the Tickets sheet so nobody can edit it, while still allowing AutoFilter.

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