How to Delete a Sheet in Excel on Mac

Deleting a worksheet in Excel on Mac is straightforward once you know where to look — but the exact steps, keyboard shortcuts, and safeguards involved can vary depending on your Excel version, your Mac's OS, and how your workbook is structured. Here's everything you need to know.

The Basic Method: Right-Click the Sheet Tab

The fastest way to delete a sheet in Excel on Mac is through the sheet tab context menu:

Locate the sheet tabs at the bottom of your Excel workbook
Right-click (or Control+click) on the tab of the sheet you want to delete
Select "Delete" from the context menu
If the sheet contains data, Excel will display a confirmation dialog — click "Delete" to confirm

That's the core workflow. No menu bar navigation required.

Using the Ribbon and Menu Bar

If you prefer working through the menu bar or Ribbon:

Via the Home tab (Ribbon):

Click on the sheet tab you want to delete to make it active
Go to the Home tab in the Ribbon
In the Cells group, click the dropdown arrow next to "Delete"
Select "Delete Sheet"

Via the Menu Bar:

Select the sheet tab
Click Edit in the top menu bar
Look for "Sheet" and then choose "Delete Sheet"

Note that the menu bar path can differ slightly depending on your Excel version (Microsoft 365, Excel 2021, Excel 2019, or older). Older versions of Excel for Mac organized menus differently, so if one path doesn't match what you see, the right-click method is the most consistent fallback across versions.

Deleting Multiple Sheets at Once

You can delete several sheets in a single action:

Select multiple adjacent sheets: Click the first tab, then Shift+click the last tab in the range
Select non-adjacent sheets: Click the first tab, then Cmd+click each additional tab you want to include
Once selected, right-click any highlighted tab and choose "Delete"

Excel will ask you to confirm before deleting all selected sheets. When multiple tabs are selected, a grouped workbook warning may also appear — this is normal behavior indicating edits will apply to all selected sheets.

What Happens When You Can't Delete a Sheet 🔒

Sometimes the Delete option appears grayed out or is missing entirely. This usually means one of the following:

Situation	Why You Can't Delete	What to Do
Only one sheet in workbook	Excel requires at least one visible sheet	Add another sheet first, then delete
Sheet is protected	Worksheet protection is enabled	Unprotect via Review → Unprotect Sheet
Workbook structure is protected	Structure protection prevents sheet changes	Unprotect via Review → Protect Workbook
Shared workbook (legacy mode)	Some editing features are restricted	Check Share Workbook settings
File is read-only	No write access to the file	Save a local copy or check file permissions

The most common blocker for Mac users is workbook structure protection, which is easy to overlook. It's separate from sheet-level protection and specifically locks the ability to add, delete, rename, or move sheets.

Keyboard Shortcuts: What Works on Mac

Unlike Windows, Excel on Mac does not have a single dedicated keyboard shortcut to delete a sheet. The Windows shortcut (Alt+H+D+S) doesn't translate directly to macOS.

However, you can speed up the process:

Fn+Control+click on the tab (if your trackpad or mouse is configured for right-click behavior)
Once the context menu is open, pressing D typically jumps to the Delete option in some versions
You can also create a custom keyboard shortcut via System Settings → Keyboard → Keyboard Shortcuts → App Shortcuts, targeting the "Delete Sheet" menu command in Microsoft Excel

Custom shortcuts behave differently depending on your macOS version (Ventura, Sonoma, Sequoia, etc.) and whether Excel recognizes the command name exactly as entered.

Hiding vs. Deleting: A Key Distinction

Before deleting, it's worth asking whether you actually want to hide the sheet instead. Hiding keeps the data intact and accessible but removes the tab from view.

Hide: Right-click the tab → Hide
Unhide: Right-click any tab → Unhide → select the sheet

This matters when the sheet contains reference data, lookup tables, or formulas that other sheets depend on. Deleting a sheet that other cells reference will break those formulas and generate #REF! errors throughout your workbook — Excel won't always warn you before this happens.

Version Differences Worth Knowing

Your experience will vary based on which Excel build you're running:

Microsoft 365 (subscription): Most current UI, auto-save enabled by default — but auto-save doesn't protect against sheet deletion since deletion isn't undoable
Excel 2021/2019 (standalone): Slightly different Ribbon layout but same core functionality
Excel for Mac (older, pre-2016): Different menu structure; some Ribbon groups are reorganized

The auto-save behavior in Microsoft 365 is a variable that catches some users off guard. If auto-save is on and you delete a sheet, the deletion syncs to OneDrive quickly — restoring from version history is possible but requires knowing how to navigate File → Version History, which not all users are familiar with. 📁

Whether you're cleaning up a workbook, reorganizing data, or removing a draft sheet, the method that works best depends on how your Excel is configured, whether any protection settings are active, and what relationship the sheet has to the rest of your data.