Administration and Executive AssistantTier 1110 minintermediate

Protect a Tracker, but Allow Sorting

Lock a shared tracker while leaving it open to be re-sorted, using a specific protection exception.

What you will learn

• Protect a sheet while explicitly allowing one action (Sort)
• Explain the difference between locking a sheet completely and locking it with exceptions
• Recognise when a blanket lock breaks a legitimate everyday use of a shared file

Excel skills

Protect Sheet - Allow Sort · Sheet Protection

The task

The team task tracker gets shared with everyone, but people still need to re-sort it by due date from time to time. Protect the Tracker sheet so its contents can't be edited, while still allowing sorting.

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