Excel Page Breaks: Why There Are Too Many and How to Fix

If Excel says there are too many page breaks, the worksheet has reached its page-break capacity, or its print setup is generating more breaks than you need. In Excel for Microsoft 365 on Windows, open Page Layout > Breaks > Reset All Page Breaks to remove manual breaks, then check the print area, scaling, and page settings before adding any back.

What the “too many page breaks” warning means

A page break marks where Excel starts a new printed page. It does not split or remove worksheet data; it only affects how the selected sheet is divided when printed or saved as a PDF. A warning that Excel cannot add more breaks generally means it has reached its page-break limit for that worksheet. Excel’s worksheet specifications list 1,026 horizontal and vertical page breaks. This is a worksheet limit, not a count of the workbook’s separate sheets.

The message can seem surprising because a sheet may not look especially large. Breaks can accumulate from repeated manual edits, or the print setup can divide a wide or long range into many pages. A change to paper size, margins, printer settings, or scaling can also alter where Excel places automatic breaks. The message does not necessarily mean that the file is damaged or that the data itself is too large to calculate.

It is useful to distinguish the warning from other Excel messages about workbook limits or formatting. Page breaks are print-layout settings. Clearing them is a reasonable first step, but check the print preview afterward so that the pages still divide in a useful way.

How Excel decides where pages break

Excel uses two kinds of page breaks. Automatic breaks are calculated to fit the printable worksheet area onto pages. Manual breaks are inserted by a person to control where a new page begins. In Page Break Preview, automatic breaks usually appear as dotted lines and manual breaks as solid lines. Excel may adjust automatic breaks when the paper size, printer, margins, or scaling changes.

A page’s printable area is smaller than the paper itself because of margins and any header or footer space. If the sheet’s columns do not fit across that area, Excel prints them across multiple pages. If its rows extend beyond the printable height, Excel creates additional pages vertically. For example, a report with 12 columns might print across two pages wide and 18 pages tall: that is potentially 36 printed page areas, even though the sheet contains only one continuous table.

To inspect the layout, select View > Page Break Preview. The preview shows page boundaries and page numbers; you can drag a manual break to reposition it. Return to View > Normal when finished. In the print preview, opened through File > Print or Ctrl+P on Windows, check whether the printed pages match the intended result. On Mac, use Command+P to open printing.

Common reasons a sheet accumulates too many breaks

Repeatedly choosing Insert Page Break is the most direct cause of many manual breaks. It can happen when someone inserts breaks row by row while preparing a long report, especially if the same sheet is edited over time. A copied worksheet may also retain print-layout settings that are no longer appropriate for its new content.

Other factors can produce an unexpectedly large number of pages or make the layout seem difficult to control:

A very long or wide print range: Excel may divide the range into many pages in one or both directions.
An overly large print area: The print area may include blank or distant rows and columns, extending the output beyond the visible table.
Unhelpful scaling: Leaving the sheet at its normal size can result in many pages; forcing it to fit on one page can make the text too small.
Paper and margin settings: A change from one paper size to another, or wider margins, reduces the space available for content.
Printer differences: Different printers and drivers can have different printable regions, so a layout may shift when the selected printer changes.
Frequent layout changes: Switching between print settings and manual adjustments can make existing breaks harder to interpret.

These factors do not all add manual breaks. Some change the automatic pagination instead. That distinction matters: resetting manual breaks may clear an accumulation, but it will not make a genuinely huge print range fit on a small number of pages by itself.

Reset the breaks and check the print area

Start with a reset if you do not need to preserve custom page boundaries. In Excel for Microsoft 365 on Windows:

Select the worksheet that shows the warning. If you are unsure which sheet is affected, check each sheet’s print preview rather than resetting every sheet in the workbook.
Choose Page Layout > Breaks > Reset All Page Breaks. This clears the manual breaks on the selected sheet; Excel recalculates automatic breaks from the current print settings.
Open View > Page Break Preview and inspect how the sheet is divided. If necessary, return to Normal view and adjust the print setup.
Choose File > Print to review the result before printing or creating a PDF.

Resetting breaks can remove intentional divisions, so first note any page starts that matter, such as a new department or month beginning on a fresh page. After the reset, you can add back only those breaks. If the warning appears while inserting a break, resetting first is usually more effective than repeatedly trying the same insertion.

