Excel Won’t Insert a Page Break? Fix the Common Causes

Excel Won't Insert a Page Break? Fix the Common Causes

If Excel won’t insert a page break, select the row below or column to the right of where the split should go, then choose Page Layout > Breaks > Insert Page Break. If the command is unavailable or the break has no effect, check whether you are editing a cell, have grouped worksheets, are working in Excel for the web, or have print scaling set to fit the sheet onto pages.

Insert a page break in the right place

Excel places manual page breaks according to the selected row or column. To start a new printed page above row 21, select row 21 by clicking its row number, then choose Page Layout > Breaks > Insert Page Break. To start a new page to the left of column G, select column G and insert the break. In either case, the break falls before the selected row or column.

You can also select a cell at the intersection where you want both a horizontal and vertical break. For example, selecting G21 and inserting a break creates a split above row 21 and to the left of column G. This can divide a wide worksheet into separate printed pages, so check the result in Page Break Preview before printing.

To remove a particular break, select the row below it or the column to its right, then choose Page Layout > Breaks > Remove Page Break.
To remove manual breaks throughout the worksheet, choose Page Layout > Breaks > Reset All Page Breaks.

These ribbon commands are for Excel desktop. Excel for Mac has similar page-break controls on the Page Layout tab, though the ribbon arrangement can differ slightly by release. Excel for the web does not provide the same controls for inserting and adjusting manual page breaks; open the workbook in desktop Excel to set them.

What page breaks do in Excel

A page break marks where Excel begins a new page when it divides a worksheet for printing or PDF export. Excel creates automatic breaks based on the paper size, page orientation, margins, scaling, and the amount of content. Manual breaks let you override that layout, such as keeping a totals section together or starting each department on a fresh page.

Automatic breaks are not fixed: changing the print settings or worksheet dimensions can move them. A manual break is a deliberate instruction, but it still operates within the overall print setup. It does not insert a blank worksheet row, alter cell values, or change where data appears in Normal view. It affects printed pages and print preview.

A common misunderstanding is that inserting a break immediately prints the worksheet on separate pages exactly as expected. The break only proposes a page boundary. If the sheet is being scaled to fit a specified number of pages, or the print area excludes the relevant cells, the final output may not match the boundary you had in mind.

Why the Insert Page Break command is unavailable

If Insert Page Break appears dimmed, try these checks first. They address the most common conditions that prevent the command from being used:

You are editing a cell. Press Enter or Esc to finish editing, then select the target row, column, or cell again. Ribbon commands may be unavailable while the insertion point is active in a cell or the formula bar.
More than one worksheet is selected. When sheet tabs are grouped, Excel applies some actions to multiple sheets, and page-break commands may be unavailable. Right-click a selected sheet tab and choose Ungroup Sheets, or click a single sheet tab. Check the title bar or tab appearance for signs that several sheets are grouped.
The worksheet is protected. Review the Review tab for Unprotect Sheet. If protection is enabled, ask the workbook owner for permission or the password before changing it. Do not assume that changing a print setting requires bypassing protection.
You are using Excel for the web. Open the file in the desktop app to insert or move manual breaks. A browser print dialog is not a substitute for Excel’s worksheet page-break controls.
The selection is not where you expect. Click a row or column header, or select the cell at the intended split, then try again. Avoid making a selection while a menu, dialog, or cell edit is active.

If the command remains disabled, save the workbook, close and reopen it in desktop Excel, and test on a copy if the file is important. This can distinguish a temporary interface issue from a restriction in the workbook. If the sheet is shared or managed by someone else, confirm that you are allowed to change its layout.

Use Page Break Preview to see the split

Normal view does not show page boundaries clearly. Choose View > Page Break Preview to see how the worksheet is divided for printing. The page areas and boundary lines make it easier to tell whether a break landed above the intended row or to the left of the intended column. Automatic boundaries are commonly shown as dashed lines and manual ones as solid lines, although appearance can vary by Excel version and display settings.

In Page Break Preview, you can often drag a boundary to a different row or column. Dragging an automatic boundary changes the print layout by creating or adjusting a manual break. If the sheet is dense, zoom in or use the row and column labels to locate the boundary precisely. Return to View > Normal when you are done; changing views does not remove the breaks.

Page Break Preview can also reveal unexpected blank pages. A stray value, formatting, or an object far to the right or below the main data can extend the worksheet’s used area and affect printing. Check the last intended row and column, and inspect the print preview before deciding that the break itself is faulty.

