Microsoft Excel Page Breaks: How to Insert and Fix Them

A page break in Microsoft Excel marks where printed output moves to a new page. In Excel for Microsoft 365 on Windows, select the row below or column to the right of the desired break, then choose Page Layout > Breaks > Insert Page Break; use View > Page Break Preview to inspect and adjust the result.

What an Excel page break does

Excel worksheets can extend far beyond the dimensions of a printed page. When you print, Excel divides the selected worksheet or print area into pages according to the paper size, orientation, margins, scaling, and the amount of data. A page break is the boundary between two of those printed pages. It affects print layout; it does not insert a blank row or column, change cell contents, or divide the worksheet itself.

Excel creates automatic page breaks to fit a worksheet onto paper. You can also add manual page breaks to control where a particular row or column begins on a new page. For example, a monthly report might have a summary section followed by detailed transactions. A manual horizontal break can make the transaction table start on a fresh page rather than splitting the summary across two sheets of paper.

Page breaks are worksheet-specific. A break set on one sheet does not automatically apply to other sheets in the workbook. Also, a break that looks sensible on screen may move after a change to paper size, margins, print area, or scaling, so check the print preview before printing or exporting to PDF.

Insert a horizontal or vertical page break

On Windows, first select the row or column that should follow the break. Excel places a horizontal break above the selected row or a vertical break to the left of the selected column. Then use the Breaks menu:

To start a new printed page above a particular row, select that row. For instance, select row 25 to make row 25 the first row on the next page.
To start a new printed page to the left of a particular column, select that column. Select column G to make column G begin on the next page to the right.
Choose Page Layout > Breaks > Insert Page Break.
Open Page Break Preview to check where Excel placed the boundary and whether the result divides the data appropriately.

You can select a cell when you want a horizontal and vertical break at once: Excel inserts a break above the selected cell and another to its left. The selected cell therefore begins a new printed page. This can be useful for a report with separate groups arranged both down rows and across columns, but it can also create many small pages. Inspect the preview after using this method.

In Excel for Mac, the Page Layout tab also provides page-break controls, though the ribbon arrangement can differ slightly by release. Excel for the web does not offer the same desktop controls for inserting manual breaks; open the workbook in the desktop app when you need to place or fine-tune them. There is no need to add blank rows or columns as a substitute: blank space changes the worksheet layout, while a page break controls printing.

View, move, and understand breaks

Choose View > Page Break Preview to see the worksheet divided into printable pages. The pages are marked with blue boundaries and numbered in the preview. Automatic breaks generally appear as dotted lines, while manually inserted breaks appear as solid lines. This distinction helps identify whether Excel chose a boundary or someone set it explicitly.

In Page Break Preview, you can drag a blue boundary to change where a page ends. Dragging a boundary changes the print pagination; it does not move the cells or modify their values. If a page boundary refuses to land where expected, scaling settings may be controlling the layout. Switch back to Normal view with View > Normal when you have finished adjusting the print layout.

Another way to inspect the outcome is File > Print, which opens print preview. This view is useful for checking what the printer or PDF output will contain, including page order, margins, and blank pages. Page Break Preview is better for moving boundaries; print preview is better for reviewing the final pages as a reader will see them.

Remove a break or reset the worksheet

To remove one 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. If the break is both horizontal and vertical, select the cell immediately below and to the right of their intersection before choosing the remove command. The command may be unavailable when the selection does not line up with a manual break.

To clear manual breaks across the current worksheet, choose Page Layout > Breaks > Reset All Page Breaks. This removes the manual boundaries and lets Excel recalculate automatic breaks. It does not clear cell data. Resetting is useful when a sheet has accumulated hard-to-track breaks, but it also discards intentional pagination, so use it only when you are prepared to lay out the pages again.

Removing a manual break does not necessarily make a dotted boundary disappear. Excel still needs automatic breaks to divide the sheet into pages. If you want fewer pages, adjust the printable area, paper orientation, margins, or scaling rather than repeatedly removing automatic boundaries.

How print settings affect page breaks

Page breaks cannot be planned independently of print settings. A worksheet that fits across one page in landscape orientation may span several pages in portrait orientation. Changing from letter to A4 paper, widening margins, adding columns, or using a larger font can all shift the automatic boundaries. When Excel recalculates pagination, manually placed breaks may also appear in different positions relative to the final printed pages.

Check these settings before inserting a series of manual breaks:

