Right-click the sheet tab and select Delete

To remove a sheet from your Excel workbook, right-click on the sheet tab at the bottom of the window. A menu will appear with several options. Click Delete from that menu.

Excel will ask you to confirm the deletion. If the sheet contains data, you will see a warning that says the sheet will be permanently removed. Click Delete again to confirm, or click Cancel if you change your mind.

The sheet disappears when ready. If you delete a sheet by accident, you can undo the action by pressing Ctrl+Z (or Cmd+Z on a Mac) right away. The undo command works only if you catch the mistake before you close the file or perform other actions.

Key Takeaways

  • Right-click the sheet tab at the bottom of the Excel window and select Delete from the menu to remove a sheet.
  • Excel asks for confirmation before deleting a sheet that contains data, giving you a chance to cancel if you change your mind.
  • You can undo a deletion when ready by pressing Ctrl+Z, but this only works before you close the file or perform other actions.
  • If you need to keep the data but remove the sheet from view, you can hide the sheet instead of deleting it by right-clicking and selecting Hide.
  • Moving a sheet to a different workbook before deleting it is a safer way to preserve the data if you think you might need it later.

What happens when you delete a sheet

Deleting a sheet removes it from the workbook entirely. All the data in that sheet — formulas, values, formatting, charts, everything — is gone. Excel does not move the sheet to a trash folder or keep a backup copy inside the file.

If other sheets in the same workbook contain formulas that reference the deleted sheet, those formulas will break and display an error. For example, if Sheet2 has a formula that says =Sheet1!A1 and you delete Sheet1, that formula will show #REF! instead of a value.

Before you delete a sheet, take a moment to check whether any other sheets depend on it. You can search for sheet references by using the Find & Replace feature (Ctrl+H) and searching for the sheet name followed by an exclamation mark.

Hiding a sheet instead of deleting it

If you want to remove a sheet from view without losing the data, you can hide it instead. Right-click the sheet tab and select Hide. The sheet disappears from the tab bar but remains in the workbook and keeps all its data intact.

Hidden sheets still work in formulas. If Sheet1 is hidden and Sheet2 contains the formula =Sheet1!A1, that formula continues to work and display the correct value. You can unhide the sheet later by right-clicking any visible sheet tab, selecting Unhide, and choosing the sheet you want to restore.

Hiding is useful when you have sheets that contain reference data, calculations, or notes that you do not want to clutter the main view but might need to reference or edit later.

Moving a sheet to another workbook before deleting

If you want to preserve a sheet's data but remove it from the current workbook, you can move it to a different file. Right-click the sheet tab and select Move or Copy. A dialog box opens where you can choose which workbook to move it to and where in that workbook it should go.

Select the destination workbook from the list. If the workbook you want is not open, you will need to open it first before you can move the sheet to it. Then choose the position where the sheet should appear in the new workbook and click OK.

Once the sheet is safely in the new workbook, you can delete it from the original file without worry. This approach takes a few extra steps but gives you a backup copy of the data in a separate location.

Deleting multiple sheets at once

You can select and delete more than one sheet in a single action. Click on one sheet tab, then hold Ctrl (or Cmd on a Mac) and click on the other sheet tabs you want to delete. All selected tabs will highlight.

Right-click any of the selected tabs and choose Delete. Excel will confirm that you want to delete all the selected sheets. Click Delete to remove them all at once, or Cancel to keep them.

Be careful when selecting multiple sheets, because the confirmation dialog does not list each sheet by name — it straightforward says you are about to delete multiple sheets. If you are unsure, delete them one at a time instead.

Recovering a deleted sheet from a backup

If you delete a sheet and do not realize it until after you have closed the file, the undo command will not work. Your best option is to check whether you have a backup copy of the file.

If you use OneDrive, Google Drive, or another cloud storage service, you may be able to restore an earlier version of the file. Right-click the file in your cloud storage and look for an option like Version history or Restore previous versions. The exact steps depend on which service you use.

If you have a local backup on your computer or an external drive, you can open that backup file and copy the sheet from it. Open both the backup and the current workbook, then right-click the sheet in the backup file and select Move or Copy. Choose to copy it to the current workbook instead of moving it.

Frequently Asked Questions

Can I delete a sheet if it is the only sheet in the workbook?

No. Excel requires every workbook to have at least one sheet. If you try to delete the only sheet, Excel will show an error message and prevent the deletion. You must create a new sheet first before you can delete the last one.

What if I delete a sheet by accident and close the file without undoing?

Once you close the file without undoing, the sheet is permanently deleted from that file. Check your cloud storage or local backups for an earlier version of the file. If you have no backup, the data cannot be recovered from Excel alone.

Does deleting a sheet affect other files that link to it?

If another workbook contains a formula that links to the deleted sheet, that formula will break and show a #REF! error. You will need to update those formulas to reference a different sheet or remove the links entirely.

Can I delete a sheet that is protected or locked?

If a sheet is protected, 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 one is required. Then you can delete it normally.