Excel Not Inserting Page Breaks? Fix the Print Setup

If Excel is not inserting a page break, first switch to View > Page Break Preview, select the row below or column to the right of the desired break, then choose Page Layout > Breaks > Insert Page Break. If the command is unavailable or the break has no effect, check whether the sheet is set to fit the printout to a fixed number of pages; that scaling setting can override manual breaks.

How Excel page breaks work

A page break marks where Excel starts a new printed page. It changes the printed layout, not the worksheet itself: rows, columns, formulas, and cell contents remain in place. Excel creates automatic breaks based on factors such as the paper size, margins, print area, and scaling. You can add manual breaks to control where a page ends, but those breaks work within the print layout Excel is using.

There are two kinds of breaks to distinguish. Automatic breaks are calculated by Excel and usually appear as dotted lines in Page Break Preview. Manual breaks that you add or move appear as solid lines there. The distinction helps explain why a dotted line may move when you change the layout, while a manual break is intended to hold a chosen boundary—unless a setting, such as Fit to scaling, takes precedence.

A page break does not necessarily mean that the next printed page will contain a fixed number of worksheet rows. If column widths, margins, orientation, or scaling change, Excel may fit a different amount of content on each page. For that reason, check the preview after making a break rather than relying only on the line shown in the worksheet.

Insert a horizontal or vertical break

In Excel for Microsoft 365 on Windows, use Page Break Preview to place and inspect breaks. Select the appropriate row or column before inserting one:

Open the worksheet and choose View > Page Break Preview.
For a horizontal break, select the row immediately below the row where the new page should begin. For example, select row 26 to start the next page at row 26.
For a vertical break, select the column immediately to the right of the column where the new page should begin. To start a new page at column G, select column G.
Choose Page Layout > Breaks > Insert Page Break.
Review the solid break line and open File > Print to check the resulting pages.

For a horizontal break after row 25, selecting row 26 is the clearest method: the break goes above the selected row. For a vertical break before column G, selecting column G places it to the left of that column. If you select a cell rather than an entire row or column, Excel can place both a horizontal and a vertical break around the selection. When you only want one direction, selecting the full row or full column avoids an unintended second break.

Check the scaling setting first

The most important setting to check when a manual break appears to be ignored is Fit to scaling. When Excel is instructed to fit a sheet to a specified number of pages, such as one page wide by two pages tall, it determines the page layout to satisfy that target. Manual page breaks do not control the result in the same way under this setting.

On Windows, go to Page Layout and inspect the Scale to Fit group. If Width or Height is set to a page count, change the setting to Automatic where appropriate. You can also open the Page Setup dialog from the small dialog launcher in the Page Setup group, then check the Page tab. If the sheet is set to Fit to a number of pages, choose Adjust to and a percentage instead when you need manual page breaks to determine page boundaries.

There is a trade-off. Fit to can make a wide report print on one page, but it may shrink text considerably and take control of pagination away from manual breaks. Adjust to preserves a chosen scale percentage, while the paper size and margins determine how many pages the content occupies. If the exact break matters more than fitting everything to a set page count, use a suitable Adjust to percentage, insert the break, and inspect the print preview. Avoid selecting an extremely small scale just to force a page count; the result can be difficult to read.

Make sure you are in the right view

Normal view is useful for editing cells, but it does not show the complete printed-page layout as clearly as Page Break Preview. If a break seems missing, switch to View > Page Break Preview. This view displays page boundaries and helps show whether the break is manual or automatic. You can also use the zoom controls to inspect a boundary more closely.

Do not confuse a worksheet gridline with a page break. Gridlines separate cells and may or may not print, depending on the sheet’s print settings. A page break marks the edge of a printed page. In Page Break Preview, a blue boundary is the relevant indicator; a dotted boundary is generally automatic, while a solid one represents a manual break. A blue shaded area can also indicate cells outside the current print area, so look at the boundary itself rather than assuming every blue line is a break you inserted.

If you inserted the break but cannot see a clear change in Normal view, check Page Break Preview or File > Print. Print preview is the practical test: it shows how Excel is dividing the worksheet into pages with the current print settings.

Review the print area, paper, and margins

A page break only affects the way the printable worksheet is divided. If the area you expect to print is outside the defined print area, changing a break there may not change the pages in the preview. To inspect the setting, choose Page Layout > Print Area. If a print area is set and you want the whole worksheet considered, choose Clear Print Area; if you want only a selected range, select it and use Set Print Area.

Paper size and orientation can change how much content fits before Excel reaches a page boundary. On the Page Layout tab, check Orientation and Size, then review Margins. For example, a report that fits across one page in landscape orientation may spill onto two pages in portrait orientation. A wider margin can also push a column onto another page, making an existing vertical break appear to be in the wrong place.

These settings are reasons to check preview after inserting a break, not reasons to keep adding breaks blindly. If the page boundary shifts after changing paper size or margins, decide whether the new layout is acceptable first. Then adjust or remove manual breaks that no longer serve the intended printout.

