Excel Page Breaks: How to Insert, Remove, and Fix Them

An Excel page break determines where worksheet content moves onto the next printed page. In Microsoft Excel for Microsoft 365 on Windows, use Page Layout > Breaks to insert, remove, or reset breaks; use View > Page Break Preview to see and adjust where pages will split.

What an Excel page break does

A worksheet can be much larger than a printed page. Excel divides the printable portion of a sheet into pages, placing page breaks between rows or columns. A horizontal break starts a new page below a particular row; a vertical break starts a new page to the right of a particular column. Their purpose is to control printed or exported page boundaries, not to change the worksheet’s data or its on-screen layout in Normal view.

For example, imagine a monthly report with a summary in rows 1 through 20 and transaction details below. A horizontal break above row 21 can make the transaction section begin on a fresh printed page. If a table has columns A through H but the last two columns print on a separate page, a vertical break or changed print scaling may help keep related columns together.

Page breaks matter when you print a worksheet or create a PDF from Excel. They do not add blank rows, split cells, or alter formulas. If the printed result is awkward, the cause may be a page break, but it may instead be the paper size, margins, print area, or scaling setting.

Automatic and manual page breaks

Excel creates automatic page breaks based on what fits on the selected paper. The available space depends on factors such as paper size, page orientation, margins, column widths, row heights, and scaling. Automatic breaks can move when you change any of those settings. In Page Break Preview, automatic breaks generally appear as dashed lines, while manually inserted breaks appear as solid lines.

A manual page break is a boundary you add or move to control pagination. It can be useful when a heading should stay with its table, a new section should begin on a new page, or a group of columns should print together. Manual breaks do not guarantee a particular final result if you later change page setup or scaling; always check the print preview after making layout changes.

Excel can create several pages across and down a worksheet. A break is therefore not necessarily a single division of the whole sheet: a horizontal break can apply across the printed width, while vertical breaks divide the sheet into page-width sections. The resulting page order also depends on the print settings for how pages are numbered.

How to insert a page break

To add a break in Excel for Microsoft 365 on Windows, first select a cell at the boundary you want. Excel inserts the break above and to the left of the selected cell. That means selecting a cell in row 21 inserts a horizontal break above row 21; selecting a cell in column E inserts a vertical break to the left of column E. Selecting a cell away from the first row and first column can insert both types at once.

Choose the worksheet you want to print.
Select the cell below the row where a new page should begin, or to the right of the column where a new page should begin. To add both a horizontal and vertical break, select the cell below and to the right of their intersection.
Open Page Layout > Breaks > Insert Page Break.
Choose View > Page Break Preview or open File > Print to check the result.

You can also select a whole row or column before using the Breaks command. Selecting a row inserts a break above it; selecting a column inserts a break to its left. This is often easier when you know the precise row or column boundary. If the command is unavailable or a break does not appear as expected, check whether the sheet is protected and review the print scaling settings.

See and adjust breaks in Page Break Preview

Page Break Preview shows the worksheet divided into numbered print pages. Choose View > Page Break Preview on the ribbon. If Excel displays a message about adjusting page breaks, confirm it if you want to continue. The blue boundaries show where the pages end, and the page numbers help you understand the print order. To return to the usual worksheet display, choose View > Normal.

In Page Break Preview, you can drag a visible boundary to change the page division. Drag a horizontal line up or down to change which rows fit on a page; drag a vertical line left or right to change which columns fit. Moving an automatic boundary this way makes it a manual break. If the page still contains too much or too little content, examine scaling and margins rather than repeatedly dragging the line.

For a final check, use File > Print to open Print view and inspect the pages as they will be printed. On Windows, Ctrl+P opens the print screen; on Mac, use Command+P. Print view helps reveal problems that are easy to miss in the worksheet, such as a total on a separate page or a narrow column pushed onto its own sheet of paper.

Remove or reset page breaks

To remove one manual break, select a cell immediately below a horizontal break or immediately to its right of a vertical break. Then choose Page Layout > Breaks > Remove Page Break. The relevant boundary is removed, and Excel determines the automatic pagination again. In practice, the preview is the clearest way to confirm that you selected the intended boundary.

To clear manual breaks throughout the worksheet, choose Page Layout > Breaks > Reset All Page Breaks. This restores automatic page divisions for that sheet; it does not delete worksheet data. Resetting is useful when many manually adjusted boundaries have made the layout hard to manage. Afterward, inspect Page Break Preview and make only the manual adjustments you still need.

