Workbook protection in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is workbook protection in Excel?

Workbook protection is a feature that helps prevent others from making changes to the structure of your Excel file, like adding, deleting, or moving sheets.

beginner

How do you enable workbook protection in Excel?

Go to the Review tab, click on 'Protect Workbook', then choose to protect the structure and optionally set a password.

beginner

What does protecting the workbook structure prevent?

It prevents users from adding, deleting, renaming, moving, or hiding sheets within the workbook.

beginner

Can workbook protection stop users from editing cell contents?

No, workbook protection only controls the workbook's structure. To protect cell contents, you need to protect individual worksheets.

intermediate

What happens if you forget the password set for workbook protection?

You will not be able to unprotect the workbook structure without the password, so it is important to keep it safe.

Which Excel tab contains the option to protect a workbook?

A Review

B Home

C Insert

D Data

The Review tab has the 'Protect Workbook' option to secure the workbook structure.

What does protecting the workbook structure NOT prevent?

A Adding new sheets

B Deleting sheets

C Renaming sheets

D Editing cell contents

Workbook protection controls sheet structure, but does not stop editing cells.

If you want to stop users from changing cell data, what should you do?

A Protect the worksheet

B Save as PDF

C Hide the workbook

D Protect the workbook

Protecting the worksheet locks cells from editing, unlike workbook protection.

What is a good practice when setting a password for workbook protection?

A Use a simple password like '1234'

B Share the password with everyone

C Write the password down and keep it safe

D Do not use a password

Keep the password safe because losing it means you cannot unprotect the workbook.

Which action is blocked by workbook protection?

A Changing cell formulas

B Moving sheets to another workbook

C Typing in a cell

D Formatting cells

Workbook protection prevents moving sheets, but not editing cell content or formatting.

Explain how to protect the structure of a workbook in Excel and what it prevents.

Think about the steps in the Review tab and what changes you want to block.

Describe the difference between workbook protection and worksheet protection in Excel.

One protects sheets themselves, the other protects cells inside sheets.