Delete a Protected Sheet in Excel: Steps and Fixes

How-to basics · Updated November 20, 2026

To delete a protected sheet in Excel, first remove its sheet protection: open the sheet, choose Review > Unprotect Sheet, and enter the password if prompted. Then right-click the sheet tab, choose Delete, and confirm. If you do not know the password, ask the workbook owner; Excel does not provide a supported way to remove password protection without it.

Sheet protection and workbook-structure protection are separate settings. The first restricts changes to cells on a sheet; the second can prevent sheets from being deleted, moved, renamed, or hidden. The steps below cover both, along with what to do if a command is unavailable.

What You’ll Need

  • The workbook file: Open the correct workbook in Excel. If it is stored on OneDrive or SharePoint, make sure you have permission to edit it.
  • Permission to change the workbook: You may need the workbook owner or administrator to grant editing access.
  • The protection password, if one was set: Excel asks for it when you unprotect a sheet or protected workbook structure. If you do not have it, request it from the person who protected the file.
  • A backup if the sheet may contain useful information: Deleting a sheet removes its cells, formulas, charts, and other sheet content from the workbook. Save a copy first if you might need any of it.

Step-by-Step

  1. Open the workbook and identify the sheet. In Excel for Microsoft 365 on Windows, open the workbook and look at the sheet tabs along the bottom. Select the tab you intend to remove and check its name and contents. If tabs are hidden, use the sheet-navigation arrows at the lower left to find them, or ask whether the sheet is hidden rather than protected. On Mac, sheet tabs are also along the bottom of the workbook window. In Excel for the web, open the workbook in the browser and select the sheet tab.
  2. Save a safety copy if the content could matter later. In desktop Excel, use File > Save As to make a separate copy before changing the workbook. In Excel for the web, use the available copy or download option, or make a copy from OneDrive or SharePoint if you have permission. This is especially useful for sheets containing formulas, records, or charts that are not duplicated elsewhere. A deletion may be undoable immediately, but do not rely on undo as your backup.
  3. Unprotect the sheet. In Excel for Microsoft 365 on Windows, select the sheet, open the Review tab, and choose Unprotect Sheet. If Excel prompts for a password, enter the password supplied by the owner, then confirm. In Excel for Mac, select the sheet and use Review > Unprotect Sheet; enter the password if asked. In Excel for the web, open Review and look for Unprotect Sheet or Manage Protection, then turn off protection for that sheet. The exact web controls can vary with the account and current interface. If the command instead offers to protect the sheet, it is already unprotected.
  4. Check whether workbook structure is protected. Try right-clicking the sheet tab. If Delete is unavailable, or Excel says the workbook structure is protected, go to Review and look for Protect Workbook. In desktop Excel, select that command to turn off structure protection and provide its password if requested. The command may be shown as a selected or highlighted control while protection is on. In Excel for the web, check the Review tab for the workbook protection controls available to your account. If you cannot change the setting or do not have the password, ask the owner to unlock the structure. Unprotecting the sheet alone does not remove workbook-structure protection.
  5. Delete the sheet. Right-click the tab for the sheet you want to remove and select Delete. Read Excel’s warning about permanent deletion, then confirm only if you have selected the right tab and do not need its contents. You can also select the sheet and use Home > Delete > Delete Sheet on the Windows desktop ribbon. On Mac, use the sheet-tab context menu or the Home tab’s delete controls. In Excel for the web, right-click the tab and select Delete if that option is available.
  6. Verify the result and save. Check that the intended tab is gone and that the remaining sheets still work as expected. Look for formulas or charts that may have referred to the deleted sheet; those references can become errors. Save the workbook. For a shared file, confirm that your changes have synchronized before closing it.

If the sheet you want to remove is the workbook’s only worksheet, Excel will not let you leave the workbook with no sheets. Add a replacement first using the plus button beside the sheet tabs, then delete the old sheet. If workbook structure is protected, you must unlock that structure before adding or deleting tabs.

Common Mistakes

  • Confusing cell protection with workbook protection. Unprotecting a sheet lets you change its cells, but it may not allow you to delete the tab. A protected workbook structure can still block sheet operations.
  • Trying to delete before unprotecting. The tab’s Delete command may be disabled or produce a protection message. Remove the relevant protection first, using the correct password.
  • Deleting the wrong tab. Sheet names can be similar, and a selected tab may not be the one you intended. Click the tab and inspect the sheet before using Delete.
  • Deleting a group of sheets accidentally. If multiple tabs are selected or grouped, a delete action may affect more than one sheet. Click a single tab before deleting and check which tabs appear selected.
  • Assuming a protected sheet is encrypted. Sheet protection is intended to restrict editing, not to hide information from someone who can access the workbook. Do not use it as a substitute for secure storage of confidential data.
  • Saving over the only copy. A deleted sheet can include formulas, notes, or charts that are difficult to recreate. Save a copy first when there is any doubt about whether the sheet is needed.

