Require users enter the password "Pr@5word" before they can make structural changes to the workbook.

Question

Explanation

Protecting Workbook Structure with a Password in Excel

Overall Goal

This task requires applying Workbook Protection - specifically protecting the structure of the workbook. "Structural changes" means actions like adding, deleting, moving, renaming, hiding, or unhiding sheets. This is distinct from sheet protection (which locks cells) - workbook protection locks the workbook's architecture.

Step-by-Step Breakdown

1. Go to the Review tab

The Review tab houses all protection-related commands. Nothing else on the ribbon controls workbook-level structural protection.

Skipping this: You won't find "Protect Workbook" anywhere else - it's only on the Review tab.

2. Click "Protect Workbook" (in the Protect group)

This opens the Protect Structure and Windows dialog. The Structure checkbox should be checked (it is by default). This is what prevents structural changes.

Do not confuse this with "Protect Sheet" - that protects cell-level edits within one sheet, not the workbook structure.

3. Type the password Pr@5word in the Password field

The password is optional but required by this task. It ensures that only someone with the password can unprotect the workbook later.

If you skip the password and just click OK, the workbook is protected - but anyone can remove that protection with a single click. The password enforces it.

4. Click OK, then re-enter Pr@5word to confirm

Excel requires confirmation to guard against typos. If the two entries don't match, the password is rejected entirely.

Mistyping during confirmation means you'd need to start over - and worse, if you mistype consistently both times, you lock yourself out.

5. Click OK

Protection is applied. You'll notice the "Protect Workbook" button appears highlighted/active, confirming it's on. Right-clicking sheet tabs will now show grayed-out structural options.

What Would Go Wrong Out of Order

• Using Protect Sheet instead of Protect Workbook: Cells get locked, but users can still add/delete/rename sheets - the structural changes are unaffected.
• Skipping password confirmation: Excel won't let you proceed if the two password entries don't match.

Memory Tip

"Structure = Workbook, Content = Sheet"

If the question says structural changes (sheets, tabs, layout) → Protect Workbook If the question says cell changes (editing, formatting) → Protect Sheet

No community discussion yet for this question.