Excel Page Break on Row: How to Set and Fix It

To put a page break above a specific row in Excel for Microsoft 365 on Windows, select that row by clicking its number, then choose Page Layout > Breaks > Insert Page Break. Excel will start the next printed page at that row; check the result in View > Page Break Preview or in Print Preview.

What a Page Break on a Row Does

A page break controls where Excel divides a worksheet when it is printed or saved as a PDF. A horizontal break placed above row 25, for example, makes row 25 the first row on a new printed page. It does not insert a blank worksheet row, change the data, or move the cells. It only changes the print layout.

Excel creates automatic page breaks according to the paper size, margins, orientation, scaling, and amount of printable content. A manual break is a boundary you place yourself to control that division. The two kinds can work together: Excel still calculates the overall page layout, while your manual break marks a preferred boundary where the print settings allow it.

Page breaks are specific to the worksheet. A break on one sheet does not automatically apply to other sheets in the workbook, and it has no effect on how the worksheet looks on screen in a normal editing view beyond the page-break indicators Excel may display.

Insert a Page Break Above a Row

For a clean horizontal break, select the whole row rather than just one cell. This avoids adding an unwanted vertical break at the same time. Use these steps:

Open the worksheet you intend to print. If the workbook has several sheets, make sure you are on the correct one.
Click the row number immediately below the desired page boundary. To begin a new page at row 25, select row 25.
Choose Page Layout > Breaks > Insert Page Break.
Open View > Page Break Preview and check that the boundary is above the selected row.
Use File > Print to inspect the pages before printing or saving as PDF.

If you select a single cell instead of its row, Excel can insert both a horizontal break above that cell and a vertical break to its left. For example, selecting C25 may split the page above row 25 and to the left of column C. That can be useful when you want to control both dimensions, but it is a common cause of an unexpected narrow printed area. Selecting the row header is the straightforward choice when the goal is a break across the worksheet width.

On Excel for Mac, the ribbon command is also available from Page Layout > Breaks > Insert Page Break, though the interface can vary slightly by release. The Windows shortcut for printing is Ctrl+P; on Mac, use Command+P. Excel for the web has fewer page-layout controls, so use the desktop app if you need to insert or manage manual breaks.

Check and Adjust the Break

Page Break Preview makes it easier to see which rows will print on each page. Choose View > Page Break Preview. Excel outlines the printable pages and displays page boundaries as lines. A manual break is generally shown as a solid blue line, while automatic breaks appear as dashed lines. The preview may also display large page numbers over the sheet; those numbers are visual guides, not worksheet content.

You can drag a visible boundary in Page Break Preview to reposition it. Dragging a horizontal break changes the row at which the next page begins; dragging a vertical break changes the column boundary. Use this cautiously: moving a line may make a page too crowded or create extra pages. If you need an exact break at a specific row, insert it using the row header and then verify where Excel places it.

To return to the regular worksheet layout, choose View > Normal. The break remains part of the sheet’s print setup even when you are no longer viewing Page Break Preview. Before printing, use the page navigation in the Print screen to inspect every page, not just the first one. A break can look sensible in the worksheet but leave a heading or a few data rows isolated on a page.

Horizontal Breaks, Vertical Breaks, and Both

A row-based page break is horizontal: it divides the sheet between rows, across its printable width. A vertical page break divides the sheet between columns. This distinction matters for wide tables. If a report is too wide, adding a horizontal break will not bring its right-hand columns onto the same page; it only changes where rows split.

To create a vertical break, select the column immediately to the right of the intended boundary and choose Page Layout > Breaks > Insert Page Break. For instance, selecting column D places the intended split before column D. If you select an individual cell, Excel may create both a horizontal and vertical break based on its position. When the print layout becomes unexpectedly divided in two directions, inspect for both types of break in Page Break Preview.

Consider a table with customer details in columns A through F and 80 records. A horizontal break above row 42 can start the second set of records on a fresh page. If the columns also spill across paper, a vertical break may divide the fields into separate pages, which can make records hard to read. In that situation, changing the page orientation to landscape or scaling the sheet to fit the width may be better than forcing a vertical break.

Manual Breaks Versus Automatic Breaks

An automatic break is calculated by Excel when the content reaches the printable edge of a page. If you change the paper size, margins, row heights, column widths, or print scaling, Excel may recalculate those boundaries. A manual break expresses your preferred split, such as keeping a new section heading at the top of a page.

