Page Break in Excel Not Working? Fix the Common Causes

If a page break in Excel is not working, first switch to View > Page Break Preview and check whether scaling or the print area is overriding the layout. In Excel for Microsoft 365 on Windows, you can insert a manual break from Page Layout > Breaks after selecting the row below or column to the right of where the new page should start.

What page breaks control in Excel

Excel divides a worksheet into printed pages, not pages in the on-screen grid. Automatic page breaks are calculated from the paper size, margins, orientation, scaling, and the content being printed. Manual page breaks let you choose where a printed page ends or begins, within the limits of that print setup.

A break can be present even when you do not see a bold line in the worksheet. Normal view is primarily for editing cells; Page Break Preview is the view designed to show print-page boundaries. Also, a manual break does not guarantee that the page will have the dimensions you expect if a scaling setting tells Excel to fit the sheet to a specified number of pages.

For example, a long sales table might be split after row 35 by an automatic break. Inserting a manual break above row 36 requests that split, but changing the paper from Letter to A4 or switching from portrait to landscape can move the automatic boundaries elsewhere. The printed result depends on the full page setup, not just the row where you placed a break.

Start with the quickest checks

Before rebuilding the layout, verify that Excel is showing the right worksheet and print settings. These checks resolve many cases where a break appears to do nothing:

Choose View > Page Break Preview. Look for solid blue lines, which generally indicate manual breaks, and dashed blue lines, which generally indicate automatic breaks.
Open File > Print and inspect the preview. Confirm that the expected worksheet content is being printed and count the pages shown.
On the Page Layout tab, check the settings under Scale to Fit. A width or height set to a specific number of pages can override manual breaks.
Check Page Layout > Print Area. A print area may exclude the rows or columns you are trying to arrange.
Confirm the active sheet. Page breaks belong to a worksheet; selecting another sheet will show a different layout.

Print Preview is especially useful because it reflects the current printer and page setup. If its page divisions look right but the worksheet grid does not show lines, the problem is likely display-related rather than a failed break.

Insert or move a manual page break

In Excel for Microsoft 365 on Windows, select the row below the point where the next page should begin, then choose Page Layout > Breaks > Insert Page Break. To start a new page at a column, select the column to the right of the intended boundary and use the same command. Selecting a cell instead inserts a horizontal break above that cell and a vertical break to its left.

In Page Break Preview, you can also drag a break line to a different position. Excel may adjust the print scale as you move a boundary, so check the scale and Print Preview afterward. If the break cannot be changed, make sure the worksheet is not in cell-edit mode: press Enter or Esc, then try again. Also check whether the sheet is protected; protection can restrict layout changes.

To remove one manual break, select a cell immediately below a horizontal break or immediately to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. To discard all manual breaks on the sheet, choose Page Layout > Breaks > Reset All Page Breaks. Resetting returns the sheet to automatic breaks; it does not remove cell contents, and it is different from clearing a print area.

Break commands can be unavailable or behave unexpectedly when multiple worksheets are grouped. Look for grouped sheet tabs, right-click a selected tab, and choose Ungroup Sheets before changing a single sheet’s layout. Otherwise, an edit may apply to several selected sheets.

When scaling overrides the break

One of the most common causes is the Fit to page setting. If Scale to Fit is configured to fit the worksheet to one page wide and one page tall, Excel must compress the printout to satisfy that instruction. A manual break cannot force the sheet to span the number of pages you intended while that fit-to-pages instruction is in effect.

To allow manual breaks to shape the pagination, inspect Page Layout > Scale to Fit. Set Width and Height to Automatic if you want the worksheet to use as many pages as needed, then set a suitable Scale percentage if required. In the Page Setup dialog, the equivalent choice is often expressed as adjusting the scaling option; choose the percentage-based option rather than Fit to. The exact dialog presentation can depend on the workbook and printer configuration.

Consider a worksheet with 60 rows that should print on two pages, with a break after row 30. If it is set to fit one page tall, Excel will shrink all 60 rows onto one page instead of honoring the two-page division. Changing Height to Automatic lets the manual break take effect, though the result can still vary with margins, paper size, and column widths.

Do not confuse fitting to one page wide with fitting to one page total. Setting Width to 1 page and Height to Automatic can keep all columns together while allowing multiple pages down the sheet. That is often more readable for a wide report, but it may reduce the text size if the columns are very wide.

Check the print area and page setup

A print area defines which cells Excel includes in the printed output. If it ends before the break location, changing that break will not create a visible page containing excluded cells. Choose Page Layout > Print Area > Clear Print Area to remove an existing boundary, or select the intended cells and choose Page Layout > Print Area > Set Print Area. Then review File > Print.

