Protect Sheet and Workbook in Excel: What’s the Difference?

Protect Sheet and Workbook in Excel: What's the Difference?

In Excel for Microsoft 365 on Windows, use Review > Protect Sheet to restrict changes to a worksheet, and Review > Protect Workbook to restrict structural changes such as adding, deleting, moving, or renaming sheets. These controls prevent accidental or unauthorized edits within the workbook, but they are not a substitute for encrypting a file that contains confidential information.

What sheet and workbook protection mean

Excel has several protections that sound similar but govern different things. Worksheet protection applies to one sheet at a time. It can stop users from changing locked cells, formatting cells, inserting rows, or performing other actions you disallow. You can still leave particular cells editable, which is useful for forms and templates.

Workbook protection, in the usual Review-tab command, protects the workbook’s structure. It limits actions that change the collection or arrangement of worksheets, including inserting, deleting, moving, copying, hiding, unhiding, and renaming sheets. It does not automatically protect the contents of every sheet. To restrict both cell edits and changes to the sheet structure, apply both kinds of protection.

A third feature, password encryption, is different again: it requires a password to open the file. That is the relevant Excel feature when the goal is to keep someone without the password from reading the workbook’s contents. Protecting a sheet or workbook structure alone does not provide that confidentiality.

Protect a worksheet in Excel

Before protecting a sheet, decide which cells should remain editable. By default, Excel marks cells as locked, but that setting only takes effect after sheet protection is turned on. In a data-entry form, for example, you might unlock the cells where staff enter dates and quantities while leaving headings, formulas, and calculated totals locked.

Select the cells users should be allowed to edit. To select separate ranges, hold Ctrl while selecting them on Windows.
Open Home > Format > Format Cells, or press Ctrl+1. On the Protection tab, clear Locked, then select OK. On a Mac, Command+1 opens Format Cells.
Choose Review > Protect Sheet. Select the actions users should still be allowed to perform, such as selecting unlocked cells or sorting, and optionally enter a password.
Select OK. If you set a password, enter it again when Excel asks you to confirm it.

The choices in the Protect Sheet dialog matter. For a simple entry form, allowing users to select unlocked cells while preventing selection of locked cells can make the intended input areas clearer. For a sheet that users need to filter, allow use of AutoFilter; protection does not necessarily make every feature available automatically. Test the protected sheet using the tasks people actually need to do, because some operations can be restricted by the combination of protection settings and the sheet’s setup.

Protect workbook structure

To prevent users from changing the sheet layout, select Review > Protect Workbook and enable the structure protection option in the dialog. You can set a password, then confirm it if prompted. The protection applies to workbook structure rather than to the cells on individual sheets. For instance, a user may be able to enter information in an unprotected worksheet while still being unable to rename or delete a tab if the relevant protection is in place.

Use this protection when sheet names and organization are part of a process. A monthly reporting file might have a tab for each department; preventing accidental renaming or deletion can preserve formulas and references that depend on those sheets. It is also useful when a template relies on a fixed set of tabs. It does not, by itself, stop someone from editing unlocked cells, changing formulas on an unprotected sheet, or viewing the workbook.

Choose the right protection for the job

Start with the action you need to prevent, not with the word “protect.” The distinction is easiest to see in common situations:

Keep users from overwriting formulas: unlock intended input cells and protect the worksheet. Check that formula cells remain locked.
Keep a tab from being renamed or deleted: protect workbook structure.
Allow data entry but preserve the template layout: unlock the entry cells, protect the sheet, and consider protecting workbook structure too.
Keep a person without authorization from opening or reading the file: use password encryption, not just sheet or structure protection.
Share a file while controlling who can edit it: use appropriate file-sharing permissions as well as any in-workbook safeguards. Permissions are managed through the storage or sharing service, not by worksheet protection.

These options can be combined, but each solves a different problem. A protected sheet with no unlocked cells may be difficult for others to use, while a workbook with an encrypted open password can be inaccessible to the intended recipient if the password is lost. Consider usability and recovery before applying restrictions broadly.

What protection does not do

Worksheet and workbook-structure protection are primarily controls for limiting edits in Excel, not robust security boundaries for sensitive data. Microsoft describes worksheet protection as not intended as a security feature. It helps prevent changes to cells and layout through normal Excel use, but it should not be treated as a way to conceal confidential information or withstand a determined attempt to bypass restrictions.

