Can You Insert a Page Break in Excel? Yes, Here’s How

Can You Insert a Page Break in Excel? Yes, Here's How

Yes. In Excel for Microsoft 365 on Windows, select the row below or the column to the right of where you want the break, then choose Page Layout > Breaks > Insert Page Break. You can also place and adjust breaks in Page Break Preview, then check the result in Print Preview before printing.

What a Page Break Does

A page break tells Excel where to divide worksheet content across printed pages. It affects the printed or exported page layout, not the way rows and columns are arranged while you edit the sheet. Adding a break does not insert a blank worksheet row, move cells, or change the data.

Excel creates automatic page breaks when it lays out a worksheet for printing. Their positions depend on factors such as paper size, page orientation, margins, scaling, printer settings, and the amount of printable content. Manual page breaks let you override that automatic layout—for example, to keep a section heading with the rows that follow it or to start a new department on a fresh page.

A break applies to the worksheet you are working on. It is a print-layout instruction, so it is useful when a sheet is designed to be read on paper or in a paginated PDF. It is not a substitute for splitting data into separate worksheets or creating a new worksheet page inside the grid.

Insert a Page Break in Excel for Windows

Use the row or column selection that matches the direction of the break. The selected position determines where Excel starts the next printed page.

Open the worksheet and select the row immediately below the place where the next page should begin. For example, select row 21 to start a new page above row 21.
To start a new page in a neighboring set of columns, select the column immediately to the right of the desired break. For example, select column F to place a vertical break before column F.
Choose Page Layout > Breaks > Insert Page Break.
Open Page Break Preview or Print Preview to confirm that the break falls where you intended.

If you select a cell rather than a whole row or column, Excel can insert both a horizontal break above that cell’s row and a vertical break to the left of its column. For instance, selecting E21 and inserting a break can divide the page above row 21 and before column E. Use a whole row or column when you only want one direction of break, so you do not unintentionally split the printout both ways.

Excel may disable the command in circumstances where a manual break cannot be added, such as when the sheet is in Page Layout view. Switch to Normal view or Page Break Preview and try again. If the worksheet is protected, protection settings can also prevent changes to its layout.

Choose the Right Break Position

Before inserting breaks, consider how a reader will follow the printed pages. A page that ends halfway through a table, separates a heading from its explanation, or leaves only a few rows on a final page can be harder to use. A manual break is most helpful when it creates a clear boundary, such as between monthly sections or between a summary and supporting detail.

For example, if a report has a title and column headings in rows 1–5, followed by transaction records, you might start a new page before a clearly labeled section rather than interrupting a block of related records. If the table continues across pages, repeat its heading row using Page Layout > Print Titles. A page break determines where a page ends; Print Titles determines which row or column labels repeat on each printed page. They solve different problems and can be used together.

Take account of the width of the sheet as well as its height. A horizontal break controls which rows appear on a page; a vertical break controls which columns appear together. If a wide report spans multiple pages from left to right, readers may have to match row labels across those pages. Landscape orientation, narrower margins, or scaling to fit the width may be a better solution than adding several vertical breaks.

View and Adjust Breaks in Page Break Preview

To see how Excel divides the sheet, choose View > Page Break Preview. This view shows page boundaries and page numbers over the worksheet. Manual breaks appear as solid blue lines, while automatic breaks are generally shown as dashed blue lines. The exact appearance can vary with the view and version, but the preview makes it easier to identify which boundaries you can control.

You can often adjust a break by dragging its blue line to another row or column boundary. This can be quicker than removing a break and inserting a new one, especially when you are refining a print layout. Dragging changes the page division; it does not move worksheet data. If the desired placement is difficult to see, zoom in or use the row and column headings to locate the boundary accurately.

Page Break Preview is a layout aid, not a guarantee that every printer will produce identical output. Print Preview is still worth checking because the selected printer, paper size, and print settings influence the final result. After reviewing the pages, return to View > Normal to work with the usual worksheet grid.

How Breaks Interact With Print Settings

Manual breaks work alongside print settings, and some settings can make their effects less obvious. In Page Layout, check Size, Orientation, and Margins if Excel is creating an awkward number of pages. The selected paper size matters: a layout prepared for letter paper may break differently when printed on A4 paper. Printer drivers can also report different printable areas.

