How to Delete a Worksheet in Excel (And What to Know Before You Do)

Deleting a worksheet in Excel is one of those tasks that sounds simple — and usually is — but has a few wrinkles worth knowing about before you click. Whether you're cleaning up a workbook with too many tabs or removing a sheet that's no longer needed, here's exactly how it works across different versions and platforms, plus the variables that can make the process slightly different depending on your setup.

The Basic Method: Right-Click to Delete

The most common way to delete a worksheet in Excel is through the tab context menu:

1. Locate the sheet tab at the bottom of your workbook (e.g., "Sheet2" or whatever it's named).
2. Right-click the tab.
3. Select Delete from the context menu.
4. If the sheet contains data, Excel will prompt you to confirm. Click Delete to proceed.

That confirmation prompt is important — once you delete a worksheet this way, the action cannot be undone with Ctrl+Z. Unlike most edits in Excel, sheet deletion bypasses the undo history. If the sheet is empty, Excel skips the warning and deletes immediately.

Using the Ribbon to Delete a Worksheet

If you prefer working through the Ribbon rather than right-clicking:

1. Click the sheet tab you want to delete to make it active.
2. Go to the Home tab in the Ribbon.
3. In the Cells group, click the dropdown arrow next to Delete.
4. Select Delete Sheet.

Same result, different path. The confirmation prompt behaves identically.

Deleting Multiple Sheets at Once 🗂️

You can delete several worksheets in a single action:

• Hold Ctrl and click each sheet tab you want to remove (they'll appear highlighted).
• Right-click any of the selected tabs and choose Delete.
• Confirm when prompted.

To select a range of consecutive sheets, click the first tab, hold Shift, then click the last tab in the range. All sheets between them will be selected.

One important note: you cannot delete all sheets in a workbook. Excel requires at least one visible worksheet to remain. If you try to delete the last sheet, the option will be grayed out.

How It Works on Mac vs. Windows

The core steps are the same on both platforms, but a few details differ:

The undo limitation applies on both platforms — this isn't a Windows-specific quirk.

Deleting Sheets in Excel for the Web

Excel's browser-based version (part of Microsoft 365 online) supports sheet deletion, but the interface can vary slightly depending on your browser and screen size. Right-clicking a tab still works in most cases. Some features available in the desktop app — like selecting multiple sheets with Ctrl+click — may behave differently or not work in the web version depending on how your browser handles right-click menus and keyboard shortcuts.

Deleting Sheets in Excel on Mobile (iOS and Android)

On mobile, sheet management is more limited. To delete a sheet:

1. Tap the sheet tab at the bottom of the screen.
2. Tap the three-dot menu (⋮) or long-press the tab depending on your app version.
3. Select Delete Sheet from the options.

The mobile apps have progressively improved, but if you're managing a complex workbook with many sheets, the desktop version gives you significantly more control.

Protected Workbooks and Locked Sheets ⚠️

If the Delete option appears grayed out or is missing entirely, the most likely reason is protection:

• Sheet protection restricts edits to individual sheets but doesn't usually prevent deletion from the workbook level.
• Workbook structure protection is what actually locks the sheet tabs — preventing sheets from being added, moved, renamed, or deleted.

To remove workbook structure protection: go to Review > Protect Workbook, enter the password if one is set, and toggle the protection off. After that, deletion works normally.

What Happens to Data and Formulas When You Delete a Sheet

This is where things get meaningful for anyone working in a multi-sheet workbook. When you delete a sheet:

• All data on that sheet is permanently removed — there's no recycle bin or recovery path through Excel itself.
• Formulas in other sheets that reference the deleted sheet will return a #REF! error. Excel doesn't automatically redirect or warn you about broken cross-sheet references before deletion.
• Named ranges tied to the deleted sheet may also break or disappear.

Before deleting any sheet that's been in a workbook for a while, it's worth using Ctrl+F (Find) or checking the Name Manager (Formulas > Name Manager) to see if anything else in the workbook is pulling data from it.

The Variable That Changes Everything

The mechanical steps here are consistent across Excel versions — right-click, delete, confirm. But how straightforward or risky that action is depends entirely on your workbook's complexity. A solo Sheet2 with placeholder data is a two-second job. A sheet buried in a multi-tab financial model with cross-references, named ranges, and shared formulas is a different situation entirely.

How interconnected your sheets are, whether workbook protection is enabled, and which platform you're on all shape what "deleting a worksheet" actually involves for your specific file.