What to Know
- Go to the View tab, select Page Break Preview, then drag the dotted blue line to adjust the area you want to print.
- If you only want to print part of the worksheet, highlight the area you want to print, then go to the File tab and select Print.
- To set a print area for the document permanently, go to the Page Layout tab, highlight the area you want to print, then select Print Area.
This article explains how to delete pages in Excel. Instructions 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 chooses these for you automatically, using your default paper size and margin settings. You can also adjust the automatic page breaks by scaling your print job smaller (less than 100 percent) or larger (more than 100 percent) than your working document.
Insert, delete, or move page breaks in Excel to make sure pages print as expected.
Open the worksheet in which you want to delete a page and select the View tab.
Select Page Break Preview in the Workbook Views group.
You can adjust page breaks in the Normal view in Excel, but it's easier to use Page Break Preview to work on the page break layout. The preview mode shows how any change you make to columns or rows impacts the automatic page breaks.
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 the print areas.
Select and drag the dotted blue line (an automated print break) to adjust the area you would like to print. The line turns solid, converting it to a manual page break.
When you finish adjusting the page breaks, select Normal in the Workbook Views group.
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 a selected area by following these steps.
For one-time printing:
Select and drag to highlight the area of the worksheet that you want to print.
Select the File tab.
Choose Print Selection in the list under Settings.
Change Print Settings Permanently
If you'll print the selected area more than once and want to set a print area for the document permanently, you can do it this way.
Go to the Page Layout tab.
Highlight the area that you want to print, then select Print Area in the Page Setup group.
Choose Set Print Area.
You'll see a slight outline illustrating the new print area. If you need to change the print area, select Print Area > Clear Print Area.
- How do I insert a page break in Excel?
To insert a page break in Microsoft Excel, select View > Page Break Preview. For a vertical page break, select the row below where the break will be. For a horizontal page break, select the column to the right of where the break will be. When you're ready, select Page Layout > Breaks > Insert Page Break.
- How do I remove page breaks in Excel?
To remove a horizontal page break, select the row below the page break. To remove a vertical page break choose the column to the right of the page break. When you're ready, select Page Layout > Breaks > Remove Page Break.
- How do I add page numbers in Excel?
To insert page numbers in an Excel worksheet, go to the Insert tab, select Header & Footer, and choose Click to add header or Click to add footer. In Header & Footer tools, select the Design tab, choose where you want the page number to appear, and select Page Number. Click outside the header or footer to see the page numbers.