Excel Horizontal Page Breaks: Insert, Move, and Remove

An Excel horizontal page break controls where one printed page ends and the next begins as you move down a worksheet. In Excel for Microsoft 365 on Windows, select the row below the desired break, then choose Page Layout > Breaks > Insert Page Break; use Page Break Preview to check and adjust the result.

What a horizontal page break does

Excel divides a worksheet into printed pages according to the paper size, margins, scaling, print area, and the amount of data on the sheet. A horizontal page break marks a boundary across the worksheet between rows. Rows above the boundary print on one page, and rows below it continue on the next page. It changes the print layout, not the worksheet’s data or the way cells appear during ordinary editing.

Excel creates automatic page breaks when it calculates how much content fits on each printed page. You can also add a manual break to specify a boundary that better suits the information. For example, a monthly report with a heading in row 1 and entries in rows 2 through 38 might otherwise split halfway through a group. Inserting a break above row 21 can keep the first 19 entries together on page one and start the remaining entries on page two.

A horizontal break is different from a vertical page break, which separates printed pages between columns. If you select a whole row before inserting a break, Excel inserts a horizontal break above it. If you select a cell, Excel can insert a horizontal break above that cell’s row and a vertical break to its left. Selecting the full row is the clearest way to add only a horizontal break.

Insert a horizontal page break in Excel

First decide which row should begin the next printed page. Select that row, not the last row you want on the preceding page. For instance, to start a new page at row 25, select row 25. Then use these steps in Excel for Microsoft 365 on Windows:

Click the row number at the left edge of the worksheet to select the entire row where the next page should begin.
Open the Page Layout tab on the ribbon.
In the Page Setup group, choose Breaks, then Insert Page Break.
Choose View > Page Break Preview to see where the break falls and whether Excel has created other page boundaries.

The new break applies to the sheet’s print layout. If the worksheet spans several pages across, a horizontal break divides the content at that row on the relevant page columns. Check the preview rather than assuming that the sheet will print as a single column of pages.

You can also insert a break while a cell is selected. Excel places a horizontal break above the selected cell’s row and a vertical break before its column. This can be useful when you intentionally need to divide a sheet in both directions, but it may add a vertical boundary you did not want. If that happens, use Page Layout > Breaks > Remove Page Break with a cell in the affected area selected, or undo the insertion immediately.

View and adjust breaks in Page Break Preview

Page Break Preview gives a page-oriented view of the worksheet. Choose View > Page Break Preview to display the printable pages and their boundaries. Excel shows manual and automatic page breaks with different line styles; the preview also labels the pages. The worksheet may look enlarged or show page numbers in the background, but those markings are part of the preview and do not print as worksheet content.

In this view, you can drag a page-break line to a different row. Dragging a horizontal boundary changes which rows print on each page. Moving an automatic break can turn it into a manual break. This is often quicker than removing and reinserting a boundary when you only need to fine-tune the amount of content on a page.

Use the preview to check the whole layout, not only the break you just added. A break moved down may leave too little room for a heading or push a total onto an awkward page. If a sheet is wide, inspect the page columns as well: an apparently correct horizontal split may still produce extra pages because some columns print separately.

Move, remove, or reset page breaks

To remove one break, select a cell in the row immediately below the horizontal break and choose Page Layout > Breaks > Remove Page Break. For a vertical break, select a cell in the column immediately to its right. If you are unsure which boundary is selected, work in Page Break Preview and check the result after removal.

To clear manually inserted breaks throughout the worksheet, choose Page Layout > Breaks > Reset All Page Breaks. This restores Excel’s automatic pagination for that sheet; it does not delete worksheet content. Use this when a complicated set of manual boundaries is harder to repair than to rebuild. The command affects the active worksheet, so confirm that the correct sheet is selected first.

Removing a manual break does not guarantee that the printed pages will join into one page. Excel may immediately place an automatic break at the same or a nearby row because the content still exceeds the available page area. That is expected: removing your instruction lets Excel calculate a suitable boundary again, but it does not enlarge the paper or reduce the amount of content.

What determines where a page ends

Page breaks depend on more than row numbers. Excel calculates how much of the sheet fits within the printable area, which is the paper area remaining after margins and other print settings. A change to any of the following can alter automatic page breaks and the apparent location of manual ones:

