How to Delete a Page in Excel

Stop printing blank pages

Excel Spreadsheets printed hardcopy

Nigel Carse / Getty Images

 

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

The instructions in this article should work for all versions of Microsoft Excel from 2003 forward and is very similar to the process in Word.

How To Delete Unwanted Pages in Excel

Page breaks are the boundaries in a worksheet that decide what content goes on what page of your printed document. 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. Access the Page Break Preview setting located on the View Ribbon under the Workbook Views section. Select Page Break Preview to enable the preview mode.

    Older versions of Excel may require users to use View > Page Break Preview under the Menus tab.

  2. With Page Break Preview enabled, you can see a dotted line representing the automatic page break, with each page numbered. Even this small document is defaulting to print across two pages, breaking up the text in cell H.

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

  3. 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.

  4. Drag the print break line to include all of your text on Page 1.

    A custom page break in Microsoft Excel.
  5. Page 2 is now blank, but it will most likely print with your document anyway since it once held relevant data. To make it go away, you need to grab the outside print area bar on the right and drag it to meet the page break bar that is separating the two pages.

  6. When you finish adjusting your page breaks, return to the View ribbon or menu and select Normal.

    Once you've returned to the Normal view, you can still see just a hint of your page breaks. However, you won't be able to move them around outside of the Page Break Preview mode.

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.

    How to select data in Excel to set print area.
  2. Go to File > Print to print your document. Choose Print Selection in the drop down menu under Settings.

    The Print Selection in Microsoft Excel.
  3. As an alternative, you may also use the bottom drop down menu to scale your selected content to fit on a single page or customize the scale.

    Custom Scaling for Excel print area.

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

  1. Go to the Page Layout Ribbon or menu.

  2. Highlight the area that you want to print, then click Print Area and choose Set Print Area.

  3. 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.

These two methods should help you keep blank mystery pages out of your Excel print jobs.