Excel Page Break Command: Insert, Move, and Remove

In Excel for Microsoft 365 on Windows, use Page Layout > Breaks > Insert Page Break to add a manual page break. Select the row below a horizontal break or the column to the right of a vertical break first; to add both at a cell boundary, select a cell and insert the break.

What the Excel page break command does

A page break tells Excel where to divide a worksheet when it is printed or saved as a paginated format such as PDF. It changes the division of printed pages, not the worksheet’s cells: it does not insert a row or column, alter values, or change what appears in the normal on-screen grid.

Excel creates automatic page breaks based on the paper size, margins, orientation, scaling, and the amount of printable content. A manual break gives you more control over that division. For example, if a monthly report’s final total should stay with its detail rows, you can place a break after the report instead of letting Excel split it across two pages.

Breaks apply to the active worksheet. Adding one on a sales sheet does not set the page breaks on a separate chart or summary sheet. They matter when you print or preview output; they do not create a permanent boundary in the worksheet itself.

How horizontal and vertical breaks work

A horizontal page break starts a new printed page below the row where you place it. A vertical page break starts a new page to the right of the chosen column. If you select a cell and choose Insert Page Break, Excel can add both: one above the selected cell’s row and one to the left of its column. That behavior is useful when you want to define a page’s lower and right edges together, but can be surprising if you intended only one break.

For a single-direction break, select the whole row immediately below where the new page should begin, or the whole column immediately to the right of where the next page should begin. Then use the command. For example, to make row 26 the first row on a new printed page, select row 26 and insert a break. To make column G start a new page, select column G and insert one.

The selection marks the boundary; Excel does not move the selected row or column. If the resulting split is not where you expect, check the selected row or column and inspect the worksheet in Page Break Preview.

Insert a page break step by step

Open the worksheet you want to print and select the row below the intended horizontal split, the column to the right of the intended vertical split, or a cell if you want breaks in both directions.
Choose Page Layout > Breaks > Insert Page Break.
Choose View > Page Break Preview to check how the worksheet is divided into pages.
Open Print Preview with File > Print and check the pages before printing or saving to PDF.

Use the command when a particular boundary matters, rather than adding breaks after every few rows by habit. A break can help keep a heading with the data below it, or place a summary on a new page. But too many forced boundaries can create extra, sparsely filled pages. Check the full print preview after making a change, especially if the worksheet spans several pages in both directions.

Preview and move page breaks

Page Break Preview provides a visual view of the printed pages. Choose View > Page Break Preview. Page boundaries appear as lines, and the page areas are marked with page numbers. Automatic breaks typically appear as dashed lines and manual breaks as solid lines. The exact appearance can vary with the view and Excel version, so use the preview and print output—not line style alone—to confirm the layout.

In Page Break Preview, you can often reposition a break by dragging its boundary to a different row or column. This is a convenient way to adjust a split when you can see the page regions. Dragging a boundary changes the print pagination; it does not move worksheet data. If a boundary will not move as expected, scaling or the available printable area may be affecting the layout.

To return to the regular worksheet view, choose View > Normal. Page breaks may still be shown as lines in Normal view after you have viewed or printed the sheet. Those indicators do not mean the cells have been divided or changed; they show where Excel expects pages to end.

Remove one break or reset all breaks

To remove a manual break, select the row below a horizontal break or the column to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. A cell selection at a crossing may relate to breaks in both directions, so select the relevant row or column when you want to target one boundary. Check Page Break Preview afterward to confirm the result.

If the worksheet has several manual breaks and you want to start over, choose Page Layout > Breaks > Reset All Page Breaks. This removes the manually set breaks on the active worksheet and lets Excel paginate the sheet automatically again. It does not erase worksheet content or clear page settings such as margins and orientation.

Reset All Page Breaks is broader than removing one break. Before using it on a carefully formatted report, consider whether you will need to restore several custom boundaries. You can also undo a recent change with the usual Undo command, but previewing the sheet first is a useful way to identify exactly which break needs attention.

Page breaks, print areas, and scaling are different

A page break controls where Excel divides printable content. A print area controls which cells are included in the printout. To set one, select the cells and use Page Layout > Print Area > Set Print Area. These settings solve different problems: a print area can exclude notes or unused columns, while a break can keep included rows or columns together on separate pages.

Scaling controls how much of the selected print content is reduced or enlarged to fit. The Scale to Fit options on the Page Layout tab can fit a sheet to a chosen number of pages wide or tall. If you tell Excel to fit a broad report to one page wide, it may shrink the printout substantially. If you choose a fit-to-pages setting, the result may not follow manual breaks as you expect, so check Print Preview after changing scaling.

For a wide table, setting the page orientation to Landscape or choosing a sensible paper size may improve readability more than forcing many vertical breaks. These options are available from the Page Layout tab, including Orientation and Size. A practical order is to set the print area, paper size, orientation, and scaling first, then add manual breaks where a specific page boundary is still needed.

Common page break problems

The break appears in the wrong place: Remember that a selected row gets a horizontal break above it, while a selected column gets a vertical break to its left. If you selected a cell, Excel may have added both directions.
The printout does not match the worksheet view: Normal view is not a page-by-page print preview. Use Page Break Preview and File > Print, where margins, paper size, scaling, and printer settings affect the result.
The page is unexpectedly blank or nearly empty: A print area may include extra cells, or manual breaks may be creating small page regions. Review the print area and remove unnecessary breaks.
Text is too small after adjusting the layout: A fit-to-pages setting can reduce a large range to fit. Consider Landscape orientation, a larger paper size, fewer columns on each page, or a wider page layout rather than forcing everything onto one page.
The command is unavailable: Confirm that a worksheet is active and that Excel is not in cell-editing mode. Worksheet protection can also restrict changes; if you are authorized to edit the sheet, check whether it must be unprotected first.

A frequent misconception is that a page break command changes where a row appears in the worksheet. It does not. The same row remains in the same place on screen; only the printed pagination changes. Likewise, hiding a row or setting a print area is not the same as inserting a page break.

Excel on Mac and Excel for the web

In Excel for Microsoft 365 on Mac, use the Page Layout tab and its Breaks controls to insert, remove, or reset breaks. The labels and ribbon arrangement can differ slightly from Windows, but the selection logic is the same: select the row below a horizontal boundary or the column to the right of a vertical boundary. Use the View controls to inspect page breaks, then check the print preview.

Excel for the web has fewer page-layout editing capabilities than the desktop app. If you need to create or precisely adjust manual page breaks and do not see the required controls, open the workbook in the desktop version of Excel, make the changes there, and then save it. A workbook viewed in a browser may not offer the same detailed page-break preview and editing experience as Excel for Windows or Mac.

Frequently Asked Questions

Where is the page break command in Excel?
On Windows, go to Page Layout > Breaks, then choose Insert Page Break, Remove Page Break, or Reset All Page Breaks.

How do I insert a horizontal page break in Excel?
Select the row immediately below the point where the new page should start, then choose Page Layout > Breaks > Insert Page Break. Check the position in Page Break Preview.

How do I insert a vertical page break?
Select the column immediately to the right of the intended boundary and choose Page Layout > Breaks > Insert Page Break. Excel begins the next printed page at that column.

How do I remove all manual page breaks?
On the active worksheet, choose Page Layout > Breaks > Reset All Page Breaks. Excel returns to automatic pagination; your cells and other page settings remain in place.

Why does my page break not affect the printout?
Check the print preview, scaling, and print area. A fit-to-pages setting can change pagination, and an incorrect print area can exclude the cells you expected to print. Adjust those settings and review the preview again.

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.