For sensitive content, do not rely on hiding a sheet, hiding formulas, or protecting a worksheet as a substitute for access control. Hidden sheets can be made visible by someone who has sufficient access, and protection does not make the file’s contents unreadable. Store sensitive workbooks in a location with suitable access permissions and use encryption where appropriate. Follow your organization’s rules for handling private or regulated information.

Also remember that protection can inconvenience legitimate users. If a workbook is used for collaborative editing, make the allowed editing areas obvious and document any password or recovery process through an approved secure method. Avoid putting a password in a cell or in a note inside the same workbook; that defeats much of the practical value of setting one.

Passwords, saving, and removing protection

Passwords for sheet protection and workbook-structure protection are optional. A password adds a barrier to turning off the restriction, but it does not turn that protection into file encryption. Choose a password that can be safely shared with the people who maintain the workbook, and store it outside the workbook in an approved password manager or other secure system.

Excel does not provide a way to retrieve a forgotten sheet- or structure-protection password. Before applying a password, confirm who will need to remove protection later and make sure the authorized owner can access it. Keep an unprotected backup when appropriate, especially for a business-critical template. For an encrypted workbook, losing the open password can also prevent access; encryption is not a password-recovery service.

To remove worksheet protection when you are authorized, open the sheet and select Review > Unprotect Sheet. Enter the password if Excel requests it. To remove structure protection, select Review > Protect Workbook again and disable the structure option, entering the password if prompted. Save the workbook after changing protection. If a command is unavailable or appears different, confirm that the workbook is open in the desktop app and that you have permission to make the change.

Protect a file with an opening password

If the requirement is that a person must enter a password before viewing the workbook, use encryption. In Excel for Microsoft 365 on Windows, choose File > Info > Protect Workbook > Encrypt with Password, enter a password, and confirm it. Save the file. The exact interface can vary in other Excel versions, so check the options for the version you use. This is distinct from the Protect Sheet and Protect Workbook commands on the Review tab.

Encryption affects access to the workbook as a whole, so anyone who needs to open it must receive the password through a suitable channel. It is not a way to give different people different permissions for individual sheets. For shared files, combine appropriate storage permissions with workbook-level controls, and avoid sending the password in the same message as the encrypted file when stronger separation is needed.

Common problems and useful checks

If users cannot type in a cell after you protect a sheet, first check whether the cell is locked. Select it, open Format Cells, and inspect the Protection tab. If it should accept input, clear Locked while the sheet is unprotected, then protect the sheet again. If formulas are editable when they should not be, inspect their Locked setting as well; cell formatting and sheet protection work together.

If someone can still rename a sheet, check that workbook structure protection—not just sheet protection—is enabled. Conversely, if users can still edit a cell, check the sheet’s protection status and the cell’s Locked property. These are separate controls, so turning on one does not imply that the other is active.

After setting protection, test a copy of the workbook as a typical user would. Try entering data in intended input cells, changing a formula, inserting a row if relevant, and renaming a tab. Confirm that permitted actions remain possible and prohibited actions are blocked. This small check catches misconfigured locked cells and overly restrictive options before a workbook is distributed.

Frequently Asked Questions

Does Protect Sheet stop people from opening an Excel file?
No. It restricts certain actions on a worksheet after the file is open. Use Encrypt with Password if the workbook should require a password to open.

Does Protect Workbook protect every sheet’s cells?
No. The Review-tab command protects workbook structure, such as sheet names and arrangement. Protect individual worksheets separately to restrict cell changes.

Can I allow edits to some cells on a protected sheet?
Yes. While the sheet is unprotected, clear the Locked setting for the cells that users may edit, then protect the sheet. Locked cells are restricted only while sheet protection is active.

Can I protect a sheet without a password?
Yes. You can turn on sheet protection without entering a password. A password is optional, but without one a person can generally turn off that protection through Excel’s interface.

What if I forget the protection password?
Excel does not provide a password-recovery function for sheet or workbook-structure protection. Keep an authorized copy or securely stored password when you set protection, and do not rely on these controls as your only copy of important work.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.