Sheet protection in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does sheet protection do in Excel?

Sheet protection prevents users from changing locked cells or the structure of the sheet, helping to keep data safe.

beginner

How do you lock cells before protecting a sheet?

Select the cells, right-click, choose 'Format Cells', go to the 'Protection' tab, and check 'Locked'. Then protect the sheet to enforce locking.

intermediate

What happens if you protect a sheet without locking any cells?

If no cells are locked, protecting the sheet won't stop users from editing any cells because all cells are editable by default.

intermediate

Can you allow users to select locked cells on a protected sheet?

Yes, when protecting the sheet, you can choose to allow selecting locked cells or only unlocked cells.

beginner

What is the purpose of setting a password when protecting a sheet?

A password prevents others from unprotecting the sheet without permission, adding an extra layer of security.

What is the first step to protect specific cells in Excel?

A Lock the cells you want to protect

B Protect the sheet immediately

C Hide the cells

D Delete the cells

You must lock the cells first before protecting the sheet to make protection effective.

What happens if you protect a sheet without a password?

A No one can unprotect it

B Anyone can unprotect it easily

C The sheet deletes automatically

D Cells become hidden

Without a password, anyone can unprotect the sheet by clicking 'Unprotect Sheet'.

Which tab in 'Format Cells' lets you lock or unlock cells?

A Font

B Number

C Alignment

D Protection

The 'Protection' tab contains the 'Locked' checkbox for cells.

Can users edit unlocked cells on a protected sheet?

A Yes

B No

C Only if they have a password

D Only if the sheet is unprotected

Unlocked cells remain editable even when the sheet is protected.

What option can you choose when protecting a sheet to allow users to select only unlocked cells?

A Allow editing locked cells

B Hide locked cells

C Allow selecting unlocked cells

D Allow deleting rows

You can restrict selection to unlocked cells only for easier navigation.

Explain the steps to protect a sheet in Excel and why locking cells is important.

Think about what you do before and after protecting the sheet.

Describe how passwords enhance sheet protection and what happens if you don't use one.

Consider who can change protection settings.