Excel Protect Sheet From Being Deleted: The Right Setting

To stop a worksheet from being deleted in Excel for Microsoft 365 on Windows, protect the workbook’s structure: go to Review > Protect Workbook, select the structure option, and optionally set a password. Protect Sheet is a different feature; by itself, it does not prevent someone from deleting the worksheet tab.

The short answer: protect workbook structure

Excel does not provide a separate sheet-level setting whose job is to prevent that particular sheet from being deleted. Deleting a tab is a workbook-structure action, so the relevant control applies to the workbook as a whole. Once workbook structure is protected, Excel blocks structural changes such as deleting, adding, moving, renaming, hiding, or unhiding sheets.

This is useful when a workbook has a carefully arranged set of tabs—for example, a monthly reporting file with an Instructions sheet, twelve monthly sheets, and a Summary sheet. If structure protection is on, a colleague cannot accidentally delete April or rename the Summary tab through the usual sheet commands. The same protection also means you cannot make those changes yourself until you unprotect the structure.

Remember the distinction: worksheet protection controls certain changes to cells and objects on a sheet; workbook structure protection controls changes to the workbook’s sheet tabs. If your goal is to preserve a tab, use the latter.

How to protect a worksheet from deletion

Open the workbook in the Excel desktop app and select the Review tab.
Choose Protect Workbook. In the protection dialog, make sure Structure is selected.
Optionally enter a password, confirm it if prompted, and select OK. If you set a password, store it somewhere appropriate; you will need it to turn off the protection.
Check that the workbook structure is protected. Try the sheet-tab commands only if you are confirming the setting in a safe test copy; delete, rename, insert, and similar structural actions should be unavailable.

The exact dialog wording can vary slightly by Excel build, but the important control is workbook structure, not Protect Sheet. With no password, structure protection can still restrict normal sheet-tab actions, but anyone with access may be able to turn the protection off. A password adds a barrier to removing the setting; it does not encrypt the workbook or make its contents secret.

To remove the restriction later, return to Review > Protect Workbook and provide the password if Excel asks for it. After the structure is unprotected, sheet tabs can again be added, moved, renamed, hidden, unhidden, or deleted according to the user’s other permissions.

What workbook structure protection blocks

Structure protection is intended to preserve the workbook’s organization. When it is active, a user generally cannot perform the following actions in that workbook:

Delete a worksheet or chart sheet.
Insert a new worksheet or chart sheet.
Rename a sheet or move it to another position in the tab order.
Hide a visible sheet or unhide a hidden sheet.

These restrictions apply across the workbook, not just to one selected tab. For instance, you cannot protect only the Summary tab from deletion while leaving the other tabs structurally editable. If a workbook contains sheets that different people need to manage, consider whether one workbook-wide rule is practical before enabling it.

Structure protection does not stop users from doing all work inside the sheets. They may still be able to enter or change cell values, edit formulas, sort data, or use other features, depending on the sheet’s settings and the workbook’s design. It also does not determine who can open the file. Those are separate questions, handled by worksheet protection, file access permissions, or file encryption.

Protect Sheet versus Protect Workbook

The similar names cause a common mistake. Review > Protect Sheet protects selected aspects of a worksheet’s contents. It can restrict actions such as editing locked cells, formatting cells, or inserting rows, depending on the options chosen. It does not, on its own, lock the workbook’s sheet-tab structure. A protected sheet can still be deleted if the workbook structure is not protected.

Review > Protect Workbook is the setting to use when you want to prevent a tab from being deleted, renamed, moved, hidden, or replaced by inserting another sheet. You can use both settings together: protect the workbook structure to preserve the tabs, and protect individual sheets to limit edits to their contents.

For example, suppose a team uses a template with a locked Instructions sheet and editable input cells on a Data sheet. Protecting the Data sheet can limit edits to designated cells, while workbook structure protection helps preserve both tabs. Neither setting substitutes for the other. If people should be able to edit the data but not change the tab arrangement, structure protection is the relevant control.

Passwords, security, and sensible safeguards

A workbook-structure password helps prevent users from casually switching off the restriction through Excel’s interface. Treat it as a control against accidental or unauthorized changes by ordinary users, not as strong confidentiality protection. The workbook’s contents are not hidden merely because its structure is protected, and a person who can access the file may still be able to read or copy data that is available to them.