Tips

  • Ask for the password instead of trying workarounds. If the sheet or workbook belongs to a colleague, client, or organization, request the password or ask the owner to delete the sheet. This preserves the workbook’s access controls and avoids risking file damage.
  • Check for dependencies before deleting. Other sheets may contain formulas, charts, named ranges, or links that refer to the sheet. If you need to keep the data but not the tab, copy the relevant information to another sheet or workbook before deleting it.
  • Use a duplicate workbook to test uncertain changes. A copy lets you confirm that the right tab is removed and check whether formulas still calculate before making the same change to the working file.
  • Understand the difference between hiding and deleting. Hiding a sheet removes its tab from view but keeps its contents in the workbook. If you only want to simplify what users see, hiding may be more appropriate. Workbook-structure protection can also prevent hiding or unhiding sheets.
  • Be cautious with shared workbooks. Coordinate with other editors before deleting a sheet. In a cloud workbook, wait for the change to sync, and check version history or the file owner’s recovery options if something is removed by mistake.

Troubleshooting

Unprotect Sheet asks for a password you do not have: Stop and contact the workbook owner, creator, or administrator. Ask them to provide the password or perform the deletion. If you own the file, check your password manager, documentation, or an earlier copy for the password. Do not assume that renaming the file or changing its extension will unlock it.

Delete is greyed out or missing: First check whether the workbook is read-only or opened with view-only permissions. If you can edit the file, check for workbook-structure protection under Review > Protect Workbook. In a shared or managed file, an organization policy or restricted permission may also prevent changes. Ask the owner for edit access or for the sheet to be removed.

Excel says the workbook structure is protected: This is not the same as sheet protection. Turn off workbook-structure protection from the Review tab and enter its password. If you cannot supply the password, the supported fix is to ask the person who set it or an authorized administrator to unlock the workbook.

The sheet tab is not visible: It may be hidden, or the workbook may be displaying only a portion of its tabs. Use the navigation arrows by the tabs to scroll through them. If you can access the Home > Format > Hide & Unhide menu in desktop Excel, check Unhide Sheet. If the sheet is listed, select it and unhide it before proceeding. If the workbook structure is protected, you may need its password to unhide it.

The deleted sheet appears in formulas as a reference error: Excel may show an error such as #REF! where a formula referred to the removed sheet. If you have not made other changes, try Undo immediately, then copy or move any required data and update the dependent formulas before deleting again. Otherwise, restore a backup or use the file owner’s version history, if available.

The web version does not show the same controls: Open the workbook in the desktop application if you have access, then use the Review controls there. If the file is read-only or the browser interface does not offer an unprotect or delete command, ask the owner to change your permissions or make the change for you. The password is still required when protection is password-based.

Frequently Asked Questions

Can I delete a protected sheet without the password?
No, not through Excel’s supported interface when a password is required to unprotect it. Ask the owner or an authorized administrator to provide the password or delete the sheet. If there is no password prompt, the issue may instead be workbook-structure protection or your edit permissions.

Does Unprotect Sheet delete the worksheet?
No. It only removes the restriction on editing that sheet. You must separately select the sheet tab and choose Delete to remove the worksheet and its contents from the workbook.

Why can I edit some cells but not delete the sheet?
Sheet protection can allow specific cells or actions while restricting others. In addition, workbook-structure protection is a separate setting that can block deleting tabs even after the sheet itself has been unprotected.

Can I recover a sheet after deleting it?
If you have not made other changes, try Undo right away. If the workbook was saved or closed, recovery may depend on a backup, version history, or the file owner’s recovery options. A separate copy made before deletion is the safest option.

Can I delete the last sheet in a workbook?
No. Excel requires a workbook to contain at least one worksheet. Add a replacement sheet first, then delete the sheet you no longer need.

Is hiding a protected sheet the same as deleting it?
No. A hidden sheet remains in the workbook and can be unhidden by someone with the required access. Deleting removes the sheet and its contents from the workbook, so choose based on whether the data should be retained.

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.