Excel Insert Page Breaks: Steps, Options, and Fixes

To insert a page break in Excel for Microsoft 365 on Windows, select the row below or column to the right of the desired break, then choose Page Layout > Breaks > Insert Page Break. Excel inserts a horizontal break above the selected row, a vertical break to the left of the selected column, or both when you select a cell.

What a page break does in Excel

A page break marks where Excel should begin a new printed page. It changes the layout of the printout, not the worksheet itself: your cells, formulas, and data remain where they are. This is useful when a report, roster, or table would otherwise split at an awkward point, such as halfway through a group of related rows.

Excel creates automatic page breaks based on factors such as the paper size, page orientation, margins, scaling, and the amount of content. These are not promises that a particular row will always land on a particular page; changing the print setup can move them. A manual page break gives you more control over where printing continues, subject to the worksheet’s other print settings.

In Page Break Preview, automatic breaks appear as dashed lines and manual breaks as solid lines. This view helps distinguish Excel’s default pagination from boundaries you have set yourself. The lines are print-layout guides, not borders that will appear around cells on paper.

Insert a horizontal or vertical page break

First decide which content should stay together and where the next printed page should begin. Then use the selection that corresponds to the break you need:

Start a new page above a row: select a cell in the row that should begin the next page. Excel places a horizontal break above that row.
Start a new page to the left of a column: select a cell in the column that should begin on the next page. Excel places a vertical break to its left.
Break both above and to the left of a cell: select that cell. Excel creates a horizontal and a vertical break at its top and left edges.

With the selection in place, go to Page Layout > Breaks > Insert Page Break. For example, to make row 26 the first row on a new printed page, select a cell in row 26 before inserting the break. If columns A through D should print separately from column E onward, select a cell in column E.

If you select an entire row or column, Excel inserts the corresponding break before it. Selecting a cell in the first row or first column cannot create a useful break above or to the left of the worksheet’s starting edge. If you need several page boundaries, insert them one at a time and check the result in Page Break Preview.

Check the result in Page Break Preview

Page Break Preview shows how the worksheet is divided into printed pages and makes it easier to see whether a break landed where you intended. In Excel for Windows, choose View > Page Break Preview. You can also open the View tab and select the Page Break Preview option in the workbook views. Excel may display a prompt about adjusting page breaks when you first enter this view.

Look at the page boundaries and the page numbers. If a heading is stranded at the bottom of one page while its table starts on the next, move the break so the heading and table begin together. If the preview shows too many pages across, consider switching the page orientation to landscape or adjusting the print scaling before adding more manual breaks.

To return to the ordinary worksheet display, choose View > Normal. Page breaks can also be viewed in Normal view, but Page Break Preview is generally clearer for checking the complete printed layout. To see the final print rendering, use File > Print and review the preview before printing or saving as a PDF.

Move, remove, or reset page breaks

In Page Break Preview, you can drag a break line to a different row or column boundary. Dragging an automatic break can turn it into a manual break. If a line is difficult to select, zoom in or click near the boundary rather than on a cell value. After moving a break, check the page numbers again: changing one boundary can affect how the remaining content is divided.

To remove one manual break, select the cell immediately below a horizontal break or immediately to the right of a vertical break. Then choose Page Layout > Breaks > Remove Page Break. To clear manual breaks from the worksheet, choose Page Layout > Breaks > Reset All Page Breaks. Resetting removes the manual boundaries; Excel recalculates the automatic ones from the current print setup.

These commands affect page breaks, not cell contents or formatting. If the menu options are unavailable or the layout does not respond as expected, check that you are working in a worksheet rather than a chart sheet, and review any worksheet protection or print settings that might restrict what you can change.

Understand how print settings affect breaks

A page break does not determine the entire printed layout on its own. Excel also considers the worksheet’s print area, paper size, orientation, margins, and scaling. For instance, a wide table may be split across several pages horizontally even if you have inserted only horizontal breaks. A defined print area can also exclude rows or columns you expected to print.

