The simplest way to remove a page from your spreadsheet

In Excel, a "page" is actually a worksheet — a separate tab at the bottom of your file that holds its own grid of cells. To delete one, right-click the tab name at the bottom of the screen and select "Delete Sheet" from the menu. Excel will ask you to confirm, and the worksheet disappears along with all the data in it. This is permanent and cannot be undone after you close the file, so make sure you want to remove it before you confirm.

If you have only one worksheet left in your file, Excel will not let you delete it — every spreadsheet must contain at least one sheet. If you need to clear the data but keep the sheet, select all the cells instead and press Delete to empty them without removing the tab.

Key Takeaways

  • Right-click the worksheet tab at the bottom of the screen and choose "Delete Sheet" to remove an entire page from your spreadsheet.
  • Deleting a worksheet is permanent once you close the file, so confirm you no longer need the data before you proceed.
  • Excel requires at least one worksheet in every file, so you cannot delete your last remaining sheet.
  • If you want to keep the sheet but remove only the data, select all cells and press Delete instead of deleting the entire worksheet.

Finding the worksheet tabs at the bottom of your screen

The tabs appear in a row at the very bottom left of your Excel window. By default, they are labeled "Sheet1", "Sheet2", and so on, though you can rename them to anything you want. If you have many worksheets, you may see navigation arrows on the far left that let you scroll through the tab list — click these arrows to find the tab you want to delete.

The active worksheet (the one you are currently viewing) appears highlighted or in a different color. Inactive tabs look dimmed or plain. You can click any tab to switch to that worksheet without deleting it. Only right-click when you have found the exact tab you want to remove.

What happens when you delete a worksheet

When you confirm the deletion, Excel removes the entire worksheet and all data stored in it. The remaining worksheets shift left to fill the gap — if you delete "Sheet2" from a file with three sheets, "Sheet3" becomes the new second tab. The active view moves to whichever sheet is now in that position.

This action cannot be reversed by pressing Ctrl+Z (Undo) once you close and reopen the file. If you close the file without saving, the deletion will not be saved and the worksheet will still be there when you reopen it. If you save the file after deleting, the worksheet is gone for good.

Deleting multiple worksheets at once

To remove more than one worksheet in a single action, hold Ctrl and click each tab you want to delete. They will all highlight. Then right-click any of the selected tabs and choose "Delete Sheet". Excel will ask you to confirm once, and all selected worksheets will be removed together.

This is faster than deleting one at a time, but be extra careful to select only the sheets you want gone. Double-check your selection before you confirm, because you cannot undo this after saving.

When you cannot delete a worksheet

If the "Delete Sheet" option is grayed out or does not appear, your file is protected. Some spreadsheets have sheet protection enabled to prevent accidental changes. Ask whoever set up the file for the password to unprotect it, or contact your IT department if this is a work file.

You also cannot delete a worksheet if it is the only one remaining in the file. Excel requires every spreadsheet to have at least one sheet. If you see this message, you must either create a new worksheet first or accept that you cannot remove this one.

Clearing data without deleting the worksheet

If you want to empty a worksheet but keep the tab itself, select all cells by clicking the box in the top left corner where the row numbers and column letters meet. Then press the Delete key. This removes all the data, formatting, and comments from the sheet while leaving the worksheet tab in place.

This approach is useful when you want to reuse a sheet for new data or when other worksheets contain formulas that reference this one. Deleting the entire worksheet would break those formulas, but clearing the data keeps the sheet structure intact.

Frequently Asked Questions

Can I undo a deleted worksheet?

You can undo a deletion when ready by pressing Ctrl+Z, but only before you close the file. Once you save and close the spreadsheet, the deletion is permanent. If you realize too late that you deleted the wrong sheet, check your computer's file recovery options or contact your IT support to see if a backup exists.

What if I delete a sheet that other sheets reference?

If another worksheet contains a formula that points to the deleted sheet, that formula will show an error like #REF!. You will need to fix those formulas manually by editing them to reference a different sheet or removing the formula entirely. This is why it is important to check what data depends on a sheet before you delete it.

Does deleting a worksheet reduce the file size?

Yes, removing a worksheet with large amounts of data will make your file smaller. However, if you only clear the data without deleting the sheet itself, the file size may not change much because the empty cells still take up some space in the file structure.

Can I recover a deleted worksheet from an older version of the file?

If your computer or cloud storage service keeps version history, you may be able to restore an earlier version of the file that still contains the deleted worksheet. Check your file properties or your cloud storage settings to see if previous versions are available.