FinanceTier 1112 minintermediate

Protect an Invoice Register, but Allow Filtering

Lock an invoice register while leaving it open to be filtered.

What you will learn

• Protect a sheet while explicitly allowing one action (Filter)
• Explain why sorting and filtering are separate permission points, not one setting
• Recognise when a blanket lock breaks a legitimate everyday use of a shared register

Excel skills

Protect Sheet - Allow Filter · Sheet Protection

The task

This invoice register is shared read-only, but people still need to filter it down to just their own outstanding invoices. Protect the Register 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