Next, check whether the print area includes the actual report and nothing beyond it. Select the intended cell range, then choose Page Layout > Print Area > Set Print Area. To remove an existing print area, use Page Layout > Print Area > Clear Print Area. A print area that accidentally reaches far below the data can create many mostly blank pages. If the sheet has multiple separate sections that should print independently, select and set the desired range deliberately rather than relying on an old print area.

Control pages with scaling and orientation

If the sheet still spans too many printed pages, decide whether the problem is width, height, or both. Under Page Layout, use the Scale to Fit controls to set a width or height in pages. For example, setting width to one page and height to Automatic can keep all columns together while allowing a long report to continue over several pages. This is often more readable than shrinking the entire report to a single page.

Another option is to change orientation through Page Layout > Orientation > Landscape. Landscape gives a wide table more horizontal space, while portrait orientation can suit a narrow list. Check Page Layout > Size for the intended paper size and Page Layout > Margins for excessive margins. These settings affect pagination, so review the preview after changing them.

Use “fit to one page” carefully. It can be suitable for a small summary, but a large worksheet may become unreadably small when compressed. If readers need to inspect figures on paper, keeping a sensible page width and allowing several pages down the length of the sheet is usually clearer. Scaling changes print size; it does not delete rows, columns, or the original cell formatting.

Add only the manual breaks you need

After resetting, insert a manual break only where a specific page boundary improves the report. To start a new page above a particular row, select the row below the intended boundary and choose Page Layout > Breaks > Insert Page Break. Excel places a horizontal break above the selected row. Selecting a column and inserting a break places a vertical break to its left. Selecting a cell can insert both a horizontal break above it and a vertical break to its left.

For example, if a printed sales report should start each region on a new page, select the first row for the next region and insert a break above it. Then inspect Page Break Preview: if the automatic layout already starts that region on a new page, an extra manual break may be unnecessary. Manual breaks are best used for meaningful sections, not for every row or every small block of data.

In Excel for Mac, the page-layout controls are available from the Page Layout tab, though the ribbon arrangement can differ slightly by version and window size. Use the same principle: select the relevant row or column, choose the page-break command, and review the result in Page Break Preview. Excel for the web has a more limited set of print-layout controls than the desktop application; for detailed manual page-break work, open the workbook in the desktop version.

Keep printed pages readable and predictable

A good fix is not simply the one that produces the fewest pages. Consider what a reader needs on each sheet of paper. A table split halfway through a set of columns may be hard to understand even if it uses fewer pages. In Page Layout > Print Titles, you can specify rows to repeat at the top or columns to repeat at the left when a printout spans multiple pages. Repeating headings helps readers identify the fields on later pages.

Before finalizing a workbook, review both the page count and the page content. Look for pages with only one or two stray columns, blank pages caused by an oversized print area, repeated headings that take too much space, or totals separated from the rows they summarize. If the workbook will be printed by someone else, use a clear paper size and avoid relying on a particular printer’s unusual margins where possible.

For recurring reports, document the intended print area and any important manual breaks, or keep a clean template sheet. If the report structure changes substantially, revisit its print layout instead of preserving old breaks automatically. A quick check in Page Break Preview and File > Print can catch an awkward split before pages are distributed.

Frequently Asked Questions

How do I remove all page breaks in Excel?
On the affected worksheet, choose Page Layout > Breaks > Reset All Page Breaks. Excel clears manual breaks and recalculates automatic ones. It does not remove worksheet data.

Does Reset All Page Breaks remove automatic breaks?
It resets manual page breaks. Excel still creates automatic breaks based on the print area, paper, margins, scaling, and printable page size. Those automatic boundaries may move when those settings change.

Why does Excel show many pages even when my table is small?
Check the print area for extra rows or columns, then review paper size, margins, orientation, and scaling. A stray used range or an old print area can make Excel include blank space. File > Print shows what Excel plans to output.

Can I add a page break after every section?
Yes. Select the first row of a section and insert a break above it, but use breaks only where the printed layout needs them. If sections already begin on separate pages automatically, an added manual break may create an unnecessary blank or sparse page.

Will changing page breaks change my worksheet data?
No. Page breaks control printed page boundaries; they do not delete or rearrange cell contents. Scaling changes how content is sized for printing, not the underlying values in cells.

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.