Software & Apps MS Office How to Delete a Page in Excel Stop printing blank pages by Amanda Derrick Freelance Contributor Amanda Derrick is a mechanical engineer, business strategist, and former Lifewire writer who has also written for USAF Civil Service, ATK, and Boeing. our editorial process Twitter LinkedIn Amanda Derrick Updated on October 06, 2020 MS Office Excel Word Powerpoint Outlook Tweet Share Email 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. 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. 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. 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. When you finish adjusting your 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 Selected Area by following these steps. For one-time printing: Select and drag to highlight the area of your worksheet that you want to print. Select the File tab. Choose Print. Choose Print Selection in the list under Settings. 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. 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 will see a slight outline illustrating your new print area. If you need to change your print area, select Print Area > Clear Print Area.