How to Edit Page Breaks in Excel for Better Printing

To edit a page break in Excel for Microsoft 365 on Windows, choose View > Page Break Preview, then drag a break line to where you want the printed page to end. To add, remove, or reset breaks, use Page Layout > Breaks; check the result in Print Preview before printing.

What page breaks do in Excel

A page break marks where Excel divides a worksheet into separate pages for printing or for a PDF export. A horizontal break starts a new page below a particular row; a vertical break starts a new page to the right of a particular column. If a worksheet is wider and taller than one printed page, Excel may use both kinds of breaks to form a grid of pages.

Excel creates automatic page breaks based on the printable area and the worksheet’s print settings. These breaks can shift when you change the paper size, orientation, margins, scaling, or printer. Manual breaks, by contrast, are the divisions you add or reposition yourself. In Page Break Preview, automatic breaks appear as dashed lines and manual breaks appear as solid lines. The preview also shows page numbers and areas outside the print range.

A page break does not delete, hide, or rearrange worksheet data. It only changes where the content is divided between printed pages. For example, if a report has a heading in row 20 and you want the next section to begin on a fresh sheet of paper, a horizontal break above row 20 can keep that section together—provided the content above it fits on the preceding page.

Open Page Break Preview

Page Break Preview is the clearest view for editing breaks because it displays the page boundaries directly on the grid. Open the worksheet you want to print, then select View > Page Break Preview. If Excel asks whether to continue, confirm the change to this view. You can also select the Page Break Preview button on the status bar, if it is visible.

Drag a solid or dashed boundary to move it. Drag a boundary toward the edge of the worksheet to remove a manual break. Be careful to grab the line itself rather than a cell. If the worksheet is large, use the zoom controls or scroll to the relevant rows and columns before dragging.

When you have finished arranging pages, select View > Normal to return to the usual worksheet view. This changes only how Excel displays the sheet; it does not undo your page-break edits. You can switch back to Page Break Preview whenever you need to refine the layout.

Insert a horizontal or vertical break

You can add a manual break from the ribbon when you know the row or column where the new page should start. Excel places the break above and to the left of the selected cell. That means the selection determines which direction the break applies:

For a horizontal break above row 25, select a cell in row 25, then choose Page Layout > Breaks > Insert Page Break.
For a vertical break to the left of column G, select a cell in column G, then choose Page Layout > Breaks > Insert Page Break.
To create both a horizontal and a vertical break, select a cell that is both below the desired horizontal boundary and to the right of the desired vertical boundary. Then choose Page Layout > Breaks > Insert Page Break.

For instance, selecting D25 inserts a horizontal break above row 25 and a vertical break to the left of column D. If you want only one direction, select a cell in the row or column that defines that boundary, rather than a cell that would create both. Look at the result in Page Break Preview, since the page division may interact with existing breaks and print settings.

Move, remove, or reset breaks

To adjust an existing break precisely, use Page Break Preview and drag its line to a different row or column boundary. If you want to delete just one manual break, select the cell immediately below a horizontal break or immediately to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. The command removes the break associated with that selection, so check the preview afterward.

If you have added several breaks and would rather start over, choose Page Layout > Breaks > Reset All Page Breaks. This clears the worksheet’s manual page breaks and lets Excel determine the automatic divisions again. It does not remove data or formatting, but it may change the number and arrangement of printed pages.

There is an important distinction between removing a manual break and changing an automatic one. A manual break is an instruction you set; an automatic break is calculated from the current layout. You can drag an automatic boundary to create a manual adjustment, but changing the print area, page size, scaling, or margins can cause automatic boundaries to move again.

Check scaling, paper size, and print area

Page breaks cannot be considered separately from the settings that define the printable page. Before adding many manual breaks, check Page Layout for the paper size, orientation, and margins. A worksheet set to Letter paper in Portrait orientation will divide differently from the same worksheet on A4 paper in Landscape orientation. A different selected printer can also change the available printable area.

Scaling is especially important. On the Page Layout tab, the Scale to Fit controls can shrink a worksheet to fit a set number of pages wide or tall. If Width or Height is set to a specific page count, Excel scales the content to meet that target, and manual breaks may not behave as expected. To control page divisions manually, set Width and Height to Automatic where appropriate, then inspect Page Break Preview again. The exact result still depends on the sheet’s dimensions and other print settings.