Print area: Page Layout > Print Area > Set Print Area limits what Excel prints. If the intended rows or columns are outside that area, a break there may not affect the output you expect.
Orientation and paper size: Use Page Layout > Orientation and Page Layout > Size to choose the paper layout. Landscape often gives a wide table more room, but can use more pages vertically.
Margins: Page Layout > Margins changes the space available for cell content. Narrower margins can fit more on a page, subject to printer limits.
Scaling: The Scale to Fit controls on Page Layout can shrink a sheet to fit a chosen number of pages. In the Page Setup scaling options, choosing Fit to can cause Excel to ignore manual page breaks. If precise manual breaks matter, use Adjust to scaling or return the width and height settings to Automatic, then review the preview.
Repeated headings: If each printed page needs column labels, use Page Layout > Print Titles to repeat rows or columns. A page break does not repeat headings by itself.

For example, imagine a 12-column sales table that prints on two pages across. Setting its width to fit on one page may shrink the text considerably, while landscape orientation and narrower margins might preserve legibility and still reduce the page count. Choose based on whether readability or compactness matters more; then revisit the page breaks because the revised settings change pagination.

Fix common page-break problems

A break appears in the wrong place: Open Page Break Preview and check the solid and dotted lines. Confirm the selected print area, paper orientation, and scaling first. Then drag the manual boundary or remove and reinsert it at the intended row or column. A change in column width can be enough to shift automatic boundaries elsewhere on the sheet.

Excel ignores a manual break: Check whether the sheet is set to fit a specified number of pages. Fit to scaling can override manually inserted breaks. Change the scaling to Adjust to or set the Scale to Fit width and height to Automatic, then inspect Page Break Preview again.

The printout has an unexpected blank page: A print area that includes formatted but apparently empty cells, a stray value far down or to the right, or an unintended manual break can expand the output. Review the print preview one page at a time, check Page Layout > Print Area, and look for content or formatting beyond the intended report. Resetting manual breaks may help, but it will not correct an oversized print area by itself.

A table is split across pages: Insert a horizontal break before the row that should start the next page, or adjust scaling and margins to fit more rows. For a long table, avoid forcing every group onto its own page if doing so creates many nearly empty pages. If headings need to appear on each page, set print titles separately.

The blue lines are distracting in the worksheet: Return to View > Normal. This changes the display mode, not the print layout. It does not remove manual breaks or change what will print.

Manual breaks versus automatic breaks

Automatic breaks are Excel’s response to the available printable area. They change as the sheet, printer settings, or page setup changes. Manual breaks express a deliberate choice, such as keeping a new department’s section at the top of a page. They are useful when the order and grouping of printed material matter, but they can become inconvenient if the worksheet changes frequently.

For a small, stable report, manual breaks can make the output predictable. For a regularly updated data table, automatic pagination plus repeated title rows may be easier to maintain. A fixed manual break that works for 40 records can leave a large gap when the report grows to 45 records. In that case, review the page preview after refreshes or changes rather than assuming last month’s layout still applies.

Frequently Asked Questions

How do I insert a page break in Excel?

Select the row that should begin below the horizontal break, or the column that should begin to the right of a vertical break. Choose Page Layout > Breaks > Insert Page Break. Use View > Page Break Preview to confirm the result.

How do I remove all page breaks in Excel?

On the worksheet you want to change, choose Page Layout > Breaks > Reset All Page Breaks. This clears manual breaks and allows Excel to create automatic ones again; it does not delete worksheet data.

Why is the page break dotted in Excel?

A dotted line usually represents an automatic page break that Excel calculated from the current print settings. A solid blue line in Page Break Preview generally indicates a manually inserted break. Both mark print-page boundaries, but only the manual one represents a deliberate break setting.

Can I insert page breaks in Excel for the web?

Excel for the web does not provide the desktop version’s full manual page-break controls. Open the workbook in Excel for Microsoft 365 on Windows or Excel for Mac to insert, remove, and position manual breaks, then check the print layout.

Why does Excel ignore my manual page breaks?

A common cause is Fit to scaling, which can take precedence over manual breaks. In Page Layout, check Scale to Fit or open Page Setup and change the scaling choice to Adjust to; then return to Page Break Preview to review the pagination.

A practical way to plan a printed worksheet

Start by setting the intended print area and paper layout, then decide whether the sheet should fit a particular width or remain at a readable scale. Add page breaks only at meaningful boundaries, such as between report sections, and use print titles when headings need to repeat. Finally, inspect every page in File > Print. This order avoids placing breaks around a layout that later changes and helps catch clipped columns, empty pages, or headings that appear only once.

Excel page breaks are therefore best understood as print-layout instructions, not worksheet separators. Automatic breaks handle ordinary pagination; manual breaks give control where page boundaries carry meaning. Combining the right break type with sensible scaling and a final preview usually produces a more dependable printout than forcing the sheet onto a chosen number of pages without checking its readability.

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.