Microsoft Excel Insert Page Break: A Practical Guide

To insert a page break in Microsoft Excel for Microsoft 365 on Windows, select the cell below and to the right of where you want the break, then choose Page Layout > Breaks > Insert Page Break. Excel adds a horizontal break above the selected row and a vertical break to the left of the selected column; select a whole row or column if you want only one kind of break.

How page breaks work in Excel

Page breaks divide a worksheet into separate pages for printing or saving as a PDF. Excel creates automatic breaks based on the worksheet’s content, paper size, orientation, margins, scaling, and available printer settings. These automatic breaks can shift when you change any of those settings, so a table that fits on one page today might split differently after you adjust its layout.

A manual page break tells Excel where you want a page to end, or where the next page should begin. It gives you more control over the printed layout, but it does not change the worksheet data or insert a blank row. A break is a print-layout instruction: it affects where Excel divides the printout, not how cells appear in the normal worksheet grid.

Horizontal breaks separate rows, while vertical breaks separate columns. A worksheet can have both. For example, a long sales report might need one page for each region vertically, with a new page after each region’s final row. A wide report might also need a vertical break between its detailed columns and supplementary notes. Keep in mind that breaks divide the print area into pages; they do not automatically repeat column headings on each page.

Insert a horizontal or vertical page break

Open the worksheet you plan to print and select the cell at the point where the next page should begin. For a horizontal break, select a cell in the row that should start the next page. For a vertical break, select a cell in the column that should start the next page.
On the ribbon, choose Page Layout > Breaks > Insert Page Break.
Check the result in View > Page Break Preview. Adjust the break or print settings if Excel divides the content differently than you intended.
Use File > Print to inspect the page preview before printing or exporting.

For a row-only break, select the row immediately below the desired page ending, then insert the break. For a column-only break, select the column immediately to the right of the desired page ending. Selecting a single cell can create both a horizontal and a vertical break at once. For example, selecting cell C25 places a horizontal break above row 25 and a vertical break to the left of column C. If you want only one direction, selecting the entire row or column avoids adding the other break unintentionally.

A break cannot create a useful split before the first row or column of the printed content, because there is no preceding material to place on a separate page. If the selection appears to have no effect, check whether it is at the edge of the print area, whether the sheet is scaled to fit, and whether you are working in Excel for the web rather than the desktop application.

Use Page Break Preview to see and adjust breaks

Page Break Preview is the clearest way to understand how Excel will divide a worksheet. On Windows, choose View > Page Break Preview. Excel displays page boundaries and labels the print pages. Automatic breaks are generally shown as dashed lines and manual breaks as solid lines. The exact appearance can vary with the current view and Excel version, but the preview makes it easier to distinguish fixed breaks from Excel’s automatic divisions.

You can often drag a break line in this view to change where a page ends. Moving a horizontal break changes the rows included on neighboring pages; moving a vertical break changes the columns. If you drag an automatic break, Excel may turn it into a manual break. This is useful for a report that needs a particular section to stay together, but it also means the layout may need attention later if the data or paper setup changes.

To return to the standard worksheet view, choose View > Normal. Excel may also show page-break indicators in Normal view after you have used print preview. These lines do not affect data entry or formulas. If the indicators are distracting, you can change their display in Excel’s advanced options for the current worksheet, but doing so only hides the guides; it does not remove the breaks.

Remove or reset page breaks

To remove an individual manual break, select a cell in the row or column where the break is located, then choose Page Layout > Breaks > Remove Page Break. For a horizontal break, select a cell in the row immediately below it; for a vertical break, select a cell in the column immediately to its right. Check Page Break Preview afterward to confirm that the intended boundary is gone.

If you have added several breaks and want Excel to rebuild the layout from scratch, choose Page Layout > Breaks > Reset All Page Breaks. This removes manual page breaks from the worksheet and returns the layout to automatic breaks. It does not clear cell contents, formatting, or formulas. Because resetting affects the whole sheet’s manual breaks, use it only when you are comfortable recreating any intentional divisions.

Removing a manual break does not guarantee that two sections will print on the same page. Excel may place an automatic break at the same or a nearby position based on the paper and scaling settings. If the page count or split still looks wrong, inspect the print preview and review the settings that determine how much content fits on each sheet.