Manual breaks are not an absolute guarantee that a page will have a particular physical size. Printer settings and scaling influence the final output. In particular, using a Fit to pages setting can override or suppress manual page-break placement. If a break seems to have no effect, check the scaling settings in Page Layout > Page Setup using the dialog launcher, or inspect the Scaling options in the Print screen. Selecting a percentage under Adjust to rather than fitting the sheet to a fixed number of pages may be appropriate when you need manual breaks to govern pagination.

Also distinguish a page break from repeating titles. A manual break determines where one printed page ends and the next begins. Repeating title rows prints selected headings again at the top of each page; it does not decide where pages split. Set repeating headings through Page Layout > Print Titles when readers need column labels on every page, and use page breaks separately to control sections.

Plan the Printed Page Before Adding Breaks

Before inserting several manual breaks, check the settings that determine how much of the sheet fits on a page. A small change to a margin or orientation may solve a pagination problem without creating a long list of manual boundaries. Review these factors:

Paper size and orientation: Landscape gives a wide table more horizontal room; the selected paper size must match the printer or PDF output you intend to use.
Margins: Large margins reduce the printable area and can cause Excel to use more pages.
Print area: A defined print area limits which cells are included. Set or clear it from Page Layout > Print Area.
Scaling: Fitting all columns to one page wide can make text very small. Check the page count and legibility, not just whether the table fits.
Row heights and column widths: Wrapped text, unusually tall rows, and wide columns affect how much content fits before an automatic break.

A practical workflow is to set the print area, choose paper size and orientation, and inspect the page count first. Then add manual breaks only where a natural section boundary needs control. For example, a monthly report might use a page break before each new department, but it may be better to let ordinary rows flow across pages within a department. This avoids creating unnecessary blank space or a separate page for a short final section.

Common Problems and Their Fixes

The break appears in the wrong place. Confirm that you selected the row below the desired boundary. To start the next page at row 25, select row 25, not row 24. Then check whether a print area, scaling choice, or another manual break is affecting the layout.

The break does not show in the printed result. Look for a Fit to pages scaling setting, then review the actual Print Preview. A manual break may be disregarded when fitting the sheet to a specified page count. Also confirm that you are printing the worksheet that contains the break, rather than a different sheet or a selected range.

The printout has unexpected extra pages. In Page Break Preview, look for stray vertical or horizontal boundaries. A break inserted while a cell was selected can split the output in two directions. Check the print area and inspect far-right or lower cells as well, since formatting or content beyond the main table can expand the printed range.

A heading is stranded at the bottom of a page. Insert a horizontal break above the heading’s row, or adjust the preceding rows so the heading and its section remain together. If the same column headings are needed on every page, configure Print Titles too; a page break alone will not repeat them.

The break changes after layout edits. This can happen when you alter margins, paper size, orientation, or scaling. Recheck Page Break Preview after those changes and before printing. Treat manual breaks as part of the worksheet’s print setup, not as fixed markers that are independent of the page dimensions.

Remove or Reset Page Breaks

To remove one horizontal break, select the row immediately below it and choose Page Layout > Breaks > Remove Page Break. For an unwanted vertical break, select the column immediately to its right and use the same command. If you are unsure which break is selected, switch to Page Break Preview first so the boundary is visible.

To clear manual breaks across the worksheet, choose Page Layout > Breaks > Reset All Page Breaks. This restores Excel’s automatic pagination for that sheet; it does not delete worksheet data. Resetting all breaks is useful when a workbook has accumulated many boundaries and the print layout is difficult to troubleshoot. After resetting, revisit the print area, scaling, and preview, then add back only the breaks that serve a clear purpose.

Frequently Asked Questions

How do I start a new Excel print page at row 10?
Select row 10 by clicking its row number, then choose Page Layout > Breaks > Insert Page Break. Row 10 should begin the next printed page; confirm it in Page Break Preview.

Does a page break add a blank row?
No. A page break changes the print pagination only. The row numbers and cell contents stay where they are, and no blank worksheet row is inserted.

Why does Excel ignore my manual page break?
Check whether the sheet is set to fit a fixed number of pages. That scaling option can override manual breaks. Also check the active print area and inspect the sheet in Page Break Preview and Print Preview.

Can I put a page break between two rows?
Yes. Select the row that should start the next page. The break is placed above that row, so the preceding row remains at the bottom of the previous page if the layout permits.

How do I make the column headings repeat after a page break?
Use Page Layout > Print Titles and set the rows to repeat at the top. A manual break controls the page boundary; it does not repeat heading rows by itself.

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

More in Errors & fixes

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

Spotted an error in this guide? Let us know.