FinanceTier 1112 minintermediate

Protect a Shared Ledger, but Allow Sorting

Lock a shared ledger while leaving it open to be re-sorted.

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 ledger

Excel skills

Protect Sheet - Allow Sort · Sheet Protection

The task

The team ledger gets shared with everyone, but people still need to re-sort it by date from time to time. Protect the Ledger 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