Scaling is especially important. Under Page Layout, the Scale to Fit options can shrink a sheet to fit a chosen number of pages wide or tall. When you force a worksheet onto a fixed number of pages, Excel may adjust the scaling to meet that requirement, so a manual break may not produce the page division you expected. If the output becomes too small to read, avoid forcing the entire sheet onto one page; fit it to one page wide while allowing it to use multiple pages tall, or print selected sections separately.

Also check whether a print area is set. A print area limits which cells are included in the output, so a break outside that area may not appear in the printed pages. To define or change the area, select the cells and choose Page Layout > Print Area > Set Print Area. Check the preview afterward: it shows the pages Excel intends to print with the current settings.

Remove or Reset Page Breaks

If a break is in the wrong place, 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. You can also select the cell below and to the right of an intersection when you need to remove breaks in both directions. Check the preview afterward, because Excel may place automatic breaks in the same general area once the manual instruction is gone.

To clear manual page breaks from the worksheet, choose Page Layout > Breaks > Reset All Page Breaks. This removes the manual adjustments and returns the sheet to automatic page-break placement. It does not erase cell contents or formatting. If the page layout still looks unusual after resetting, review scaling, the print area, paper size, and orientation rather than repeatedly adding and removing breaks.

Common Problems and What to Check

The printed page does not start where expected: Confirm that you selected the row below or column to the right of the intended boundary. Then inspect Page Break Preview and Print Preview.
The break seems to disappear: It may be hidden by the current view, or a print setting may be overriding the layout you expected. Switch to Page Break Preview and check scaling and the print area.
The page is mostly blank: A break may have been inserted too early, or the print area may include extra rows or columns. Remove the misplaced break and review the selected print area.
The report is too small: A fit-to-pages setting may be shrinking the whole sheet. Allow more pages or fit only the width instead of forcing both width and height.
Rows split in a confusing place: Move the break to a sensible boundary, or adjust the page setup so more of the related rows fit together. A break cannot make a long section fit on one page without changing the available space or scale.

When a layout seems inconsistent, change one setting at a time and revisit Print Preview. That makes it easier to see whether the cause is the break itself, scaling, the print area, or a printer and paper-size choice.

Excel on Mac and Excel for the Web

In Excel for Microsoft 365 on Mac, the desktop app also supports manual page breaks. Select the row below or column to the right of the intended boundary, then use the Page Layout tab’s Breaks controls to insert or remove a break. Ribbon labels and the arrangement of controls can differ slightly by Mac version, so Page Break Preview is useful for checking the result. The Windows-specific ribbon path above should not be assumed to match every Mac build exactly.

Excel for the web has more limited page-break editing than the desktop application. If you need to insert, move, or reset manual breaks, open the workbook in the desktop version of Excel. You can still use the web app for many worksheet tasks, but complex print pagination is a reason to switch to desktop Excel and review the final output there.

Frequently Asked Questions

Can I insert a page break in Excel without printing?
Yes. You can set and preview breaks without sending anything to a printer. They affect how the worksheet is paginated for printing or PDF output, not the ordinary on-screen grid.

How do I insert a page break after a specific row?
Select the row immediately below the desired boundary, then choose Page Layout > Breaks > Insert Page Break. To begin the next page after row 20, for example, select row 21.

Can I insert both a horizontal and vertical page break at once?
Yes. Select a cell below and to the right of the intended crossing point, then insert the break. Excel can add a horizontal break above its row and a vertical break to the left of its column.

Why can’t I insert a page break in Excel?
Check that the worksheet is not in Page Layout view, that the sheet is not protected in a way that blocks layout changes, and that you are using the desktop app. Excel for the web does not provide the same manual page-break editing controls.

How do I remove all manual page breaks?
Choose Page Layout > Breaks > Reset All Page Breaks. Excel then lays out the worksheet using automatic breaks, while leaving the worksheet’s data and cell formatting intact.

Final Check Before Printing

After placing breaks, review every page in Print Preview rather than checking only the first one. Confirm that headings and labels are understandable, no important columns are omitted, and the final page is not mostly empty. If the pagination is still awkward, adjust the print area, orientation, margins, or scaling before adding more manual breaks. A small number of deliberate breaks usually produces a clearer report than trying to control every page boundary individually.

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.