Excel Page Breaks for Printing: How to Add Them Easily

To add a page break in Excel for Microsoft 365 on Windows, select the row below where the new page should start, then choose Page Layout > Breaks > Insert Page Break. To start a new printed column, select the column to the right of the desired boundary and use the same command; selecting a cell inserts both a horizontal break above it and a vertical break to its left.

What an Excel page break does

A page break tells Excel where to divide a worksheet when it is printed or saved as a PDF. Without manual breaks, Excel calculates automatic breaks from the printable area, paper size, margins, orientation, and scaling settings. Those automatic boundaries may divide a table in an awkward place, such as putting a total on a separate page or splitting a group of related columns.

A manual break lets you choose a more useful boundary. For example, if a monthly report has a summary in rows 1 through 25 and detail below it, a break above row 26 can make the detail begin on a fresh page. It does not insert a blank row, change the worksheet’s data, or move cells. It affects the printed page layout, not the way the sheet appears during ordinary editing.

Excel can break a sheet horizontally, between rows, and vertically, between columns. A worksheet can have multiple breaks in either direction, creating a grid of printed pages. A break is useful when the natural page divisions do not match the structure of the information, but it is best to check the print preview after setting one.

Insert a horizontal or vertical break

Use the row or column headers to position the break precisely. These steps apply to Excel for Microsoft 365 on Windows:

Open the worksheet you want to print and select the row below the point where the next page should begin. To split pages vertically, select the column to the right of the intended boundary.
Choose Page Layout > Breaks > Insert Page Break.
Open View > Page Break Preview to check where Excel has placed the break and how the resulting pages are arranged.
If the layout is not right, drag a break in Page Break Preview or remove it and insert it at a different row or column.

For instance, to make row 31 the first row on a new page, select row 31 before inserting the break. The boundary is above the selected row. To make column G the first column on a new page, select column G; the boundary is to its left. If you select a cell such as G31 rather than an entire row or column, Excel inserts a horizontal break above row 31 and a vertical break to the left of column G. That can be helpful when both dimensions need controlling, but it may create more pages than intended.

Before inserting breaks, consider whether the print area is already limited to the intended cells. A break in a region outside the print area may not affect the pages you expect. Set or review it with Page Layout > Print Area. Also, page breaks are worksheet-specific, so check each sheet that will be printed.

Preview and adjust page boundaries

Page Break Preview is the clearest way to see the print divisions on the sheet. Choose View > Page Break Preview. Excel displays the printable pages and their boundaries; manual breaks appear as solid blue lines and automatic breaks as dashed blue lines. The page labels help show how the worksheet has been divided. To return to the usual editing view, choose View > Normal.

You can drag a boundary in Page Break Preview to change where the page ends. Moving a boundary can change how much content fits on a page, and moving an automatic boundary makes the placement manual. After dragging, look at the page labels and inspect every affected page: one adjustment can shift content onto additional pages or change the division in another part of the sheet.

For a final check, choose File > Print or press Ctrl+P on Windows. The print preview shows the output using the current printer and page settings. Check for clipped columns, nearly empty pages, headings left behind, and totals separated from the figures they summarize. Print preview is also a useful way to confirm that the selected print area and the page breaks work together as intended.

Plan breaks alongside print settings

A page break cannot compensate for every layout problem. If a sheet is just slightly too wide, changing orientation from portrait to landscape may avoid splitting a small table across two pages. Page Layout > Orientation provides Portrait and Landscape. Page Layout > Margins offers margin choices, while Page Layout > Size lets you select a paper size supported by the setup. The paper loaded in the printer should match the selected size.

Scaling is especially important. Excel can shrink a sheet to fit a specified number of pages using the scaling controls on the Page Layout tab, including the Fit to options. If Fit to is used to scale the worksheet to a set number of pages, Excel ignores manual page breaks. So, if a break appears ineffective, inspect the scaling setting before repeatedly inserting or moving breaks. Choosing a percentage scale instead, or adjusting the fit settings, may let manual breaks control the divisions again.