Remove, move, or reset unwanted breaks

A break that is already present can make a new one seem ineffective. In Page Break Preview, inspect the solid lines and see whether a previous manual break is splitting the sheet somewhere unexpected. You can drag a break line to a different row or column in the preview, or remove a particular break by selecting the row below a horizontal break or the column to the right of a vertical break and choosing Page Layout > Breaks > Remove Page Break.

If the worksheet has accumulated several breaks and you want to start over, choose Page Layout > Breaks > Reset All Page Breaks. This removes manual page breaks and lets Excel calculate the layout again; it does not erase worksheet content. After resetting, insert only the boundaries needed for the report and verify them in Print Preview. Resetting all breaks is usually more efficient than hunting for several old breaks individually, but it also removes any manual boundaries that were working correctly.

Other reasons the command may not work

If Insert Page Break is unavailable, check that you are not actively editing a cell. Press Enter or Esc to finish editing, then try the command again. Also check whether the worksheet is protected: protection can restrict changes to worksheet layout. If you have permission to do so, review Review > Unprotect Sheet. A protected sheet may require its password, so do not assume you can remove protection without authorization.

Check that the intended worksheet is active before using the Breaks command. Page breaks belong to a worksheet, not to the entire workbook, so selecting a different sheet changes which print layout you are editing. If a workbook has multiple sheets, inspect the tab name and repeat the setup on each sheet that needs its own pagination.

Finally, distinguish a command problem from a preview problem. A break may have been inserted successfully, but the result can look unchanged if Excel is scaling the sheet to a fixed page count or if the break is outside the print area. Confirm the scaling, active sheet, and print area before deleting and reinserting the break repeatedly.

Excel for Mac and Excel for the web

In Excel for Mac, the same basic approach applies: use View > Page Break Preview, select the row or column at the intended boundary, and use the page-break command on the Page Layout tab. Ribbon labels and dialog details can vary slightly by release, so if you do not see the command, check that the desktop app is showing its Page Layout controls and that the sheet is not protected. The Windows shortcuts for switching ribbon tabs are not a reliable Mac equivalent; use the menu or ribbon instead.

Excel for the web has more limited page-layout controls than the desktop app, and it may not offer the same manual-break workflow. If you need to insert, move, or troubleshoot manual breaks and the command is not available in the browser, choose Open in Desktop App and make the changes in Excel for Windows or Mac. You can then save the workbook and return to the browser. In either environment, check the print preview before printing because the browser’s available print controls may not expose every desktop page-setup option.

A reliable way to troubleshoot the printout

When several settings may be involved, change them in a deliberate order rather than adjusting everything at once. First confirm the correct worksheet and print area. Next check scaling and choose whether you want Excel to fit the sheet to a page count or preserve manual pagination. Then check paper size, orientation, and margins. Finally, add or move breaks in Page Break Preview and inspect the result through File > Print.

For example, if a monthly report should print with rows 1–25 on the first page and rows 26–50 on the second, select row 26 and insert a horizontal break. If the preview still shows all 50 rows squeezed onto one page, inspect Fit to scaling rather than inserting another break. If the break appears but the second page starts at a different row after changing to landscape, the page layout has changed; adjust the break after confirming the desired orientation and margins.

This sequence also helps separate layout decisions from printing decisions. Excel can show the intended pages in preview, but the physical result still depends on the selected printer and its supported paper settings. If a printer substitutes a paper size or reports a different printable area, compare the print dialog’s paper selection with the worksheet’s Page Layout settings before changing the worksheet breaks again.

Frequently Asked Questions

Why is Insert Page Break grayed out in Excel?
Finish editing the active cell, confirm the correct worksheet is selected, and check whether the sheet is protected. Also inspect the scaling settings: Fit to can prevent manual breaks from controlling pagination. If protection is enabled, you may need permission or the password to change the sheet layout.

Why does Excel ignore my manual page break?
The first setting to check is Fit to scaling, which forces the sheet to a target number of pages. Also confirm that the break is within the print area and that you are looking at the intended worksheet. Use Page Break Preview and File > Print to see the actual page division.

How do I insert a page break after a specific row?
Select the row immediately below the desired boundary, then choose Page Layout > Breaks > Insert Page Break. To start a new page after row 25, select row 26. Check Page Break Preview to confirm the line is in the correct place.

How do I remove all page breaks in Excel?
On the Page Layout tab, choose Breaks > Reset All Page Breaks. Excel removes the manual breaks and recalculates automatic ones. This does not delete data, but it does remove every manual break on the active worksheet, including ones you may want to keep.

Can I insert page breaks in Excel for the web?
The browser version has fewer page-layout controls than the desktop app. If you cannot find the manual-break command, open the workbook in the desktop Excel app, set the breaks there, save the workbook, and check the resulting 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.