Administration and Executive AssistantTier 1110 minintermediate

Protect a Template, but Allow New Rows

Lock a reusable entry template without blocking the one thing it exists for: adding a new row.

What you will learn

• Protect a sheet while explicitly allowing one action (InsertRow)
• Explain why a template needs a deliberately chosen exception rather than a blanket lock
• Avoid over-protecting a sheet to the point that it can no longer do its job

Excel skills

Protect Sheet - Allow Insert Row · Sheet Protection

The task

This expense log 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 expense rows. Protect the Expense 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