Right-click the sheet tab and select Delete

The fastest way to remove a sheet from your Excel file is to right-click on the sheet tab at the bottom of the window and choose Delete Sheet from the menu that appears. The sheet tab is the small labeled area where you see the name of your current sheet — usually "Sheet1" or something you renamed it to. One click removes the entire sheet and all the data in it.

Excel will ask you to confirm the deletion before it happens. If you change your mind, click Cancel and the sheet stays. If you click Delete, the sheet is gone permanently — you cannot undo this action after you close the file, so make sure you want to remove it before you confirm.

If you have only one sheet left in your file, Excel will not let you delete it. You need at least one sheet in every workbook. If you want to clear out all the data but keep the sheet, select all the cells instead and press Delete to empty them.

Key Takeaways

  • Right-click the sheet tab at the bottom of the window and select Delete Sheet to remove an entire sheet from your file.
  • Excel asks you to confirm before deleting — use this moment to make sure you are removing the right sheet.
  • Deletion is permanent once you close the file, so check that you do not need the data before you confirm.
  • You can always undo a deletion with Ctrl+Z (or Command+Z on Mac) as long as you have not closed the file yet.
  • If you want to keep the sheet but remove the data inside it, select all cells and press Delete instead of deleting the sheet itself.

How to undo a deletion if you change your mind

If you delete a sheet and when ready realize you made a mistake, press Ctrl+Z on Windows or Command+Z on Mac. This undoes the deletion and brings the sheet back with all its data intact. The undo command works as long as you have not closed the file yet.

Once you close the file without saving, the deletion is permanent. If you have already saved the file after deleting the sheet, undo will not work — the deletion is now part of the saved version. For this reason, it is worth taking a moment to confirm you are deleting the right sheet before you click Delete.

How to hide a sheet instead of deleting it

If you are not sure whether you need a sheet later, hiding it is safer than deleting it. Right-click the sheet tab and select Hide instead of Delete. The sheet disappears from view but stays in your file with all its data preserved.

To bring a hidden sheet back, right-click any visible sheet tab and select Unhide. A dialog box shows all your hidden sheets. Click the one you want to see again and click OK. This is useful when you have sheets you reference occasionally but do not need to see every day.

What happens to formulas that reference a deleted sheet

If another sheet in your file contains a formula that pulls data from the sheet you are deleting, that formula will break. The cell will show #REF! error, which means the formula is trying to reference data that no longer exists.

Before you delete a sheet, check whether any other sheets depend on it. Look for formulas that start with the sheet name followed by an exclamation point — for example, =Sheet2!A1 means that cell is pulling data from Sheet2. If you see these formulas, either update them to reference a different sheet or move the data you need before you delete. Hiding the sheet instead of deleting it is another option if you want to keep the formulas working.

How to delete multiple sheets at once

If you need to remove several sheets, you can select them together and delete them all at once. Click the first sheet tab you want to delete, then hold Ctrl (or Command on Mac) and click each additional sheet tab. All the selected tabs will highlight.

Right-click any of the highlighted tabs and select Delete Sheet. Excel will ask you to confirm that you want to delete all the selected sheets. Click Delete and they all disappear at once. This is faster than deleting them one by one, but make sure you have selected only the sheets you actually want to remove.

How to move a sheet to a different file instead of deleting it

If you want to remove a sheet from your current file but keep the data somewhere, you can move it to a different Excel file instead of deleting it. Right-click the sheet tab and select Move or Copy. A dialog box opens where you can choose which file to move it to and where in that file it should go.

Select the destination file from the list, choose the position where you want the sheet to appear, and click OK. The sheet moves to the other file and disappears from your current one. If you want to copy the sheet instead of moving it — so it exists in both files — check the box that says Create a copy before you click OK.

Frequently Asked Questions

Can I delete a sheet if it has data I might need later?

You can, but hiding the sheet is safer. Right-click the tab and select Hide instead of Delete. The sheet stays in your file with all its data, but you do not see it in the normal view. You can unhide it anytime by right-clicking a visible sheet and selecting Unhide.

What if I deleted a sheet and already saved the file?

Once you save the file after deleting a sheet, the deletion is permanent. Undo only works before you save. If you need the data back, check whether you have an older version of the file saved elsewhere, or ask whether someone else has a copy.

Why does Excel not let me delete my last sheet?

Every Excel file must have at least one sheet. If you want to clear out all the data but keep the sheet, select all cells with Ctrl+A and press Delete to empty them. The sheet stays but becomes blank.

Will deleting a sheet affect other sheets in the same file?

Only if those sheets contain formulas that reference the deleted sheet. Those formulas will show a #REF! error. Check for these formulas before you delete, and either update them or move the data they need to a sheet you are keeping.

How do I know which sheet is safe to delete?

Look at the sheet names and the data inside each one. If a sheet contains data you do not recognize or have not used in a long time, check with anyone else who uses the file before you delete it. When in doubt, hide the sheet instead — you can always unhide it later.