Protect Sheet vs. Protect Workbook in Excel: Key Differences

In Excel, Protect Sheet limits what people can change on one worksheet, while Protect Workbook (in the Review tab) protects the workbook’s structure, such as preventing sheets from being added, deleted, moved, renamed, hidden, or unhidden. They are separate controls: sheet protection governs editing within a sheet; workbook structure protection governs changes to the set and arrangement of sheets.

The basic difference

An Excel workbook is the file, and it can contain multiple worksheets. Protect Sheet applies to a particular worksheet at a time. If a workbook has five sheets, protecting one does not automatically protect the other four. Workbook structure protection applies across the workbook’s sheet tabs, restricting structural changes to those tabs.

The names can cause confusion because both commands appear under Excel’s protection features, and both can use passwords. But choosing Protect Workbook does not mean that every cell in every sheet becomes read-only. Likewise, protecting a sheet does not stop someone from renaming or deleting that sheet if the workbook’s structure remains unprotected.

What Protect Sheet controls

Sheet protection lets you limit edits to cells and other elements on a worksheet. In Microsoft Excel for Microsoft 365 on Windows, go to Review > Protect Sheet. The dialog lets you choose which actions remain available, such as selecting locked or unlocked cells, formatting cells, inserting rows, sorting, or using an AutoFilter. The available actions can depend on the sheet’s contents and the options you select.

Excel cells have a Locked property, but it generally has no effect until you protect the sheet. By default, cells are usually marked as locked, so protecting a sheet without preparing it can prevent users from changing most cells. A common design is to protect formulas and headings while leaving designated input cells editable.

Protect formulas: Lock formula cells so a user can enter data without accidentally replacing a calculation.
Allow input: Leave specific cells unlocked so users can fill in names, dates, quantities, or other intended inputs.
Limit layout changes: Disallow actions such as formatting cells or inserting and deleting rows, if those changes could disrupt the sheet.
Keep selected actions available: Allow sorting or filtering where appropriate, while restricting other edits.

Sheet protection is therefore about controlling permitted actions on a worksheet, not making the sheet invisible or turning the whole file into a read-only document. If users need to enter information, check the allowed actions and unlocked cells before sharing the file.

What Protect Workbook controls

For the distinction discussed here, Protect Workbook means protecting the workbook’s structure. In Excel for Microsoft 365 on Windows, use Review > Protect Workbook. With structure protection enabled, users are prevented from making certain changes to sheet tabs, including adding, deleting, moving, copying, renaming, hiding, or unhiding worksheets. The exact actions blocked depend on the protection state and Excel’s interface.

For example, a workbook might contain separate sheets for January, February, and March. Structure protection can help prevent a recipient from accidentally deleting February or moving the sheets into an unintended order. It does not, by itself, stop that recipient from editing unlocked cells on those sheets, changing unprotected formulas, or viewing the sheet contents.

Workbook structure protection is not the same as protecting the workbook file with a password required to open it. The Review-tab control restricts structural changes after the file is open; it is not an access barrier. File encryption is a separate feature, available through File > Info > Protect Workbook > Encrypt with Password in Windows desktop Excel.

How to protect a sheet while keeping input cells editable

Set up the sheet before turning on protection. In a typical form or template, you first identify which cells people may edit, unlock those cells, and then protect the sheet with appropriate permissions.

Select the cells users should be able to change. To select nonadjacent cells, hold Ctrl while selecting each range in Windows.
Open Format Cells with Ctrl+1, choose the Protection tab, clear the Locked checkbox, and select OK. The Locked setting takes effect when the sheet is protected.
Go to Review > Protect Sheet. Choose whether users may select locked cells or unlocked cells, and select any other actions they genuinely need.
Optionally enter a password, confirm it if prompted, and store it somewhere reliable. A password is not required for the sheet-protection feature, but anyone may be able to remove protection if none is set.
Test the result by trying to edit an input cell and a formula cell. Confirm that permitted tasks, such as filtering, still work if you allowed them.

On a Mac, Excel provides similar protection controls on the Review tab, though the dialog layout and keyboard shortcuts can differ; Command+1 opens Format Cells in many Mac versions. Excel for the web also has sheet-protection capabilities, but some options and workbook-structure workflows differ from desktop Excel. If you cannot find a setting, open the file in the desktop app and check the Review tab.

How to protect workbook structure