Check scaling, paper size, and print area

When a manual break seems ignored, inspect the scaling settings. On the Page Layout tab, the Scale to Fit controls let you specify a width or height for the printed sheet. If the worksheet is set to fit a chosen number of pages, Excel may scale the output to satisfy that setting; manual breaks may not govern the final pagination in the way they do when scaling is set to Automatic. For more predictable manual page boundaries, set Width and Height to Automatic and review the result in Page Break Preview.

For example, suppose a report has 60 rows and you insert a horizontal break before row 31. If Height is set to fit the report on one page, Excel may shrink the report rather than print two pages separated at row 31. If Height is set to Automatic, the break can divide the report into separate pages, subject to the paper size, margins, and other layout choices.

Also check the paper size and orientation under Page Layout. A landscape page can fit more columns than a portrait page, and a larger paper size can change where automatic boundaries fall. Margins reduce the usable space on each page. These settings do not usually disable the Insert Page Break command, but they can make a break appear to move or cause extra pages.

A print area is the range Excel is set to print. If it excludes the rows or columns you are trying to control, changing a break outside that range may not affect the printed output. Review Page Layout > Print Area and, if appropriate, choose Clear Print Area before setting a new print range. Confirm the result with File > Print, where you can inspect the page count and layout before sending the document to a printer.

Diagnose a break that still prints incorrectly

Work through the layout in a consistent order rather than repeatedly inserting breaks. First confirm the intended print range, then choose the paper size and orientation, set scaling, and only then place manual breaks. This order matters because changing the page setup can shift automatic boundaries and alter how a worksheet fits on paper.

Open View > Page Break Preview and identify the page that is wrong.
Check whether the break is manual or automatic and whether it is at the intended row or column.
Review Page Layout settings for paper size, orientation, margins, scaling, and print area.
Remove an incorrect manual break or use Reset All Page Breaks, then add only the boundaries the report needs.
Open File > Print and inspect each preview page, especially the last page and any page that appears nearly blank.

For a long table, repeating header rows can make printed pages easier to read, but repeating titles and page breaks solve different problems. Use Page Layout > Print Titles to repeat selected rows or columns on each printed page; use breaks to determine where pages start. A repeated header does not force a new page, and a page break does not repeat the header.

If you need to keep a short totals block together, place a break immediately before that block rather than inserting blank rows to push it onto a new page. Blank rows can change the print layout unpredictably when data or margins change. After adjusting, check that the totals remain with the relevant section and that no page contains only a few unnecessary lines.

Manual breaks versus other print-layout options

Manual page breaks are useful when the division should remain at a particular point, such as beginning a new printed page for each region. They require maintenance if the report grows or shrinks: inserting rows above a boundary can change what appears on a page. Automatic breaks are better when the sheet changes often and approximate page divisions are acceptable, because Excel recalculates them from the current layout.

Scaling to fit is another option when the main goal is to keep a small report on a known number of pages. However, fitting a large worksheet to one page can make text too small to read. For a wide table, setting the width to one page while leaving height automatic can be a more readable compromise, but the resulting number of pages depends on the data and print settings. Use print preview to judge legibility instead of relying only on the page count.

If the worksheet is meant to be read onscreen rather than printed, a page break may be the wrong tool. Freeze panes can keep headings visible while scrolling, and separate worksheets can organize distinct report sections. Those features change the viewing experience or workbook structure; they do not control printed page boundaries.

Frequently Asked Questions

Why is Insert Page Break greyed out in Excel?
Finish any active cell edit, ungroup worksheets, and check whether the sheet is protected. If you are in Excel for the web, open the file in the desktop app to insert a manual page break.

How do I insert a page break between two rows?
Select the row below the desired split. For a break between rows 20 and 21, select row 21 and choose Page Layout > Breaks > Insert Page Break.

Why does Excel ignore my manual page break?
Check whether the sheet is being scaled to fit a set number of pages, and confirm that the affected cells are inside the print area. Review the output in Page Break Preview and File > Print.

Can I add page breaks in Excel for the web?
Excel for the web does not offer the full desktop controls for inserting and moving manual page breaks. Open the workbook in Excel for Microsoft 365 on Windows or Excel for Mac to manage them.

How do I remove all page breaks?
In desktop Excel, choose Page Layout > Breaks > Reset All Page Breaks. This resets manual breaks on the active worksheet; Excel will still create automatic breaks for 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.