Review the relevant settings on the Page Layout tab. Print Area controls which cells are included, Orientation switches between portrait and landscape, and the options under Scale to Fit control how many pages wide or tall the output should be. You can also open the Page Setup dialog from the small dialog launcher in the Page Setup group for additional settings, including paper size and margins.

Scaling deserves particular attention. If you set a sheet to fit a specified number of pages, Excel may shrink or expand the output to meet that target, so a manual break may not produce the page division you expected. If precise manual pagination matters, use the fit-to-page settings thoughtfully and inspect the preview after changing them. A one-page-wide setting can help keep columns together, but it may make text too small to read.

Other print options can change what appears on each page. Repeating title rows, for example, prints chosen headings again on subsequent pages; those repeated rows take up space and can affect how much data fits on a page. Hidden rows and columns, print titles, and changes to the selected print area are also worth checking when a page seems unexpectedly blank or crowded.

Fix common page-break problems

The break appears in the wrong place: confirm which row or column you selected. The break is placed above the selected row and to the left of the selected column, not below or to the right.
The page count changes after editing: inspect orientation, margins, paper size, scaling, and print area. Even a small change to column width can alter pagination.
A manual break seems to disappear: check whether fit-to-page scaling is active, then review the layout in Page Break Preview. Reinsert the break after adjusting the scaling settings if needed.
The printout contains blank pages: look for stray formatting or content far beyond the main data, an oversized print area, or page breaks that leave a mostly empty page. Use the print preview to identify which pages are affected.
Text is cut off or too small: widen columns, wrap text, change orientation, or adjust margins before relying on aggressive scaling. A page break cannot make a column wider or improve the readability of text that has been scaled down.

When a workbook is shared, remember that print results can differ if another person uses different paper settings or a different printer. Save the workbook after checking its layout, and ask the recipient to review their own print preview rather than assuming every device will paginate identically.

When manual page breaks are useful

Manual breaks work best when the printed document has natural sections. For example, a monthly report might start each department on a new page, or a class list might keep each class together instead of splitting in the middle. They are less helpful when the worksheet changes frequently: adding rows above a break or changing column widths can make a carefully arranged layout need attention again.

For a large or regularly updated report, consider whether changing the page orientation, margins, scaling, or print area would solve the problem more reliably. If the goal is to make a table easier to read on screen, page breaks are not the right tool; they influence printed pages rather than worksheet navigation or the way data is displayed in Normal view.

Excel on Mac and Excel for the web

In Excel for Mac, page-break controls are available in the desktop application, although the ribbon arrangement can differ slightly from Windows. Look for Page Layout > Breaks to insert, remove, or reset breaks, and use the View controls to inspect the page layout. Menu names and placement can vary with the Excel version, so the Windows ribbon path may not match the Mac interface exactly.

Excel for the web does not provide the same complete set of manual page-break editing controls as desktop Excel. If you need to insert, move, or reset specific breaks, open the workbook in the desktop app. You can then save the workbook and return to the browser. In either environment, use print preview to check how the worksheet will appear before printing.

Frequently Asked Questions

What is the shortcut to insert a page break in Excel?
There is no single standard Ctrl-key shortcut for inserting a page break. On Windows, select the appropriate row, column, or cell and use Page Layout > Breaks > Insert Page Break. Ribbon KeyTips can vary, so the menu path is the dependable method.

How do I insert a page break after a specific row?
Select a cell in the row that should start the next page, then choose Page Layout > Breaks > Insert Page Break. Excel places the horizontal break above that row. To start a new page after row 25, select a cell in row 26.

Can I add a page break between columns?
Yes. Select a cell in the column that should begin the next printed page, then insert a break. Excel places the vertical boundary to the left of that column. Check Page Break Preview to confirm that the columns are divided as intended.

How do I remove all page breaks in Excel?
Choose Page Layout > Breaks > Reset All Page Breaks. This removes manual page breaks and lets Excel calculate automatic breaks using the current print settings. It does not delete worksheet data.

Why does Excel ignore my manual page break?
Fit-to-page scaling, other print settings, or a changed worksheet layout can affect the result. Check the Scale to Fit options, print area, and Page Break Preview. If the workbook is open in Excel for the web, use the desktop application for full manual page-break controls.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.