Paper size and orientation: A landscape page usually has more horizontal room, while a larger paper size may fit more content overall.
Margins: Wider margins reduce the area available for rows and columns.
Scaling: Shrinking the sheet can fit more content on a page, while increasing its size can create additional pages. Fit-to-page scaling can affect how manual breaks are honored, so check the preview after changing it.
Print area: A defined print area limits what Excel prints. Set or clear it using Page Layout > Print Area.
Row heights and column widths: Wrapped text, manually enlarged rows, and wide columns can change pagination.

For example, a report that fits on two pages at 90 percent scaling might need three pages at 100 percent. If you change orientation from portrait to landscape, Excel may fit more columns across and recalculate page boundaries. Therefore, choose the paper, orientation, margins, and scaling before spending time positioning several manual breaks. If a change is unavoidable, revisit Page Break Preview afterward.

Page breaks, print titles, and scaling are different

A page break decides where one printed page stops and another begins. It does not repeat a heading at the top of each page. If a table needs its column headings repeated, use Page Layout > Print Titles and specify rows to repeat at the top. For example, if the headings are in row 1, set the rows-to-repeat field to $1:$1. Print titles and page breaks solve different problems and can be used together.

Scaling is another separate control. In the Page Layout tab’s Scale to Fit group, width and height settings can fit a worksheet to a specified number of pages. This can be useful for a compact report, but forcing a long worksheet onto one page vertically may make the text too small to read. A manual page break is usually better when the goal is to start a new section on a fresh page while keeping a sensible print size.

Likewise, a print area controls which cells are included; it does not determine a section break within that area. A practical setup for a multi-page table might use a print area to exclude notes in distant columns, print titles to repeat the header row, and manual horizontal breaks to begin each department on a new page.

Common page-break problems

If the printed output does not match what you expect, look at the print settings as well as the break itself. Page Break Preview and File > Print are useful checks, because a worksheet view alone does not show exactly how the selected paper size and scaling will paginate the sheet.

The break appears to be in the wrong place: Confirm that you selected the row that should start the next page. Then check scaling, paper size, orientation, and margins.
The break command is unavailable or has no useful effect: Confirm that a worksheet cell or row is selected and that you are working in a desktop version of Excel. If the sheet is protected, protection can restrict changes; review the sheet’s protection settings or ask the workbook owner.
A break disappears after changing layout: Excel recalculates pagination when print settings change. Reopen Page Break Preview and reposition the boundary after settling the page setup.
There are still many pages after removing a break: Those may be automatic breaks. Reduce the print area, adjust scaling, or change page setup if fewer pages are genuinely needed.
A header is missing on later pages: Set repeating print-title rows; inserting a page break does not repeat headings.

Also check for content far outside the table that may be included in the print area or used area. Stray formatting or a value in a distant row or column can make a printout unexpectedly large. Use the preview to identify extra pages, then inspect the relevant range and the defined print area before changing breaks at random.

Excel on Mac and Excel for the web

In Excel for Microsoft 365 on Mac, the ribbon offers the same general Page Layout and page-break controls, though ribbon organization and keyboard shortcuts can differ from Windows. Use the Page Layout tab’s Breaks control to insert or remove a break, and use Page Break Preview to inspect the result when those controls are available. If a command is not visible, check the current ribbon layout or Excel’s Help rather than relying on a Windows-only shortcut.

Excel for the web has a more limited set of page-layout and printing controls than the desktop application. For precise manual page-break insertion or adjustment, open the workbook in the desktop Excel app, make the change there, and verify the print preview. This is especially important for workbooks where page boundaries are part of a formal report layout.

Frequently Asked Questions

How do I insert a horizontal page break in Excel?
Select the row that should begin the next printed page, then choose Page Layout > Breaks > Insert Page Break. Check the result in View > Page Break Preview.

Do I select the row above or below the break?
Select the row below the break: it is the first row you want on the next page. For example, select row 25 to make row 25 the start of the next page.

Why does Excel ignore my manual page break?
Pagination can change when you modify scaling, paper size, margins, orientation, or the print area. Fit-to-page scaling can also change how breaks are applied. Review the settings in Page Layout and then inspect Page Break Preview.

How do I remove all page breaks in a worksheet?
Select the worksheet, then choose Page Layout > Breaks > Reset All Page Breaks. Excel clears manual breaks on that sheet and recalculates automatic breaks.

Does a horizontal page break repeat column headings?
No. A break controls where a page ends. To repeat headings on each printed page, choose Page Layout > Print Titles and specify the row or rows to repeat at the top.

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.