Protect Sheet vs. Protect Workbook in Excel: Key Differences

How-to basics · Updated November 21, 2026

In Excel, Protect Sheet limits what people can change on a particular worksheet, while Protect Workbook can protect the workbook’s sheet structure from changes such as renaming, moving, adding, or deleting sheets. Neither option encrypts the file; use file encryption when you need to restrict who can open it.

What the Two Protection Options Mean

Worksheet protection and workbook-structure protection solve different editing problems. Protect Sheet applies to one worksheet at a time. It can prevent edits to locked cells and, depending on the options you select, restrict actions such as formatting cells, inserting rows, sorting, or using AutoFilter. You can leave selected cells editable so people can enter information while formulas and labels remain protected.

Protect Workbook, in the usual Review-tab workflow, protects the workbook’s structure. This can stop users from adding, deleting, moving, copying, hiding, unhiding, or renaming worksheets. It does not lock the contents of each sheet against editing. For example, someone could still change an unprotected cell in a sheet even when the workbook structure is protected.

These controls are independent. A workbook can have a protected structure but editable sheets, protected sheets but an unprotected structure, both protections, or neither. Choose based on the change you want to prevent rather than treating either command as a general lock for every part of the file.

How to Protect a Worksheet

In Excel for Microsoft 365 on Windows, open the worksheet you want to restrict and select Review > Protect Sheet. In the dialog, choose which actions to allow, enter a password if you want one, and confirm it when prompted. If you leave the password blank, the sheet is still protected against the actions covered by the selected settings, but anyone can turn protection off without entering a password.

Cells are marked as locked by default, but that setting does not take effect until you protect the worksheet. To create an input area, select the cells people should be able to edit, press Ctrl+1, open the Protection tab, clear Locked, and select OK. Then protect the sheet. In Excel for Mac, Command+1 opens Format Cells; the Protection tab and the Review-tab protection command provide the corresponding controls.

When protection is on, Excel blocks editing in locked cells and permits actions you checked in the Protect Sheet dialog. The available permissions let you tailor the sheet. For example, a data-entry form may allow selecting unlocked cells but not formatting cells, inserting columns, or deleting rows. A sheet that users need to filter may need the AutoFilter permission enabled, and the filter should already be in place before protection.

To remove worksheet protection in desktop Excel, select Review > Unprotect Sheet and enter the password if one was set. You can change the allowed actions by unprotecting the sheet and protecting it again with a revised selection. Protection does not stop every possible change to a workbook, and its precise effect depends on the permissions and cell settings you chose.

How to Protect Workbook Structure

To protect sheet structure in Excel for Microsoft 365 on Windows, select Review > Protect Workbook. In the dialog, make sure Structure is selected, enter a password if desired, and confirm it. With structure protection active, commands that alter the sheet arrangement—such as inserting, deleting, moving, copying, renaming, hiding, or unhiding worksheets—are restricted.

Structure protection is useful when the tabs themselves are part of a planned layout. For instance, a monthly reporting workbook might contain one sheet per month plus a summary. Protecting the structure can prevent a collaborator from accidentally deleting a month or renaming a sheet that formulas or instructions expect to have a particular name. It does not, by itself, protect the formulas or data inside those sheets.

To turn it off, select Review > Protect Workbook again, or use the corresponding unprotect command shown in your Excel version, and provide the password if requested. In Excel for Mac, use the Review tab’s workbook-protection control; labels and dialog layout can vary slightly by release. Excel for the web also has protection controls on Review, but some protection settings and workflows may differ from desktop Excel.

Which Protection Should You Choose?

Start by identifying the specific risk. If a user should enter quantities but should not overwrite formulas, protect the worksheet and unlock only the quantity-entry cells. If users may edit sheet contents but should not rename or delete tabs, protect the workbook structure. If both kinds of mistakes are possible, apply both protections and test the result using the same permissions your collaborators will have.

  • Protect a sheet: Use it to restrict editing or selected worksheet actions, such as formatting or inserting rows.
  • Protect workbook structure: Use it to restrict changes to the collection and arrangement of worksheets.
  • Encrypt the file: Use it when people should need a password to open the workbook at all.
  • Use sharing permissions: Use the storage service’s access controls when you need to decide who can access or edit a shared file.

