Right-click the sheet tab and select Delete

The fastest way to delete a sheet in Excel is to right-click on the sheet tab at the bottom of your window and choose Delete from the menu that appears. The sheet tab is the labeled area showing the sheet name — usually "Sheet1", "Sheet2", or whatever you named it. When you right-click, a small menu pops up with a few options, and Delete is typically near the top.

Excel will ask you to confirm the deletion before it removes the sheet permanently. A dialog box appears saying something like "Do you want to delete the sheet?" with options to proceed or cancel. If you click to confirm, the sheet and all its contents are gone. This is permanent — Excel does not move deleted sheets to a trash folder you can recover from later.

One important note: you cannot delete a sheet if it is the only sheet left in the workbook. Excel requires every workbook to have at least one sheet. If you try to delete your last remaining sheet, Excel will show an error message and block the action.

Key Takeaways

  • Right-click the sheet tab at the bottom of the window and select Delete to remove a sheet in one step.
  • Excel asks you to confirm the deletion before it happens, but once confirmed, the sheet cannot be recovered.
  • You cannot delete the last sheet in a workbook — Excel requires at least one sheet to exist at all times.
  • If you delete a sheet by accident, use Ctrl+Z (or Cmd+Z on Mac) immediately to undo the action before you close the file.
  • Moving a sheet to a different workbook is a safer option than deleting if you might need the data later.

Using the Edit menu instead of right-clicking

If right-clicking does not work on your device or you prefer using menus, you can delete a sheet through the Edit menu at the top of Excel. First, click on the sheet tab you want to delete so it is the active sheet. Then click the Edit menu, look for an option like Delete Sheet, and click it. The exact wording varies slightly depending on your version of Excel, but the option is always in the Edit menu.

This method takes a few more clicks than right-clicking, but it works the same way — Excel confirms your choice and then removes the sheet. The confirmation step is the same: you will see a dialog asking if you really want to delete, and you have to click yes to proceed.

Undo a deletion immediately if you change your mind

If you delete a sheet by accident, you can undo it right away by pressing Ctrl+Z on Windows or Cmd+Z on Mac. This works only if you undo before you close the file. Once you close and reopen the workbook, the deleted sheet is gone for good — undo only works within the current session.

The undo button also appears in the top left corner of Excel, usually showing an arrow pointing backward. Click it to reverse your last action. If you have made other changes since the deletion, pressing undo multiple times will step backward through each change in reverse order until you reach the deletion.

Move a sheet to another workbook instead of deleting

If you are not sure whether you need the sheet later, moving it to a different workbook is safer than deleting. Right-click the sheet tab and select Move or Copy instead of Delete. A dialog box opens asking where you want to move the sheet — you can choose an existing workbook or create a new one. This keeps the data intact in case you need it later, and you can always delete the separate workbook if it turns out you do not need it.

To move a sheet, you need to have the destination workbook open in Excel, or you can create a new workbook as part of the move process. The sheet will be removed from your current workbook and placed in the workbook you choose. If you select Copy instead of Move, the sheet stays in both places — the original and the new location.

Delete multiple sheets at once

You can select and delete more than one sheet in a single action. Click on the first sheet tab you want to delete, then hold Ctrl (or Cmd on Mac) and click on the other sheet tabs you want to remove. All selected tabs will highlight. Then right-click any of the selected tabs and choose Delete, or use the Edit menu. Excel will delete all selected sheets at once after you confirm.

Be careful when selecting multiple sheets — it is easy to accidentally select a sheet you meant to keep. Double-check that all highlighted tabs are ones you actually want to remove before you confirm the deletion. The confirmation dialog will tell you how many sheets you are about to delete, which helps you catch mistakes before they happen.

What happens to formulas that reference a deleted sheet

If other sheets in your workbook contain formulas that reference a deleted sheet, those formulas will break. For example, if Sheet2 has a formula like =Sheet1!A1 (which pulls data from cell A1 in Sheet1), and you delete Sheet1, that formula will show an error like #REF!. The formula cannot find the sheet it is looking for anymore.

Before you delete a sheet, check whether any other sheets use formulas that pull data from it. You can search for sheet references by using the Find function (Ctrl+F or Cmd+F) and searching for the sheet name followed by an exclamation mark, like "SheetName!". If you find references, you have two choices: update those formulas to reference a different sheet, or move the sheet to another workbook instead of deleting it.

Frequently Asked Questions

Can I recover a sheet after I delete it?

Only if you undo the deletion immediately using Ctrl+Z (or Cmd+Z on Mac) before you close the file. Once you close and reopen the workbook, the deleted sheet is permanently gone. Excel does not have a trash or recovery folder for deleted sheets.

What if I only have one sheet left and I try to delete it?

Excel will not let you delete the last sheet in a workbook. You will see an error message saying you cannot delete the only sheet. Create a new blank sheet first if you want to remove the current one, then delete the original sheet.

Do I need to save the file after deleting a sheet?

The deletion happens immediately when you confirm it, but saving the file makes the change permanent. If you close the file without saving after a deletion, Excel may ask whether you want to save changes. Click yes to keep the deletion, or no to close without saving (which will not undo the deletion if you already confirmed it).

Will deleting a sheet affect other workbooks?

No. Deleting a sheet only affects the workbook you are currently working in. Other Excel files are not changed. However, if another workbook has a formula that links to the sheet you deleted, that formula will break and show an error.

Can I delete a sheet that is protected or locked?

If a sheet is password-protected, you may not be able to delete it depending on how the protection was set up. Try right-clicking and selecting Delete — if the option is grayed out or disabled, the sheet protection is preventing deletion. You would need to unprotect the sheet first, which usually requires the password that was used to protect it.