For a wide report, setting the sheet to fit one page wide but allowing multiple pages tall can keep the columns together while preserving readable row height. For a short table, fitting everything onto one page may be convenient, but it can shrink text until it is difficult to read. Preview the actual result rather than assuming one page is always better.

Repeated headings solve a different problem from page breaks. If column labels need to appear at the top of each printed page, use Page Layout > Print Titles and specify rows to repeat at the top. A manual break determines where a page starts; repeating title rows carries selected headings onto multiple pages. Using both can make a long list easier to follow.

Remove or reset page breaks

To remove one manual break, select the row immediately below its horizontal boundary or the column immediately to the right of its vertical boundary. Then choose Page Layout > Breaks > Remove Page Break. If a cell sits at the intersection of a horizontal and vertical break, selecting it can target the break or breaks associated with that position; use Page Break Preview to verify what changed.

To clear manual breaks across the worksheet, choose Page Layout > Breaks > Reset All Page Breaks. This removes the manual divisions and lets Excel calculate automatic page breaks again. It does not delete worksheet data. Resetting is useful when a sheet has accumulated many adjustments and it is simpler to rebuild the layout, but it also removes useful manual boundaries, so inspect the output afterward.

Removing a manual break does not guarantee that the worksheet will print as one page. Excel may still place automatic breaks wherever the current paper and scaling settings require them. Likewise, hiding a row or column, changing the print area, or changing the paper size can alter the printed layout without removing the manual break itself.

Common page-break problems

The break seems to do nothing: Check whether the sheet is set to Fit to a fixed number of pages. That scaling mode can cause Excel to ignore manual breaks. Also confirm that the break is inside the print area and that you are viewing the correct worksheet.
A page is almost blank: A manual break may be forcing a short section onto its own page. In Page Break Preview, move or remove the break, then check the print preview. A large print area or an unusually wide or tall row or column can also affect the division.
Columns are split across pages: Try landscape orientation, narrower margins, or a fit-to-page-width setting. If the columns still need separate pages, add a vertical break deliberately and check that readers can identify the repeated headings.
Printed pages differ from the worksheet view: Normal view is for editing, not an exact print-layout display. Use Page Break Preview and File > Print to see the page divisions and output settings that will govern printing.
Blue lines are confusing: In Page Break Preview, solid blue lines indicate manual boundaries and dashed blue lines indicate automatic ones. A boundary can move when content, print settings, or paper size changes, so recheck the preview after layout edits.

Windows, Mac, and Excel for the web

The steps above use the Windows ribbon in Microsoft 365. Excel for Mac also provides page-break controls on the Page Layout tab, including the Breaks menu, though ribbon placement and some dialog details can differ by version. On a Mac, use Command+P to open printing rather than the Windows Ctrl+P shortcut. If the menu is not visible, check the Page Layout tab and the current worksheet view.

Excel for the web has fewer print-layout controls than the desktop application, and the manual-break workflow and Page Break Preview available in desktop Excel may not be available in the same way. For precise manual page divisions, open the workbook in the desktop version of Excel, set and preview the breaks there, and then print or save the result as a PDF.

Frequently Asked Questions

How do I insert a page break after a specific row in Excel?

Select the row immediately below the place where the new page should start, then choose Page Layout > Breaks > Insert Page Break. For example, select row 20 to make the next page start with row 20.

Can I add a page break between columns?

Yes. Select the column to the right of the desired division and choose Page Layout > Breaks > Insert Page Break. The new printed page begins with the selected column.

Why are my manual page breaks ignored?

A common cause is scaling the worksheet with Fit to a specified number of pages. Excel ignores manual breaks in that mode. Review the scaling controls on the Page Layout tab, and then check the print area and print preview.

How do I remove all page breaks in an Excel worksheet?

Choose Page Layout > Breaks > Reset All Page Breaks. Excel clears the manual breaks on that worksheet and recalculates automatic divisions; it does not remove cell contents.

Do page breaks change the worksheet or its data?

No. Page breaks control how a worksheet is divided for printing or PDF output. They do not insert rows, alter values, or rearrange the cells on the sheet.

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.