How to Remove Page Breaks in Excel (Page Break Preview & Reset)
If you want to know how to remove page break in excel worksheets, navigate to the Page Layout tab, click the Breaks dropdown, and click Remove Page Break (to delete a single break) or Reset All Page Breaks (to clear every manual boundary). For complete visual control over print boundaries, switch to Page Break Preview.
Method 1: Delete a Specific Manual Break via the Ribbon
- Click the cell directly below and to the right of the page break you wish to remove (for a horizontal break, select any cell in the row immediately below the break line).
- Click the Page Layout tab on the Excel Ribbon.
- In the Page Setup section, click the Breaks button.
- Click Remove Page Break. The selected boundary will vanish.
Method 2: Reset All Page Breaks Across the Worksheet
When inheriting a complicated spreadsheet filled with conflicting print breaks:
- Select the worksheet you wish to normalize.
- Go to the Page Layout tab.
- Click Breaks and choose Reset All Page Breaks.
- All manual overrides are erased, returning Excel to its default pagination calculations.
Method 3: Visual Drag-and-Drop in Page Break Preview
The most intuitive way to adjust print areas is Excel’s interactive canvas:
- Click the View tab on the Ribbon and select Page Break Preview (or click the third small icon on the status bar at bottom right).
- Manual page breaks appear as solid blue lines. Automatic breaks appear as dashed blue lines.
- To remove a break, click and drag the blue line outside of the active print area, or right-click the line and select Remove Page Break.
- To return to normal editing, click View > Normal.
Frequently Asked Questions
How do I remove all manual page breaks in an Excel sheet in one step?
Go to the Page Layout tab on the Ribbon, click the "Breaks" dropdown button in the Page Setup group, and click "Reset All Page Breaks". All manual breaks are cleared, restoring default automatic pagination.
What is the difference between a solid blue line and a dashed blue line in Page Break Preview?
A solid blue line represents a manual page break created by a user. A dashed blue line represents an automatic page break generated by Excel based on print paper size and margin constraints.
Can you delete automatic dashed page breaks in Excel?
You cannot directly delete automatic breaks, but you can override them by dragging the dashed blue line to the right or bottom boundary in Page Break Preview, or by setting "Fit to 1 page wide" in Page Setup.
How do I hide the dotted page break lines in Excel’s standard Normal view?
Go to File > Options > Advanced. Scroll down to "Display options for this worksheet" and uncheck "Show page breaks", then click OK.
Exported your spreadsheet to a messy PDF?
If an Excel export generated stray trailing pages in your PDF, prune them in seconds.