A print area limits which cells Excel prints. To set one, select the cells and choose Page Layout > Print Area > Set Print Area. If breaks seem to fall in unexpected places, confirm that the intended range is included and that an old print area is not excluding rows or columns. Choose Page Layout > Print Area > Clear Print Area to remove it. You can also repeat heading rows on each page through Page Layout > Print Titles; that repeats labels but does not itself insert a page break.

Preview and troubleshoot common problems

Use File > Print to check the final pagination before sending the worksheet to a printer. On Windows, Ctrl+P opens the print screen; on Mac, use Command+P. The print screen gives you a useful final check of page count, orientation, and scaling, although Page Break Preview is usually easier for directly moving worksheet boundaries.

If Excel ignores a break or the pages look different from what you expected, work through these checks:

The break moved after a settings change: Recheck paper size, orientation, margins, scaling, and printer selection. Those settings affect automatic pagination.
Text or columns are clipped: Try Landscape orientation, narrower margins, or a smaller scale. You can also adjust column widths. A break controls the division between pages; it does not make oversized content fit.
A heading is stranded at the bottom of a page: Insert a horizontal break above the next section, or adjust row heights and scaling so the heading and following content stay together.
There are too many pages: Check for an unnecessarily large used range or print area, and review scaling. Blank-looking formatted cells far from the data can affect the apparent worksheet extent, so clear unwanted formatting or set a deliberate print area if appropriate.
Page Break Preview is gray or confusing: Gray areas generally lie outside the print area, while page numbers identify the printed pages. Confirm the print area and switch to Normal view when you no longer need the preview.

For a large report, make one change at a time and revisit File > Print. This helps identify whether a surprising page count comes from a manual break or from a setting such as Fit to page. If you need consistent output on another computer, keep in mind that a different printer driver or paper configuration can affect pagination.

Manual breaks compared with other layout controls

Manual page breaks are useful when the meaning of the report matters more than dividing it into evenly sized pieces—for example, when each department should begin on a new printed page. Automatic breaks are better when the worksheet changes frequently and you want Excel to paginate the current content without maintaining a list of fixed boundaries.

Other print controls solve different problems. A print area chooses which cells to print; Print Titles repeats selected heading rows or columns; orientation and margins change the space available; and scaling changes the size or page count of the output. These controls can complement page breaks, but they are not interchangeable. If the goal is to keep a table readable, repeating column headings may help more than inserting extra breaks. If the goal is to omit an unused section, change the print area rather than trying to push that section onto another page.

When you need a one-page overview, scaling the sheet to fit one page may be convenient, but it can make text too small to read. When readability matters, use multiple pages with clear breaks and repeated headings instead of forcing everything onto one sheet of paper. The best choice depends on whether the printed document needs to prioritize compactness, legibility, or section-by-section organization.

Excel for Mac and Excel for the web

In Excel for Mac, the same general method applies: use the Page Layout tab’s Breaks controls to insert, remove, or reset breaks, and use Page Break Preview to see and drag page boundaries. Ribbon wording or placement can vary slightly by release. The common print shortcut differs: Command+P opens Print on Mac, while Ctrl+P does so on Windows.

Excel for the web has more limited page-layout controls than the desktop application, and manual page-break editing may not be available there. If you cannot find Page Break Preview or the Breaks commands, open the workbook in the desktop version of Excel to edit the breaks. You can then return to the web version for supported workbook tasks, but check the printed output in the desktop app if exact pagination is important.

Frequently Asked Questions

How do I move a page break in Excel?
Choose View > Page Break Preview, then drag the break line to the row or column boundary where the next printed page should begin. Check File > Print to confirm the resulting pages.

How do I remove a page break without clearing all of them?
Select a cell below a horizontal break or to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. For a quick visual adjustment, you can also drag a manual boundary toward the worksheet edge in Page Break Preview.

Why are my Excel page breaks not working?
Scaling, print area, paper size, margins, orientation, or printer settings can change pagination. Review those settings, confirm that you are editing the correct worksheet, and inspect the result in Page Break Preview and the Print screen.

How do I get rid of all page breaks in Excel?
Choose Page Layout > Breaks > Reset All Page Breaks. Excel removes manual breaks and recalculates automatic ones from the current print layout; it does not erase worksheet content.

Can I edit page breaks in Excel for the web?
Manual page-break controls are limited or unavailable in Excel for the web. Open the workbook in desktop Excel for Windows or Mac when you need to insert, move, or remove manual breaks.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.