Insert a Horizontal Page Break in Excel the Right Way

To insert a horizontal page break in Excel for Microsoft 365 on Windows, select the row directly below where you want the printed page to end, then choose Page Layout > Breaks > Insert Page Break. Excel places a manual break above that row, so the rows above it print on one page and the selected row begins the next. You can check the result in Page Break Preview or Print Preview before printing.

What You’ll Need

An Excel workbook open in the desktop version of Excel. The instructions below are for Microsoft 365 on Windows.
A worksheet with the rows you want to divide into printed pages. You do not need a printer connected to insert a break, but Print Preview is useful for checking pagination.
Optional: a defined print area, if you want Excel to print only part of the worksheet. A manual break outside the print area will not affect the pages that area produces.

Horizontal describes the direction of the line across the worksheet: it separates one group of rows from the next. It does not mean a page is printed in landscape orientation. Page orientation is a separate setting that changes how the sheet fits on paper.

Step-by-Step

Open the worksheet you intend to print.
Click the worksheet tab that contains the rows to be divided. If the workbook has several sheets, check that you are editing the correct one. Page breaks belong to an individual worksheet, so inserting one on a different tab will not change the sheet you plan to print.
Choose where the next page should begin.
Find the first row that you want to appear on the next printed page. For example, if rows 1 through 24 should print on the first page and row 25 should start the second, the break belongs above row 25. Think in terms of the first row on the next page; this avoids the common off-by-one mistake.
Select the entire row below the desired break.
Click the row number at the far left of the worksheet. In the example, click the heading for row 25 so the whole row is selected. Selecting the row is the safest way to request a horizontal break only. If you select a single cell instead, Excel may insert both a horizontal break above that cell and a vertical break to its left, which can split the printed output into extra pages.
Insert the manual page break.
On the ribbon, select Page Layout > Breaks > Insert Page Break. Excel adds a manual break above the selected row. You usually will not see a dramatic change in the normal worksheet grid, so continue to Page Break Preview or Print Preview to confirm its position.
Check the page division in Page Break Preview.
Select View > Page Break Preview. The worksheet displays page boundaries and page numbers. A solid blue line typically marks a manual page break, while dashed blue lines indicate automatic breaks that Excel calculated. Find the line across the sheet above the row you selected. If the break is not where you intended, return to the worksheet and repeat the process with the correct row.
Review the printed pages.
Choose File > Print to see the print preview. Confirm that the intended rows appear together and that no headings, totals, or related records have been separated awkwardly. A manual break sets a boundary, but it does not guarantee that the page will be filled neatly: column widths, margins, paper size, scaling, and the print area all affect the final output.
Adjust the break if the page layout needs refinement.
In Page Break Preview, you can drag a blue page boundary to another row. Use this when you need to move a break slightly and can see the page layout clearly. If the break is in the wrong place and you prefer to reset it precisely, select the row immediately below the unwanted break and choose Page Layout > Breaks > Remove Page Break. Then select the correct row and insert it again.
Return to the usual worksheet view when finished.
Select View > Normal to leave Page Break Preview. The break remains in the worksheet; changing the view does not remove it. Save the workbook if you want to keep the page setup for later printing or sharing.

On Excel for Mac, select the row below the intended division and use the Page Layout tab’s Breaks menu to choose Insert Page Break. The ribbon layout can differ slightly by Mac version, but the key is to select the whole row and use the page-break command. Excel for the web does not offer the same desktop controls for inserting manual page breaks; open the workbook in the desktop app to add or adjust one.

Common Mistakes

Selecting the row above the intended break. Excel inserts the break above the selected row. If you select row 24, row 24 starts the next page; to make row 25 start the next page, select row 25.
Selecting one cell when you only want a horizontal break. A cell selection can create a vertical break as well. Selecting the row heading clearly targets the full row and avoids accidentally dividing the columns.
Confusing a page break with a worksheet line. Gridlines are cell boundaries and do not control printing. A page break determines where printed pages divide. In Page Break Preview, look for the blue page boundaries rather than ordinary cell gridlines.
Assuming the break controls every print setting. It does not set paper size, margins, orientation, print area, or scaling. If the preview still looks wrong, check those settings as well as the break location.
Ignoring automatic breaks. Excel inserts automatic breaks based on the available page size. A manual break may coexist with these boundaries, so inspect the entire preview instead of assuming the worksheet will print as exactly two pages.
Using a break outside the printed range. If a print area is set, a break beyond its boundary may have no visible effect. Check Page Layout > Print Area or clear the print area if you want to print a different range.