Removing a manual break does not necessarily make the worksheet fit onto one page. Excel may simply place an automatic break at a nearby boundary. If you want fewer pages, change the page setup or scaling, or adjust the print area and column widths. Those are separate controls from deleting a manual break.

Why page breaks appear in the wrong place

A page division that looks unexpected is often the result of a layout setting rather than a faulty break. Check these factors before rebuilding the sheet’s pagination:

Paper size: A worksheet laid out for Letter paper may paginate differently when the printer or page setup uses A4.
Orientation: Landscape gives the sheet more horizontal room, while Portrait gives it more vertical room.
Margins: Large margins reduce the printable area, so fewer rows or columns fit on each page.
Scaling: Fit-to-page settings can shrink content or change how it is divided. When scaling is changed, review the breaks again because the page layout may be recalculated.
Row heights and column widths: A tall row or unusually wide column can push other content onto another page.
Print area: If a print area is set, Excel prints that selected range rather than treating every used cell as part of the intended output.

To investigate, open Page Layout and review Orientation, Size, Margins, Scale to Fit, and Print Area. Then check File > Print. Printer drivers can also affect available paper sizes and printable margins, so a layout that looks correct on one printer may shift on another.

Page breaks, print areas, and scaling are different

These settings solve related but distinct problems. A page break chooses where one printed page ends and the next begins. A print area chooses which cells are included in the printout. Scaling changes the size or page count of the output. For instance, if a worksheet includes notes far to the right that should not print, set a print area rather than adding breaks to hide those columns.

To define a print area, select the cells you want, then choose Page Layout > Print Area > Set Print Area. To clear it, choose Page Layout > Print Area > Clear Print Area. To scale output, review the Scale to Fit controls on the Page Layout tab, or open the Page Setup dialog for more options. A setting to fit a sheet to a page can make small text difficult to read, so inspect the PDF or print preview before relying on it.

If the same column headings should appear on every page, use print titles rather than copying the headings manually or inserting extra breaks. Open the Page Setup dialog from the Page Layout tab, choose the Sheet tab, and specify rows to repeat at top or columns to repeat at left. Print titles repeat labels; page breaks determine where the next page starts. They work together but do not replace each other.

Practical layout choices before printing

Choose breaks based on what a reader needs to understand on each printed page. A page that ends halfway through a table may be acceptable if the column headings repeat, but a page with one stray column is usually hard to use. For a report with sections, begin a new section on a fresh page where that improves readability. For a wide data table, landscape orientation or a carefully chosen print area may be better than many narrow vertical pages.

Keep a section heading with at least the first rows of the section rather than leaving the heading alone at the bottom of a page.
Use repeated print titles when column labels need to be visible on subsequent pages.
Check that totals and explanatory notes are not separated from the data they describe.
Preview every page after changing paper size, orientation, scaling, or a print area.
Save the workbook after confirming the layout if the manual breaks are part of a recurring report.

Excel for Mac has comparable page layout and print controls, though ribbon details and dialog appearance can differ; use Command+P rather than the Windows Ctrl+P shortcut to open printing. Excel for the web has fewer page setup and print-layout controls than the desktop app. If you need precise manual page-break management, open the workbook in the desktop version of Excel.

Frequently Asked Questions

How do I show page breaks in Excel?
Choose View > Page Break Preview. Excel displays the page boundaries and page numbers for the active worksheet. Choose View > Normal to return to the usual worksheet view.

How do I insert a horizontal page break in Excel?
Select a cell in the row that should start the next printed page, then choose Page Layout > Breaks > Insert Page Break. Excel inserts the horizontal break above the selected row.

How do I remove a page break without deleting data?
Select a cell just below the horizontal break or just to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. To remove all manual breaks on the sheet, choose Reset All Page Breaks.

Why are my page breaks not showing in Excel?
Switch to View > Page Break Preview. If you are in Normal view, boundaries may not be obvious. Also check whether scaling, a print area, or the selected worksheet is affecting the pages you expect to see.

What is the difference between a page break and a page break preview?
A page break is the boundary that divides printed content between pages. Page Break Preview is Excel’s view for displaying and adjusting those boundaries; changing the view itself does not insert or remove a break.

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.