For sensitive information, manage access to the file itself using appropriate storage and sharing permissions, and consider Excel’s file-encryption options where suitable. File encryption is different from sheet or workbook protection: it is intended to restrict opening the file, while sheet and structure protection control editing actions within an open workbook. In a work or school environment, your organization’s Microsoft 365 administrator may also control who can access the file.

Before applying a password, decide who will maintain the workbook and how the password will be handed over. If the password is lost, Excel may not provide a simple way to remove the protection; do not assume that Microsoft can recover it for you. Keep an authorized, unprotected backup when appropriate, store passwords in an approved password manager, and avoid sharing passwords in the same place as the workbook.

Sharing and Excel for the web

If several people edit a workbook, structure protection can reduce accidental damage to its layout, but it is not a replacement for careful collaboration settings or version history. Users who can edit cells may still change data while the protected structure remains in place. If a sheet is deleted before protection is enabled, protection will not restore it; use version history or a backup to recover earlier content when available.

For the most predictable setup and management of workbook-structure protection, use the Excel desktop app. Excel for the web has feature differences, and its interface may not provide the same controls for setting or removing this protection. If you cannot find the structure option in a browser, open the workbook in the desktop app and use Review > Protect Workbook. In Excel for Mac, use the Review tab and the Protect Workbook control; dialog details can differ from Windows, but the purpose is the same.

When sharing a file, test the finished workbook with a non-owner account or a copy if you need to confirm what collaborators can do. Also make sure the file is saved after setting protection. For important workbooks, keep a clean template or backup so an accidental change or forgotten password does not leave the only copy unusable.

Common problems and how to fix them

The Delete command is still available. Confirm that you selected Protect Workbook and enabled Structure. Protect Sheet alone does not block sheet deletion. If the option is already active, check that you are working in the intended file rather than another copy.
You cannot rename, move, or add tabs either. That is expected when workbook structure is protected. Unprotect the workbook structure, make the needed changes, then protect it again.
You are asked for a password you do not know. Ask the workbook’s owner or administrator for the password or an authorized editable copy. Do not assume that worksheet protection and structure protection use the same password; they can be set independently.
The button or option is unavailable. The workbook may be open in Excel for the web, may have restrictions from its location or sharing setup, or may be in a state that limits editing. Try the desktop app and check whether you have permission to edit the file.
You protected the workbook but can still edit cells. That is normal. Structure protection is about sheet organization, not cell contents. Use Protect Sheet separately if you need to limit worksheet editing.

Alternatives when structure protection is not enough

If your main concern is accidental deletion, workbook structure protection is usually the simplest built-in safeguard. If the concern is access by people who should not see the information, manage file permissions or use file encryption instead. If users need to work on a subset of information, consider distributing a separate workbook with only the sheets and data they need rather than relying on a protected tab to conceal content.

Another practical safeguard is to maintain a clearly named master template and create working copies for routine use. Version history in a supported cloud storage location can also help recover an earlier file state after an unwanted change, subject to the organization’s retention settings. These measures complement structure protection; they do not make a protected workbook impossible to alter or guarantee recovery in every situation.

Frequently Asked Questions

Does Protect Sheet stop someone from deleting a tab?
No. Protect Sheet restricts selected changes to a sheet’s contents and features. To block deletion of the tab through Excel’s normal controls, protect the workbook structure.

Can I protect just one sheet from being deleted?
Not with workbook structure protection. It applies to the workbook’s sheet structure as a whole, so it restricts structural changes to all sheets rather than targeting one tab.

Can I still edit cells after protecting workbook structure?
Usually, yes. Workbook structure protection does not automatically protect cell contents. Whether cells can be edited depends on the sheet’s protection settings and other workbook controls.

Can I delete a sheet if I know the structure password?
Yes. Turn off workbook structure protection using the password, delete the sheet, and protect the structure again if needed. Keep a backup before making changes to an important workbook.

Does hiding a sheet protect its contents?
No. Hiding a sheet changes whether its tab is visible; it is not a confidentiality measure. Structure protection can block ordinary unhiding while enabled, but it does not encrypt the sheet’s data or control who can access the workbook.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.