How to Delete a Page in Excel

Stop printing blank pages

You've created a killer Excel worksheet, but your printer adds a handful of mysteriously blank pages to your print job. Why? A handful of technicalities might cause printing issues you can correct by setting your page breaks and print areas.

Instructions in this article apply to Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, and Excel 2010.

How To Delete Unwanted Pages in Excel

Page breaks are the boundaries in a worksheet that decide what content goes on your printed document page. Excel will choose these for you automatically, using your default paper size and margin settings. You can also tweak the automatic page breaks by scaling your print job smaller (<100%) or larger (>100%) than your working document.

Insert, delete, or move page breaks in Excel to make sure pages print as expected.

You can adjust page breaks in the Normal view in Excel, but it's much easier to use Page Break Preview to work on your page break layout. The preview mode will show how any change you make to columns or rows impacts your automatic page breaks.

  1. Open the worksheet in which you want to delete a page and select the View tab.

    The View tab in Excel
  2. Select Page Break Preview in the Workbook Views group.

    The "Page Break Preview" button in Excel
  3. With Page Break Preview enabled, you can see a dotted line representing the automatic page break, with each page numbered.

    You can select any of the blue lines (both dotted and solid) to adjust your print areas.

    Page Break Preview
  4. Select and drag the dotted blue line (an automated print break) to adjust the area you would like to have printed. The line turns solid, converting it to a manual page break.

    Blue line in page break preview
  5. When you finish adjusting your page breaks, select Normal in the Workbook Views group.

    The "Normal" button in Workspace Views

How to Set Your Print Area in Excel

Creating page breaks is a great way to manage larger documents, but what if you want to print a snapshot of the content and not the whole worksheet? You can use printer options to Print Selected Area by following these steps.

For one-time printing:

  1. Select and drag to highlight the area of your worksheet that you want to print.

    Selected cells in Excel
  2. Select the File tab.

    The File menu in Excel
  3. Choose Print.

    The Print command in Excel
  4. Choose Print Selection in the list under Settings.

    The "Print Selection" command

Change Print Settings Permanently

If you'll be printing the selected area more than once and want to set a print area for the document permanently, you can do it this way.

  1. Go to the Page Layout tab.

    The Page Layout tab
  2. Highlight the area that you want to print, then select Print Area in the Page Setup group.

    The "Print Area" button
  3. Choose Set Print Area.

    The "Set Print Area" command
  4. You will see a slight outline illustrating your new print area. If you need to change your print area, select Print Area > Clear Print Area.

    The "Clear Print Area" command