Page setup can change where automatic breaks fall and how much of a manual layout fits on each page. Check orientation, paper size, margins, and scaling from the Page Layout tab. A report that fits on one page in landscape may spill onto two in portrait. Narrowing margins or reducing unnecessary column widths can sometimes solve an overflow without making the print text too small.

Also look at the printer selected in File > Print. Different printers or paper settings can produce different pagination, and a printer driver may offer paper sizes that do not match the worksheet’s current setup. If the preview changes after selecting a different printer, the break itself may be intact while the printable area has changed.

Rows or columns set to hidden, filtered-out records, and repeated print-title rows can make a page appear to contain unexpected content. Print titles repeat chosen headings on each page; they do not create a manual break. Review Page Layout > Print Titles if headers seem to consume space or repeat in a way that changes the apparent page layout.

Why break lines may not be visible

If you are in Normal view, switch to Page Break Preview to see the page divisions directly. You can also enable break display for a worksheet in Excel for Windows by choosing File > Options > Advanced, scrolling to Display options for this worksheet, selecting the relevant sheet, and checking Show page breaks. The setting applies to the selected worksheet and is separate from whether a break is actually present.

After printing or opening Print Preview, Excel may display page-break lines in the worksheet, but those lines can be hard to distinguish from gridlines or may not appear in the view you are using. Page Layout view can help show how content fits on paper, while Page Break Preview is usually the clearest way to inspect break positions and page numbers.

Do not rely on a dashed line in Normal view as proof that a manual break was inserted. Automatic breaks are usually shown as dashed lines in Page Break Preview, while manual breaks are typically solid. The most reliable confirmation is whether the printed preview starts a new page at the intended row or column.

Common cases that look like a broken break

The page count does not change: A manual break may replace an automatic break that was already in almost the same place. Check the actual preview boundary rather than expecting the total page count to increase.
The wrong rows print: Review the print area, filters, hidden rows, and the Print Active Sheets or selection option in the print settings.
The break moves after editing: Changes to paper size, orientation, margins, scaling, or column widths can recalculate pagination. Recheck the preview after changing them.
The whole worksheet is tiny: A fit-to-page setting may be compressing the sheet. Set the dimensions to Automatic or use a modest scale percentage, then reassess readability.
The command is disabled: Exit cell editing, ungroup sheets, and check whether protection is limiting changes. If the workbook is in a restricted or shared editing state, check its permissions as well.

One useful test is to create a copy of the workbook, clear the print area on the copy, set Width and Height to Automatic, and inspect Page Break Preview. If the break then behaves as expected, restore only the print area or scaling option you actually need. Changing one setting at a time makes the cause easier to identify than resetting the entire workbook’s page setup.

Excel for Mac and Excel for the web

The instructions above are for Excel for Microsoft 365 on Windows. Excel for Mac has page-break and print-layout controls, but menu and settings locations can differ by release; use its Page Layout and View controls and check the print preview before relying on a particular layout. The Windows shortcut Ctrl+P opens Print; on a Mac, use Command+P.

Excel for the web can display and print worksheets, but some desktop page-setup and page-break editing controls may not be available or may be presented differently. If you cannot insert or adjust the break in the browser, open the workbook in the desktop Excel app and make the change there. In either version, confirm the final output through Print Preview because browser and printer settings can affect pagination.

Frequently Asked Questions

Why does Excel ignore my manual page break?
Check whether the sheet is set to fit a fixed number of pages under Scale to Fit or Fit to in Page Setup. That scaling mode can override manual breaks. Also make sure the break is within the print area and confirm the result in Page Break Preview.

How do I make Excel show page breaks?
Choose View > Page Break Preview to see page boundaries. In Windows, you can also enable File > Options > Advanced > Display options for this worksheet > Show page breaks. Select the worksheet whose breaks you want to display.

How do I remove a page break without resetting all of them?
Select a cell just below the horizontal break or just to the right of the vertical break, then choose Page Layout > Breaks > Remove Page Break. Use Reset All Page Breaks only when you want Excel to recalculate all manual breaks on that sheet.

Why does my page break change when I print?
Pagination can change when the selected printer, paper size, orientation, margins, or scaling changes. Check File > Print and verify that its paper and printer settings match the setup used when you arranged the worksheet.

Can I insert page breaks in Excel for the web?
Some page-layout tools are limited or differ in the browser version. If the break controls you need are missing, open the workbook in desktop Excel, set the break there, and verify the output in Print Preview.

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.