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 January 14, 2021 reviewed by Jessica Kormos Lifewire Tech Review Board Member Jessica Kormos is a writer and editor with 15 years' experience writing articles, copy, and UX content for Tecca.com, Rosenfeld Media, and many others. our review board Article reviewed on Dec 06, 2020 Jessica Kormos Tweet Share Email MS Office Excel Word Powerpoint Outlook 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. 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. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Email Address Sign up There was an error. Please try again. You're in! Thanks for signing up. There was an error. Please try again. Thank you for signing up. Tell us why! Other Not enough details Hard to understand Submit