Office Settings & Configuration

Fix Excel 2016 When You Cannot Delete Worksheets

Phi Hung VoPhi Hung Vo Nov 20, 2026 868 views

Question details

The user needs to delete worksheets in Excel 2016 when the Delete Sheet command does not work.

How to Fix Excel 2016 When You Cannot Delete Worksheets
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.
Before you start

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.

Solution 1Recommended

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.

1
Check the workbook

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.

2
Start Excel in Safe Mode

Close Excel, press Windows + R, enter excel /safe, and select OK. Open the workbook and try deleting a sheet again.

3
Disable add-ins individually

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.

Keep at least one worksheet: Excel requires a workbook to contain at least one visible worksheet, so it will not let you delete the last one.
Free Microsoft Office alternative

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.

Add, rename, and delete worksheets from sheet tabsOpen and save compatible Excel XLS and XLSX filesUse a familiar interface for an easier move from ExcelWork with a free, lightweight office suite
microsoft office alternative - wps office

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.