How to Protect Workbook in Excel: Step-by-Step Guide

To protect a workbook in Excel, go to the Review tab and click Protect Workbook. You can set a password to prevent others from making structural changes like adding or deleting sheets.

Syntax

In Excel, protecting a workbook is done through the user interface, not by typing a formula. The main steps are:

• Review tab: Find the protection options here.
• Protect Workbook button: Click this to open protection settings.
• Password: Optional, but recommended to prevent unauthorized changes.
• Protection options: You can protect the structure (like adding or deleting sheets) and windows (like resizing).

excel

No formula code; protection is set via Excel ribbon UI.

Example

This example shows how to protect the workbook structure with a password to prevent others from adding, deleting, or moving sheets.

text

1. Open your Excel workbook.
2. Click the <strong>Review</strong> tab on the ribbon.
3. Click <strong>Protect Workbook</strong>.
4. In the dialog, check <em>Structure</em> to protect sheet structure.
5. Enter a password (e.g., <code>mypassword</code>) and confirm it.
6. Click OK.

Now, users cannot add, delete, rename, or move sheets without the password.

Output

Workbook structure is locked; sheet tabs cannot be changed without the password.

Common Pitfalls

• Forgetting the password means you cannot unprotect the workbook.
• Protecting the workbook does not protect individual cells; use Protect Sheet for that.
• Only the structure and windows are protected, not the data inside sheets.
• Make sure to save your workbook after applying protection.

text

Wrong way:
- Protecting only sheets but expecting workbook structure protection.

Right way:
- Use <code>Protect Workbook</code> to lock structure.
- Use <code>Protect Sheet</code> to lock cell editing.

Quick Reference

Action	Location	Purpose
Protect Workbook	Review tab > Protect Workbook	Lock workbook structure and windows
Protect Sheet	Review tab > Protect Sheet	Lock cells and sheet content editing
Set Password	Protect Workbook or Protect Sheet dialog	Prevent unauthorized changes
Unprotect Workbook	Review tab > Unprotect Workbook	Remove protection with password

Key Takeaways

Use the Review tab's Protect Workbook to lock workbook structure.

Set a password to prevent others from changing sheets without permission.

Protect Workbook only locks sheet structure, not cell content.

Use Protect Sheet to lock cells and data inside sheets.

Never forget your password or you cannot remove protection.