FinanceTier 1112 minintermediate

Protect an Expense Claim Template, but Allow New Rows

Lock a reusable expense claim template while leaving it open to have new rows added.

What you will learn

• Protect a sheet while explicitly allowing one action (Insert Row)
• Explain why a template that blocks its own core purpose defeats the point of protecting it
• Recognise which single exception a reusable template actually needs

Excel skills

Protect Sheet - Allow Insert Row · Sheet Protection

The task

This expense claim template gets reused every month: people should not be able to change its headers or formatting, but they do need to be able to add new claim rows. Protect the Claim Log sheet while still allowing new rows to be inserted.

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