How to Delete a Page in Excel GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office

How to Delete a Page in Excel

Stop printing blank pages

By Amanda Derrick Amanda Derrick Freelance Contributor University of Utah Florida Tech Amanda Derrick is a mechanical engineer, business strategist, and former Lifewire writer who has also written for USAF Civil Service, ATK, and Boeing. lifewire's editorial guidelines Updated on October 15, 2022 Reviewed by Jessica Kormos Reviewed by Jessica Kormos Saint Mary-of-the-Woods College 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. lifewire's editorial guidelines Tweet Share Email Tweet Share Email

In This Article

Expand Jump to a Section How to Delete Unwanted Pages in Excel How to Set Your Print Area in Excel Change Print Settings Permanently Frequently Asked Questions

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. FAQ 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. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Set Print Area in Excel How to Limit Rows and Columns in an Excel Worksheet How to Delete a Blank Page in Word How to Create a Report in Excel How to Make a Schedule in Excel How to Convert Excel Documents to the PDF Format How to Remove a Page Break in Word How to Make a Calendar In Excel How to Insert a Page in Word Microsoft Publisher Tutorial for Beginners How to Create Exploding Pie Charts in Excel How to Use Google Sheets How to Insert a Page Break in Word Use Office Clipboard to Copy Multiple Items in Excel How to Delete a Page in Google Docs How to Password Protect an Excel File Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies