Fix Excel 2016 When You Cannot Delete Worksheets
Question details
The user needs to delete worksheets in Excel 2016 when the Delete Sheet command does not work.

- Product
- Microsoft Excel 2016
- Device & OS
- Windows (version not provided)
- Scenario
- The user tries to delete a worksheet from a workbook in Excel 2016.
- Observed behavior
- The Delete Sheet command may appear available but does not delete the sheet, even though sheets can be added, moved, or renamed.
Check whether the problem occurs in a new workbook as well as the affected file, and note any error message. Install available Windows updates and, in Excel, check File > Account > Update Options > Update Now if that option is available.
Check Workbook Protection and Test Excel Add-ins
Use these checks to rule out workbook restrictions and identify an add-in that prevents sheet deletion.
Open the affected workbook and select Review > Protect Workbook. If the workbook structure is protected, unprotect it using the password if required, then right-click a sheet tab and select Delete.
Close Excel, press Windows + R, enter excel /safe, and select OK. Open the workbook and try deleting a sheet again.
If deletion works in Safe Mode, restart Excel normally and go to File > Options > Add-ins. Select COM Add-ins under Manage, choose Go, and clear one add-in at a time; restart Excel and test after each change. Repeat with Excel Add-ins under Manage if needed.
Repair the Office 2016 Installation
Repair Office if the problem continues after testing workbook protection and add-ins.
Test Excel User Settings, the Windows Profile, and the Printer
Use these checks to isolate a damaged user configuration or an environmental conflict.
Manage Worksheets with WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility. Open compatible workbooks to continue working with familiar files; WPS does not repair Excel itself.

Frequently Asked Questions
Why can I add sheets but not delete them in Excel 2016?
An add-in, damaged user setting, Office installation issue, printer driver, or other software conflict may be interfering. Test a new workbook, then start Excel with Windows + R > excel /safe to check whether add-ins are involved.
How do I check whether a workbook's structure is protected?
Open the workbook and select Review > Protect Workbook. If structure protection is enabled, remove it using the password if required before trying to delete the sheet.
Will resetting the Excel settings folder delete my files?
Renaming %appdata%\Microsoft\Excel preserves the old folder, but Excel may no longer load its startup files or settings. Check the renamed folder for templates, startup files, and personal macros before restoring anything you need.
Can a printer driver affect Excel worksheet deletion?
Printer drivers can affect Office behavior. Temporarily change the default printer in Windows Settings > Printers & scanners, restart Excel, and test whether deletion works.
Can I delete the only visible worksheet in a workbook?
No. Excel requires at least one visible worksheet. Add or unhide another sheet before deleting the one you no longer need.




