Excel Page Breaks for Printing: Set, Preview, and Fix

To control where a printed worksheet splits, open View > Page Break Preview, then drag a blue page-break line to the desired row or column. To insert a break precisely, select the row below it or the column to its right, then choose Page Layout > Breaks > Insert Page Break. Check the result with File > Print before printing.

What a page break does

A page break marks the boundary between one printed page and the next. In a worksheet, Excel lays out rows and columns across paper, so a break can split the sheet horizontally, vertically, or both. It affects printed output and print preview; it does not insert a blank row, alter cell values, or change the worksheet’s on-screen grid.

Excel creates automatic page breaks based on the printable area and the current print settings. These breaks can change when you change paper size, orientation, margins, scaling, column widths, row heights, or the printer selected. A manual break gives you more control over the split, but it still has to fit within those printing settings.

Page breaks are especially useful when a table should stay together, when each printed page needs a clear heading, or when a wide report should divide at a meaningful column. They are not the same as repeating titles: a break determines where a page ends, while print titles repeat chosen heading rows or columns on multiple pages.

Preview the worksheet’s page layout

Use Page Break Preview to see how Excel currently divides the sheet. On Windows, select View > Page Break Preview. The worksheet displays page boundaries and page numbers; areas outside the print area may appear dimmed. Automatic breaks are generally shown as dashed lines, while manually placed breaks appear as solid lines. The view is a planning aid, so confirm the final result in print preview as well.

To adjust a break, point to its blue boundary and drag it. Moving a horizontal line changes the row at which the next page begins; moving a vertical line changes the column. Excel may shift nearby automatic breaks to accommodate your change. If a line is difficult to grab, zoom in or use the Insert Page Break command with a selected row or column instead.

Return to View > Normal when you want the usual worksheet view. The page boundaries may still be displayed in Normal view after you have used print preview. To hide them, go to File > Options > Advanced, find Display options for this worksheet, and clear Show page breaks. This setting applies to the selected worksheet.

Insert a manual page break

First select the point where the next page should begin. A practical way to remember the selection rule is that Excel inserts a break above and to the left of the selected cell or range:

For a horizontal break, select the row immediately below the desired split. For example, select row 26 to start the next printed page at row 26.
For a vertical break, select the column immediately to the right of the desired split. Select column G to start the next page at column G.
For both a horizontal and vertical break at one point, select the cell below and to the right of the intended intersection.

Then choose Page Layout > Breaks > Insert Page Break. You can also select a cell or range in Page Break Preview and use the same ribbon command. If a break lands in the wrong place, undo immediately with Ctrl+Z on Windows or Command+Z on Mac, or remove it as described below. Menu names and their placement can vary slightly between Excel desktop versions.

For example, imagine a sales report with a heading in row 1 and records through row 60. If the first page should contain the heading and records through row 25, select row 26 and insert a horizontal break. Then inspect the preview: if the page is still too crowded, adjust the scaling or margins rather than repeatedly forcing breaks without checking the printed size.

Remove or reset page breaks

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. In Page Break Preview, you can also drag a manual line beyond the edge of the print area to remove it. If you want to clear all manual breaks on the active worksheet, choose Page Layout > Breaks > Reset All Page Breaks.

Resetting breaks removes manual page-break choices; Excel then lays out the sheet using automatic breaks. It does not erase worksheet data. Be careful not to confuse a manual break with the edge of a print area or a page boundary produced by automatic pagination. If the layout remains unexpected after resetting, check the print area, scaling, paper size, and margins.

Make page breaks work with scaling and print settings

Before fine-tuning breaks, choose the paper and layout that the report actually needs. On the Page Layout tab, review Orientation, Size, and Margins. A landscape page can fit more columns; a smaller margin can create more printable space, subject to the printer’s limits. These changes can move automatic breaks, so make them before placing manual ones where possible.

Scaling is a frequent source of confusion. The Scale to Fit controls on Page Layout can shrink a worksheet to fit a chosen number of pages wide or tall. If you set a fit-to-page option, Excel may ignore manual page breaks. For deliberate manual pagination, use a percentage scale instead of fitting the sheet to a specified page count, then review the preview. Shrinking an entire report to one page can technically avoid extra breaks but may make its text too small to read.

