How to Delete a Page in Excel: Sheet or Printed Page

How-to basics · Updated November 20, 2026

To delete a worksheet in Excel, right-click its sheet tab and choose Delete, then confirm if prompted. If by “page” you mean a page that appears in print preview, Excel does not store printed pages as separate objects: adjust the print area, page breaks, or layout instead. Check which kind of page you want to remove before making changes, because deleting a worksheet removes its contents.

What You’ll Need

  • The Excel workbook you want to edit. If it contains important information, make a copy first or save a separate backup.
  • Permission to edit the workbook. A protected workbook or read-only file may prevent changes.
  • For a printed-page issue, access to the worksheet’s Page Layout settings and Print Preview.

Step-by-Step

  1. Decide whether you mean a worksheet or a printed page. Look at the bottom of the Excel window. Tabs such as Sheet1 or January are worksheets, and each can contain many rows and columns. A printed page is one part of the worksheet as it will appear on paper or in a PDF. If you want to remove all the data on one tab, follow the worksheet steps below. If you only want to stop a section from printing on its own page, use the print-page steps instead.
  2. Save a backup if the worksheet may be needed later. Choose File > Save As and save a copy with a different name, or duplicate the sheet before deleting it. To duplicate a sheet in desktop Excel, right-click its tab, choose Move or Copy, select Create a copy, and click OK. A backup is especially useful when formulas on other sheets refer to the sheet you plan to remove.
  3. Select the worksheet tab you want to delete. Click its tab once so it is the active sheet. Check the tab name carefully; if several tabs are visible, scroll the tab bar or use the sheet navigation arrows at the lower-left to locate the right one. Do not select cells and assume that deleting them will remove the worksheet. Cell deletion and sheet deletion are different actions.
  4. Delete the worksheet. In Excel for Microsoft 365 on Windows, right-click the selected sheet tab and choose Delete. You can also use the ribbon: choose Home > Cells > Delete > Delete Sheet. Excel may show a warning that the sheet contains data. Read it, then choose Delete to confirm or Cancel to keep the sheet. Once removed, the tab and its cell contents are deleted from the workbook.
  5. Check the workbook after deletion. Look at the remaining tabs and inspect formulas, charts, and summaries that may have used the deleted sheet. A formula referring to a deleted sheet can show #REF!, which means Excel can no longer find the referenced cell or range. If the deletion was a mistake and you have not closed the workbook or made changes that prevent undo, use Ctrl+Z on Windows. On Mac, use Command+Z. Undo availability can change after other actions, so do not rely on it as your only backup.
  6. If you mean an unwanted printed page, open Print Preview. Choose File > Print on Windows, or use the print command in Excel for Mac or Excel for the web. Review the preview and note which content is appearing on the page you want to remove. A blank page often comes from a print area that extends too far, a manual page break, formatting in distant cells, or a layout that makes the content spill onto another page.
  7. Adjust what Excel prints. If the extra page contains cells you do not need in the printout, select the range you do want to print and choose Page Layout > Print Area > Set Print Area. To remove a print area that is already set, choose Page Layout > Print Area > Clear Print Area, then set a smaller area if needed. This changes printing only; it does not erase cells from the worksheet. Check Print Preview again to confirm the output.
  8. Review page breaks and scaling. To reset manual page breaks on the active worksheet in desktop Excel, choose Page Layout > Breaks > Reset All Page Breaks. This resets manual breaks; Excel will still place automatic breaks based on the paper size, margins, and content. If a page is still spilling over, adjust options under Page Layout, such as orientation, margins, or scaling, and check the preview after each change. Use scaling carefully, since fitting a large worksheet onto one page can make text too small to read.

Mac and web note: In Excel for Mac, right-click or Control-click the sheet tab and choose Delete; ribbon labels and window placement can vary slightly by release. In Excel for the web, right-click the tab and choose Delete, then confirm if asked. The browser version may offer fewer print-layout controls than desktop Excel. If a particular page-break or print-area command is unavailable, open the workbook in the desktop app.

Common Mistakes

  • Deleting the wrong thing. Deleting a worksheet removes its data, while clearing cells, deleting a row, and clearing a print area affect different parts of the workbook. Confirm the tab name and the result you want before choosing a command.
  • Assuming a printed page is a separate sheet. A print page is a layout result, not a worksheet tab you can select and delete. Use a print area or adjust page breaks and layout if the data should remain in the workbook.
  • Ignoring formulas and links. Other sheets may refer to the worksheet you remove. Check important formulas and charts before deleting, and verify them afterward. A backup is the safest way to preserve the original version.
  • Confirming the warning without reading it. Excel warns that deleting a sheet removes its contents. If you are unsure, cancel, inspect the tab, and save a copy before trying again.
  • Confusing Hide with Delete. Hiding a sheet only removes its tab from view; the sheet and its data remain in the workbook. Use Unhide later if you need it back. Deleting removes the sheet itself.
  • Making print scaling too small. Forcing an entire wide or long worksheet onto one page can technically remove extra printed pages but make the text unreadable. Prefer a sensible print area, landscape orientation, or readable multi-page output.