Consider the work people genuinely need to do before enabling restrictions. A sheet that must be sorted, filtered, or formatted may need those actions allowed explicitly. Too many restrictions can make a workbook frustrating to use; too few may leave important formulas or layout elements exposed to accidental edits.

Protect Sheet and Workbook Are Not File Encryption

A common misconception is that a password on Protect Sheet or Protect Workbook makes the whole file confidential. These features are primarily editing controls, not a substitute for encryption. They are intended to prevent ordinary edits or structural changes, not to provide strong protection against someone determined to access or alter the file.

If you need to require a password before a workbook can be opened, use Excel’s file-encryption feature: select File > Info > Protect Workbook > Encrypt with Password, then set and confirm the password. This is different from protecting a sheet or structure. Keep the password somewhere secure: if it is forgotten, Microsoft generally cannot recover an encrypted workbook’s password for you.

For a workbook stored in OneDrive or SharePoint, access permissions can control who can open or edit the shared file. Those permissions address access to the file in that location; sheet protection addresses which operations Excel permits within the workbook. Neither approach should be confused with the other, and a protected sheet is not a reason to share sensitive data with people who should not see it.

Plan the Editable Cells Before Protection

A reliable worksheet setup begins with a clear distinction between input cells and calculation or instruction cells. For example, a simple inventory sheet might have product names and formulas in locked cells, with cells for quantities received left unlocked. Add labels or notes that tell users where to type, then test typical tasks after protecting the sheet.

Before distributing the file, check whether the protected sheet still permits the actions people need. Try entering a value in an unlocked cell, selecting a locked formula cell, applying a filter if relevant, and navigating the sheet. Also check whether the workbook’s formulas refer to sheet names that would be affected by a change in structure. If the workbook will be shared, test a copy rather than risking the original.

Protection settings can be revisited as a workflow changes. If users need to insert rows later, for example, you may need to unprotect the sheet, enable the relevant permission, and protect it again. Do not assume that a cell’s Locked setting alone prevents editing: the worksheet must also be protected for that setting to take effect.

Common Problems and Misunderstandings

  • Users can still edit some cells: Those cells may have been unlocked before the sheet was protected. Review their Locked setting in Format Cells.
  • Users cannot edit a cell they need: Unprotect the sheet, unlock the intended input cells, and protect it again. Confirm that the sheet protection is active afterward.
  • A sheet cannot be renamed or deleted: Workbook structure protection is likely enabled. Unprotect the workbook structure first, assuming you have the password.
  • A password does not stop someone opening the file: Sheet and structure passwords do not require a password to open the workbook. Use Encrypt with Password for that purpose.
  • Sorting or filtering is unavailable: Check the permissions selected in Protect Sheet and whether the relevant filter or sort setup is compatible with the protected sheet.

Passwords for sheet and structure protection are not the same thing as file-encryption passwords, and setting one does not automatically set the others. Keep a record of which protection applies to which workbook, and retain an unprotected backup if you may need to revise the structure or settings later.

Frequently Asked Questions

Does Protect Workbook stop people from editing cells?
Not when you use it to protect workbook structure. It restricts changes to worksheet tabs and their arrangement. To restrict cell edits, protect the relevant worksheet and make sure the cells you want to lock are marked Locked.

Can I protect one sheet but leave another editable?
Yes. Protect Sheet applies to the active worksheet, so you can protect selected sheets individually and leave other sheets unprotected. Workbook structure protection is a separate setting that applies to sheet-level structural changes across the workbook.

Can I use both Protect Sheet and Protect Workbook?
Yes. Use sheet protection for cell and worksheet actions, and structure protection to prevent changes to sheet tabs. Check the permissions on every protected sheet so routine tasks remain possible.

What happens if I forget a sheet-protection password?
Excel does not provide a normal recovery process for a forgotten sheet-protection password. Keep passwords in a secure password manager or retain a safe, authorized backup. Do not confuse this with encrypted-file passwords, which are needed to open the file and may make its contents inaccessible if lost.

Does Protect Sheet hide sensitive information?
No. It limits editing; it is not a privacy feature or reliable confidentiality barrier. Do not put information in a workbook that an authorized recipient should not be able to see. Use file encryption and appropriate sharing permissions when access itself needs to be restricted.

Related

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.