Right-click the sheet tab at the bottom and select Delete

To remove a sheet from your Excel workbook on Mac, locate the sheet tabs at the bottom of the window. Each tab shows the name of one sheet — usually "Sheet1", "Sheet2", or a custom name you gave it. Right-click directly on the tab of the sheet you want to remove.

A menu will appear with several options. Click Delete from that menu. Excel will ask you to confirm the deletion because this action cannot be undone. Click Delete again in the confirmation box, and the sheet disappears from your workbook along with all the data it contained.

If you have only one sheet left in your workbook, Excel will not let you delete it — a workbook must contain at least one sheet. If you try, you will see a message saying the sheet cannot be deleted.

Key Takeaways

  • Sheet tabs appear at the bottom of the Excel window, and right-clicking any tab opens a menu with the Delete option.
  • Deleting a sheet removes all data on that sheet permanently and cannot be reversed, so confirm you want to remove it before clicking Delete a second time.
  • You cannot delete the last remaining sheet in a workbook — Excel requires at least one sheet to exist.
  • If you change your mind when ready after deleting, use Command+Z to undo the deletion before you perform any other action.

Using Undo if you delete the wrong sheet

If you realize you deleted the wrong sheet, press Command+Z when ready to undo the deletion. This restores the sheet and all its data exactly as it was. Undo works only if you have not performed any other action since the deletion — once you make another change to the workbook, the undo chain breaks and you cannot recover the deleted sheet.

For this reason, if you are deleting multiple sheets, delete them one at a time and pause to confirm each deletion was correct before moving to the next one. This gives you the chance to undo if you make a mistake.

Hiding a sheet instead of deleting it

If you want to remove a sheet from view temporarily but keep its data, you can hide it instead of deleting it. Right-click the sheet tab and select Hide from the menu. The sheet tab disappears from the bottom of the window, but the sheet and all its data remain in the workbook.

To show a hidden sheet again, right-click any visible sheet tab and select Unhide. A dialog box will list all hidden sheets in the workbook. Click the name of the sheet you want to restore and click OK. The sheet tab reappears at the bottom of the window.

Hiding is useful when you have reference sheets or backup data you do not need to see every day but want to keep in the file. Deleting is the right choice only when you are certain you will never need that data again.

What happens to formulas that reference a deleted sheet

If other sheets in your workbook contain formulas that pull data from the sheet you are deleting, those formulas will break. The cells containing those formulas will show #REF! error, which means the formula is trying to reference data that no longer exists.

Before you delete a sheet, search your workbook for any formulas that reference it. You can do this by using the Find feature (Command+F) and searching for the sheet name followed by an exclamation point — for example, "Sheet1!" — to locate any references. If you find references, either update those formulas to point to a different sheet or copy the data from the sheet you want to delete to another sheet before removing it.

Deleting multiple sheets at once

If you need to remove several sheets, you can select them all at once and delete them together. Click the tab of the first sheet you want to delete, then hold Shift and click the tab of the last sheet in the range you want to remove. All tabs between them will highlight, showing they are selected.

Alternatively, hold Command and click individual sheet tabs one at a time to select non-consecutive sheets. Once you have selected all the sheets you want to remove, right-click any of the highlighted tabs and click Delete. Excel will delete all selected sheets at once. Confirm the deletion when prompted.

Be very careful when deleting multiple sheets, because you will lose all data on every selected sheet. If you are unsure, delete them one at a time instead so you can verify each deletion before moving to the next.

Renaming a sheet instead of deleting it

Sometimes you want to remove a sheet because its name no longer makes sense or it contains outdated information. Before you delete it, consider renaming it instead. Right-click the sheet tab and select Rename. The sheet name becomes editable — type a new name and press Enter.

Renaming lets you keep the data while making it clear that the sheet is no longer in active use. For example, you might rename an old budget sheet to "2023 Budget - Archive" so you know not to edit it but can still reference it if needed. This approach is safer than deletion because you preserve the data in case you need it later.

Frequently Asked Questions

Can I delete a sheet if it has data in it?

Yes. Excel does not prevent you from deleting a sheet that contains data — it only prevents you from deleting the last sheet in a workbook. When you delete a sheet with data, all that data is removed permanently. Confirm you no longer need the data before you complete the deletion.

What if I cannot find the sheet tabs at the bottom of my window?

Sheet tabs should appear at the bottom left of the Excel window, just above the status bar. If you do not see them, the sheet tab area may be hidden or very narrow. Try clicking and dragging the divider between the sheet tabs and the horizontal scroll bar to the right to expand the tab area. If tabs still do not appear, check the View menu to see if there is an option to show sheet tabs.

Does deleting a sheet delete the file?

No. Deleting a sheet removes only that one sheet from the workbook file. The file itself remains open and saved on your Mac. You are only removing one part of the spreadsheet, not the entire document.

Can I delete a sheet that is protected?

If a sheet is protected with a password, you may not be able to delete it. You will need to unprotect the sheet first. Right-click the sheet tab, select Unprotect Sheet, and enter the password if prompted. Once unprotected, you can delete it using the normal method.