Tips

Plan around complete sections. Place breaks between logical groups, such as after a department subtotal or between monthly report sections. Keeping a heading with its related rows is usually easier to read than splitting a section across pages.
Use Print Preview as the final check. Page Break Preview helps locate boundaries, while File > Print shows how the content will appear on paper or in a PDF. Check the top and bottom of each page, not just the page count.
Repeat column headings on later pages when needed. A horizontal page break does not repeat header rows by itself. To repeat a heading row on each printed page, open Page Layout > Print Titles and set the appropriate rows in Rows to repeat at top.
Use scaling only when it helps readability. Fit to page settings can shrink a worksheet to fit a chosen number of pages, sometimes making a manual break less useful or the text too small. Check the Scale to Fit settings on the Page Layout tab and inspect the preview after changing them.
Remember that page-break settings are sheet-specific. If several worksheets need the same division, review each one separately. Do not assume that a break added to one sheet will automatically appear on the others.
Keep a copy before making many layout changes. Page setup is easy to adjust, but a duplicate sheet or saved copy gives you a convenient way to compare the original layout with a revised print version.

Troubleshooting

The break appears in the wrong place. Check which row you selected. Excel puts the line above that row, not below it. In Page Break Preview, identify the first row that should begin the next page, remove the misplaced break, select that row heading, and insert the break again.

The sheet still prints across an unexpected number of pages. A horizontal break controls a row boundary, but Excel can also split pages vertically or add automatic horizontal breaks. Review the full Page Break Preview. Then check paper size, orientation, margins, scaling, column widths, and the print area. If the worksheet is too wide, a horizontal break alone cannot prevent extra pages across the columns.

The page-break command is unavailable or does not change the output. Make sure you are using the desktop Excel app, that the intended worksheet is active, and that a row or cell in the sheet is selected. If you are working in Excel for the web, open the file in desktop Excel. Also confirm that the selected row falls within the area being printed; a break outside a defined print area may not show in the preview.

The line is difficult to see or seems to disappear. Switch to View > Page Break Preview and look for the blue boundaries. In Normal view, page boundaries may appear as subtle lines after Print Preview, but that view is not as clear for arranging breaks. If needed, select View > Page Break Preview again to inspect the page layout.

A new break has made the layout worse. Select the row immediately below that break and choose Page Layout > Breaks > Remove Page Break. To clear manual page breaks on the active worksheet and start over, choose Page Layout > Breaks > Reset All Page Breaks. Resetting removes the manual break adjustments on that sheet, so use it only if you are comfortable rebuilding them.

Frequently Asked Questions

What does a horizontal page break do in Excel?
A horizontal page break tells Excel where to end one printed page and begin the next by separating rows. It does not change the data, insert a blank worksheet row, or change the page’s portrait or landscape orientation.

Do I select the row above or below the break?
Select the row below the point where you want the break. Excel places the boundary above the selected row. For example, select row 25 to make row 25 the first row on the next page.

Can I insert a horizontal break without adding a vertical break?
Yes. Select the entire row by clicking its row number, then choose Page Layout > Breaks > Insert Page Break. Selecting an individual cell can add a vertical boundary as well as a horizontal one.

How can I remove a horizontal page break?
Select the row immediately below the break and choose Page Layout > Breaks > Remove Page Break. To remove all manual page breaks from the active sheet, choose Reset All Page Breaks from the same Breaks menu.

Will a manual page break change the worksheet for other people?
The break is saved as part of the worksheet’s page setup, so it can affect how the sheet prints when someone opens the workbook in desktop Excel. The result can still vary with their printer, paper settings, margins, and scaling.

Can I add page breaks in Excel for the web?
For inserting and managing manual page breaks, use the desktop Excel app. Open the workbook in Excel for Microsoft 365 on Windows or Excel for Mac, select the row, and use the Breaks command on the Page Layout tab.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.