Make breaks work with print settings

Page breaks are only one part of print layout. Before adding many manual breaks, check the paper and page settings that affect the available space. On the Page Layout tab, Orientation switches between portrait and landscape, Size selects the paper size, and Margins controls the printable area. A wider paper size or landscape orientation may keep related columns together without needing a vertical break.

Scaling is especially important. The Scale to Fit controls on the Page Layout tab can shrink a worksheet to a specified number of pages wide or tall. When the sheet is set to fit a particular number of pages, Excel may disregard manual page breaks. If you need breaks to determine specific page boundaries, avoid forcing the entire sheet to fit a page count; use a percentage scale or automatic scaling instead, then review the preview.

Other layout tools solve different problems. To print selected cells only, choose Page Layout > Print Area > Set Print Area. To repeat a header row or left-hand columns on every printed page, use Page Layout > Print Titles. A page break determines where a page ends; a print title repeats specified headings. For example, a report with a new page for each department may still need its column labels repeated on every page so readers can interpret the figures.

Common page-break problems and fixes

The break does not appear where expected: Confirm that you selected the row below or column to the right of the intended boundary. Then check for a print area or scaling setting that changes the effective layout.
Everything shrinks onto one page: Check the Scale to Fit settings. A fit-to-page choice can reduce the worksheet dramatically and may prevent manual breaks from controlling the result.
A page contains only a few columns or rows: Look for an accidental vertical or horizontal break. In Page Break Preview, remove or drag the boundary, or use Reset All Page Breaks if you want to start over.
The preview changes after changing printers: Excel’s automatic page divisions can depend on printer and paper settings. Recheck File > Print after selecting the printer or PDF option you intend to use.
Headings vanish on later pages: A break does not repeat headings. Set repeating rows or columns with Page Layout > Print Titles instead.

One common misconception is that inserting a page break always adds exactly one page. It does not. A break marks a division, but the number of printed pages also depends on the print area, other breaks, page dimensions, and scaling. A worksheet that is both very long and very wide may span multiple pages in each direction, producing a grid of pages rather than a single sequence. Review every page in the print preview for a large or complex worksheet.

Excel for Mac and Excel for the web

In Excel for Mac, the desktop ribbon provides page-break controls on the Page Layout tab, including Breaks and its insert, remove, and reset options. The exact ribbon presentation can vary slightly by Mac version or window size, but the page-break commands serve the same purpose. Mac users can use Command+P to open the print dialog; on Windows, the corresponding shortcut is Ctrl+P.

Excel for the web has more limited print-layout controls than the desktop applications. If you need to insert, move, or carefully manage manual page breaks, open the workbook in the Excel desktop app and use its Page Layout and Page Break Preview tools. You can still use the web version for many editing tasks, but do not assume that a desktop workbook’s page divisions can be fully adjusted there.

Shortcuts are less dependable for this task because the ribbon key tips and available commands can vary by version, platform, and keyboard layout. The visible ribbon path is the clearest method to follow. If you use a Mac or work in a localized version of Excel, look for the equivalent Page Layout and Breaks commands rather than relying on a Windows key sequence.

Frequently Asked Questions

How do I insert a page break in Excel?
Select the cell below and to the right of the intended break, then choose Page Layout > Breaks > Insert Page Break. Excel adds a horizontal break above the selected row and a vertical break to the left of the selected column.

How do I insert only a horizontal page break?
Select the row immediately below where the new page should begin, then choose Page Layout > Breaks > Insert Page Break. Selecting the entire row helps ensure you do not add a vertical break as well.

How do I remove a page break in Excel?
Select a cell in the row below a horizontal break or the column to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. Choose Reset All Page Breaks to remove all manual breaks from the worksheet.

Why is Excel ignoring my manual page breaks?
A fit-to-page scaling setting can override manual breaks. Check the Scale to Fit controls on the Page Layout tab and review the print preview. Printer, paper size, margins, and the print area can also affect where the pages divide.

Can I insert page breaks in Excel for the web?
For reliable control of manual page breaks, use Excel for Microsoft 365 on Windows or the desktop version for Mac. Open the workbook in the desktop app to insert, move, or reset breaks and inspect the result in Page Break Preview.

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.