Tips

  • Rename tabs with clear labels before editing a complex workbook. Names such as Archive 2024 or Regional Sales make it easier to identify the right worksheet than Sheet7.
  • Before removing a sheet, use Find or inspect formulas in key summary sheets for references to its name. Also look at charts, named ranges, and data that another person may expect to remain available.
  • If you only want to remove the worksheet’s information but keep its tab, select the relevant cells and use Home > Clear > Clear All only when you intend to remove contents and formatting. To remove cell contents while retaining formatting, select the cells and press Delete on the keyboard. Neither action deletes the sheet.
  • Use Print Preview after changing the print area or layout. It is the quickest way to see whether the unwanted page is gone and whether the remaining pages are legible.
  • Make one print-setting change at a time. If you change margins, orientation, scaling, and page breaks together, it is harder to identify which setting caused an unexpected result.
  • If a sheet is only temporarily irrelevant, hide it rather than deleting it. This keeps its data available and reduces the chance of breaking formulas or losing information someone needs.

Troubleshooting

Delete is unavailable or Excel will not remove the sheet: Check whether the workbook structure is protected. In desktop Excel, look under Review for Protect Workbook; if workbook structure protection is active, an authorized user must unprotect it before sheets can be deleted. If the file is read-only or you only have view access, ask for edit permission or save an editable copy where allowed.

Excel says at least one visible sheet must remain: A workbook must have a visible worksheet. If the sheet you want to remove is the only visible one, first make another sheet visible or add a new worksheet, then delete the unwanted sheet. Do not leave the workbook without a visible sheet.

The tab disappeared, but you meant to keep the sheet: If you have not closed the file, try Undo immediately: Ctrl+Z on Windows or Command+Z on Mac. If Undo is no longer available, restore the sheet from your backup or an earlier saved version. A hidden sheet is different from a deleted one, so check the tab context menu for Unhide if the sheet may only have been hidden.

Formulas show #REF! after deletion: The formulas may have referred to cells on the removed worksheet. Undo the deletion if possible, or restore the sheet from a backup and revise the formulas before removing it again. Do not replace the error with a guessed value if the result is used in a report or calculation; identify the intended source data first.

The extra printed page remains: Check whether the print area includes stray cells far below or to the right of the main data. Clear or reset the print area, select only the intended range, and set it again. Then inspect manual page breaks and the paper size, margins, and orientation. Automatic page breaks can remain even after manual breaks are reset, so adjust the layout or print range and preview again. If a mostly blank page persists, look for a cell with formatting or content outside the visible table that is extending the print range.

The print options are missing in Excel for the web: Some page setup controls depend on the version and browser. Save the workbook, open it in Excel for Microsoft 365 on Windows or Excel for Mac, and make the print-area or page-break adjustment there. Confirm that the workbook is saved before returning to the browser version.

Frequently Asked Questions

Can I delete a page in Excel without deleting its worksheet?
Yes, if you mean a printed page. Set a print area that excludes the cells, or change page breaks and layout. The worksheet data remains. Excel does not treat printed pages as individual objects that can be deleted.

How do I delete a blank page in an Excel printout?
Open Print Preview, then check the print area for an oversized range and look for manual breaks or stray used cells. Clear or reset the print area, set the intended range, and preview again. Resetting manual breaks will not remove automatic page breaks.

Can I recover a worksheet after deleting it?
Use Undo straight away if it is still available. Otherwise, restore a backup or an earlier version of the workbook. Excel does not provide a general worksheet recycle bin for a sheet deleted from a saved workbook.

Will deleting a sheet break formulas?
It can. Formulas, charts, or other workbook elements that depend on the sheet may stop working or show errors such as #REF!. Check those connections before deletion and verify important results afterward.

Is hiding a worksheet the same as deleting it?
No. A hidden sheet remains in the workbook and can usually be made visible again with Unhide. Deleting removes the sheet and its contents, so use Hide when you may need the data later.

Can I delete the only sheet in a workbook?
No. Excel requires at least one visible worksheet. Add or make another sheet visible first, then delete the unwanted one.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.