How to Delete Sheet in Excel on Mac

To delete a sheet in Excel on a Mac, Control-click (or right-click) the sheet’s tab at the bottom of the window and choose Delete. If the sheet contains data, Excel asks you to confirm; select Delete again. You can also select the sheet and choose Edit > Delete Sheet from the menu bar.

Applies to: Excel for Microsoft 365 for Mac, Excel 2024 and Excel 2021 for Mac. Checked against Microsoft Support on October 9, 2026.

Deleting a sheet can’t be undone with Command + Z, so check you’ve picked the right tab before you confirm.

Delete a sheet from its tab

1. Open the workbook.
2. Find the sheet tab you want to remove at the bottom of the window. Use the arrows at the bottom left to scroll if you have many sheets.
3. Control-click the tab, or right-click with a mouse or two-finger click on a trackpad.
4. Choose Delete.
5. If the sheet has data, select Delete in the confirmation message.

Delete a sheet from the menu or ribbon

• Menu bar: click the sheet tab, then choose Edit > Delete Sheet.
• Ribbon: click the sheet tab, go to the Home tab, select the arrow next to Delete, and choose Delete Sheet.

There’s no built-in keyboard shortcut, but you can add Delete Sheet to the Quick Access Toolbar. See how to customize the ribbon in Excel on a Mac.

Delete several sheets at once

1. Click the first sheet tab.
2. Hold Command and click each other tab you want to remove. To select a run of sheets next to each other, hold Shift and click the last tab instead.
3. Control-click any selected tab and choose Delete.

While several sheets are selected, Excel groups them and shows [Group] in the title bar. Anything you type goes into every grouped sheet, so click a single tab to ungroup when you’re done.

Delete a hidden sheet

Hidden sheets don’t show a tab. Control-click any tab, choose Unhide, select the sheet, and select OK. Then delete it as usual.

Before you delete: check for linked formulas

Formulas on other sheets that refer to the deleted sheet change to #REF! errors. To find them first, press Command + F, select Options (or the search options menu), set Look in to Formulas, and search for the sheet’s name. Charts, PivotTables and named ranges that use the sheet’s data are affected too.

If you only want the sheet out of the way, consider hiding it instead: Control-click the tab and choose Hide. Its data and formulas keep working.

Get a deleted sheet back

• You haven’t saved yet: close the workbook and choose Don’t Save, then reopen it. The sheet is still there in the saved version. Turn off AutoSave first if it’s on, because it saves changes automatically.
• The file is on OneDrive or SharePoint: choose File > Browse Version History and open an earlier version. Copy the sheet from it back into your current workbook.
• You use Time Machine: restore an earlier copy of the file from your backup.

If you can’t delete a sheet

• Delete is greyed out: the workbook structure is protected. Go to Review > Protect Workbook and enter the password to unprotect it. Protecting a single sheet doesn’t stop you deleting it; protecting the workbook structure does.
• It’s the only sheet: a workbook must have at least one visible sheet. Add a new sheet with the + button first, then delete the old one.
• The workbook is shared or read-only: save a copy with File > Save As, or ask the owner for edit access.
• The file is open in Protected View: select Enable Editing at the top of the window.

Frequently asked questions

Can I undo deleting a sheet?

No. Command + Z doesn’t bring back a deleted sheet. Use the recovery options above.

Will deleting a sheet affect other sheets?

Other sheets stay the same, but formulas that pointed to the deleted sheet show #REF! errors.

How do I rename or recolor a sheet instead?

Double-click the tab to rename it, or Control-click it and choose Tab Color. See how to change worksheet tab color in Excel on Mac.

Is deleting a sheet the same in Excel for Windows?

Yes, you right-click the tab and choose Delete. Windows also has the Home > Delete > Delete Sheet option. For other Mac tips, see how to make an absolute reference in Excel on Mac.

Matt Jacobs

Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.

His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.