Stop printing blank pages
What to Know
This article explains how to delete pages in Excel.
Excel chooses these for you automatically, using your default paper size and margin prefs.
Insert, delete, or move page breaks in Excel to double-check pages print as expected.
pop fire up worksheet in which you want to delete a page and select theViewtab.
SelectPage Break Previewin the Workbook Views group.
The preview mode shows how any change you make to columns or rows impacts the automatic page breaks.
you might select any of the blue lines (both dotted and solid) to adjust the print areas.
The line turns solid, converting it to a manual page break.
When you finish adjusting the page breaks, selectNormalin the Workbook Views group.
you’re free to 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.
ChoosePrint Selectionin the list underSettings.
Go to thePage Layouttab.
Highlight the area that you want to print, then selectPrint Areain the Page Setup group.
You’ll see a slight outline illustrating the new print area.
If you oughta change the print area, selectPrint Area>Clear Print Area.
FAQ
Toinsert a page break in Microsoft Excel, selectView>Page Break Preview.
For a vertical page break, pick the row below where the break will be.
For a horizontal page break, pick the column to the right of where the break will be.
When you’re ready, selectPage Layout>Breaks>Insert Page Break.
To remove a horizontal page break, choose 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, selectPage Layout>Breaks>Remove Page Break.
Click outside the header or footer to see the page numbers.