You can also set what part of a worksheet prints. Select the cells you need, then choose Page Layout > Print Area > Set Print Area. This is useful when notes or calculations elsewhere on the sheet should not appear in the report. To repeat heading rows on every page, choose Page Layout > Print Titles and specify rows to repeat at the top. A repeated heading does not create a page break, and a page break does not repeat the heading.

After adjusting settings, select File > Print or press Ctrl+P on Windows. The print preview shows page count and how the content will be divided. On Mac, use Command+P to open printing; ribbon and dialog details differ by version. If the preview does not match what you expect, verify that the correct worksheet is active and that the intended printer, paper size, and print settings are selected.

Choose breaks that make a report readable

A page break should support the reader, not just reduce the number of pages. Avoid splitting a heading from the rows it labels, placing a subtotal alone at the top of a page, or cutting a small table into awkward fragments. For a long list, a break at a natural section boundary is usually easier to follow than one chosen solely to make every page equally full.

For a multi-page table, repeat its header row with Print Titles and place breaks between complete groups where practical.
For a wide worksheet, decide whether readers should continue across pages from left to right. Consider landscape orientation or a smaller scale before breaking the table into narrow strips.
For a short summary, set a print area so unrelated cells do not generate extra pages.
For a report whose contents change often, rely more on automatic breaks and check preview after updates. Fixed manual breaks may become awkward when new rows are added.

There is no universally correct number of rows per page. Row heights, font size, margins, paper size, and printer capability all affect the result. The useful test is whether the printed page remains legible and whether the relationship between headings and data is clear.

Common page-break problems

The break will not move or the printout ignores it. Check whether the worksheet is being scaled to fit a set number of pages. Fit-to-page scaling can override manual breaks. Switch to a percentage scale, then reposition the breaks and preview again.

Excel prints extra blank pages. Content or formatting far beyond the visible table can enlarge the used print range. Check Page Break Preview for distant populated cells, review the print area, and set a specific print area if appropriate. Also look for a stray value, border, or formatting in an otherwise empty row or column.

A report becomes tiny after fitting it to one page. Fitting a broad or long worksheet onto one sheet of paper reduces its scale. Use a larger paper size if available, choose landscape for wide data, print across multiple pages, or limit the print area to the material readers need. Preview at actual page size before printing a full batch.

The page count changes on another computer. Printer drivers and selected paper sizes can affect pagination. Choose the intended printer and paper settings before finalizing breaks, then recheck the workbook on the system that will produce the printed copy. Page-break preview is not a guarantee that every printer will render identically.

Excel desktop, Mac, and web differences

The ribbon paths here are for Excel for Microsoft 365 on Windows. Excel for Mac has comparable worksheet views and page-layout features, but the interface and print dialogs can differ; use Command+P rather than Ctrl+P to open printing. On Windows, Ctrl+P opens the print screen. If a command is not visible, check the Page Layout or View tab and the current Excel version.

Excel for the web has a different printing workflow and may not offer the same full set of manual page-break controls as desktop Excel. For exact manual placement, use the desktop app, then inspect the web or desktop print output if the workbook will be printed from a browser. Regardless of platform, check the final preview because page setup options and available printer settings can vary.

Frequently Asked Questions

How do I add a page break in Excel?
Select the row below the horizontal split or the column to the right of the vertical split, then choose Page Layout > Breaks > Insert Page Break. Use Page Break Preview to check its position.

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 lets Excel create automatic ones.

Why are my manual page breaks ignored?
A fit-to-page scaling setting can cause Excel to ignore manual breaks. Change the scaling approach, such as using a percentage scale, and then place the breaks again.

Can I repeat a heading on every printed page?
Yes. Choose Page Layout > Print Titles and set the row or column to repeat. This repeats labels on pages; it does not insert a page break.

How do I see where Excel will split pages?
Select View > Page Break Preview to inspect and move page boundaries. Then use File > Print to review the print preview before printing.

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.