When the worksheet tabs themselves should not be reorganized, go to Review > Protect Workbook in Windows desktop Excel. Set a password if you want to require it to turn off structure protection, then confirm the password if Excel asks. The workbook’s sheet-tab actions are then restricted, but the cell-level permissions on each sheet remain whatever they were before.

A useful setup can combine both protections. For a monthly reporting file, protect each sheet so users can fill in the intended input cells but not overwrite formulas, then protect the workbook structure so they do not accidentally delete or rename a month. Test both controls separately: try editing a protected formula, then try renaming a tab. A successful test of one does not prove the other is active.

What these protections do not do

Neither sheet protection nor workbook structure protection should be treated as strong confidentiality or file-access security. Sheet protection is intended mainly to prevent accidental or routine changes. It does not encrypt the workbook, and it should not be relied on to keep sensitive data secret. A person who can open the file may still be able to see information in protected sheets, depending on what is visible and how the workbook is configured.

Workbook structure protection also does not require a password just to open the file. If you need to restrict access to the file itself, use the separate password-encryption option in desktop Excel and share the password securely. Keep in mind that losing an encryption password can make the file inaccessible; Microsoft does not provide a way to recover a forgotten password for an encrypted workbook. For important files, keep a secure backup and test access before relying on a password-protected copy.

Hiding a sheet is not a substitute for security either. A hidden sheet may be unhidden if workbook structure is not protected, and protection does not make its contents confidential. Do not place information in a workbook that recipients are not authorized to see merely because a sheet is hidden or protected.

Which protection should you choose?

Choose based on the kind of change you want to prevent. If the concern is a user overwriting formulas, changing a carefully designed layout, or editing a particular worksheet, use Protect Sheet and configure the cell locks and allowed actions. If the concern is someone accidentally deleting, renaming, moving, or hiding worksheet tabs, protect the workbook structure.

Shared data-entry template: Unlock the intended input cells, protect the sheet, and allow only the actions users need.
Multi-tab report: Protect the sheets if their contents should not be casually edited; protect workbook structure if the tab arrangement also needs to stay intact.
Confidential workbook: Use file encryption to restrict opening, rather than relying on sheet or structure protection. Consider whether recipients should receive the sensitive data at all.
Read-only review: Consider sharing a read-only copy or using file-sharing permissions as well as appropriate Excel protection. Sheet protection alone does not prevent every form of copying or viewing.

There is no need to enable every restriction automatically. Overly strict settings can block routine work—for instance, users may need to sort records, filter a table, or add rows. Decide what must stay unchanged and allow the remaining actions that are part of the workflow.

Common problems and misconceptions

“I protected the workbook, but I can still edit cells.” You probably protected its structure, not the individual sheets. Protect each worksheet whose cell contents need restrictions.

“I protected the sheet, but someone renamed its tab.” Sheet protection and workbook structure protection are independent. Protect the workbook structure to restrict tab changes.

“The sheet is protected, but I cannot type in my input cells.” Those cells may still be marked Locked, or the protection options may prevent selecting or editing them. Unprotect the sheet, check the cells’ Protection setting in Format Cells, and review the allowed actions.

“I protected the sheet, but the cells were still visible.” Protection is not encryption or concealment. It controls edits and selected sheet actions; it does not hide the data from someone who can open the workbook.

“I forgot the protection password.” Excel does not provide a general password-recovery button for removing protection. If the file is important, look for the password in your organization’s approved records or use an unprotected backup. Do not assume that an Excel protection password is the same as a password required to open an encrypted file.

Frequently Asked Questions

Does Protect Workbook protect every sheet’s cells?
No. Workbook structure protection restricts changes to the workbook’s sheet tabs. Protect each sheet separately if you need to limit edits to its cells or objects.

Can I protect a sheet without a password?
Yes. A password is optional for sheet protection. Without one, however, protection can be turned off without entering a password, so it offers little resistance to someone intentionally changing the sheet.

Can I use Protect Sheet and Protect Workbook together?
Yes. They address different things: protect sheets to manage editing within them, and protect workbook structure to restrict changes to sheet tabs. Set up and test each protection independently.

Does protecting a sheet stop people from viewing its data?
No. Sheet protection is not a confidentiality feature. Use file encryption when you need a password to open the workbook, and avoid sharing data a recipient should not see.

How do I remove sheet or workbook protection?
In desktop Excel, select the protected sheet and use Review > Unprotect Sheet, or use Review > Protect Workbook to turn off structure protection. If a password was set, Excel will ask for it. The web and Mac interfaces may present the controls differently.

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.