Create a Page Break in Excel: Steps and Print Tips

To create a page break in Excel for Microsoft 365 on Windows, select the cell below and to the right of where you want the new page to begin, then choose Page Layout > Breaks > Insert Page Break. Excel inserts a horizontal break above the selected cell and a vertical break to its left; use Page Break Preview to check how the worksheet will print.

What a Page Break Does in Excel

A page break marks where Excel divides a worksheet when it prints or creates a print-ready file. A horizontal break starts a new printed page below a particular row. A vertical break starts one to the right of a particular column. You can use one kind of break or both, which is useful when a wide table needs to be split into sections across more than one sheet of paper.

Excel also creates automatic page breaks based on the paper size, margins, orientation, print area, and scaling settings. These breaks are not fixed until you adjust the layout, so a change such as switching from portrait to landscape can move them. A manual break tells Excel where you want a split, but it does not guarantee that a particular row or column will fit on one page if other print settings force the content to shrink or span additional pages.

Insert a Horizontal or Vertical Break

First decide which row or column should start on the next page. The selected cell’s position determines where Excel inserts the break: above it and to its left. For example, to have row 21 begin on a new printed page, select a cell in row 21 and insert a page break. To have column D begin on a new page, select a cell in column D.

Select the cell at the intersection of the row and column where you want the page to begin. For a horizontal break only, select a cell in the target row. For a vertical break only, select a cell in the target column.
Open the Page Layout tab on the ribbon.
Choose Breaks in the Page Setup group, then select Insert Page Break.
Check the result in View > Page Break Preview or in the print preview.

If you select cell D21, Excel can insert a horizontal break above row 21 and a vertical break to the left of column D. This divides the print layout at that intersection. If you only want one direction, choose a cell in the relevant row or column and make sure the other direction is not being split unintentionally. A simple worksheet may need only one horizontal break, while a wide report may need vertical breaks as well.

See Where Pages Will Split

Page Break Preview makes the print layout easier to understand than the normal worksheet grid. Choose View > Page Break Preview. Excel shows page boundaries over the sheet, with page numbers in the background. Automatic breaks are generally shown as dashed lines, while manually inserted breaks appear as solid lines. The preview helps you spot when a heading is stranded at the bottom of one page or a table is split in an inconvenient place.

In this view, you can drag a page-break line to a different row or column. Dragging an automatic break changes the layout by creating a manual break at the new position. If the sheet looks crowded, use the displayed page numbers and boundaries to judge whether moving a break improves the result. Return to the regular worksheet view with View > Normal.

For a final check, open File > Print. The preview shows how the current print settings will divide the pages. It is worth checking more than the first page: use the preview controls to inspect later pages, especially when the worksheet has many rows or columns. Page Break Preview and print preview complement each other; the former is useful for editing boundaries, while the latter reflects the print output more directly.

Move, Remove, or Reset Page Breaks

To move a break, open Page Break Preview and drag its line to the desired row or column. If the line cannot be moved where you expect, review the page’s scaling and print settings. Excel may need to fit or divide content differently based on those settings.

To remove a single break, 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. If the break is at an intersection, handle the horizontal and vertical boundaries separately when necessary, checking the preview after each change. To clear manual breaks throughout the worksheet, choose Page Layout > Breaks > Reset All Page Breaks. Resetting removes the manual layout choices and lets Excel calculate automatic breaks again.

Removing a manual break does not remove worksheet rows or columns, and it does not erase data. It changes only the print division. Likewise, resetting breaks does not restore other print settings such as margins, paper size, or scaling; those are separate controls.

Make Breaks Work with Print Settings

A page break is only one part of preparing a worksheet for printing. Before adding several manual breaks, check the settings that determine how much content fits on each page:

Orientation: Choose Page Layout > Orientation > Portrait or Landscape. Landscape can help a wide table fit across a page, though it may change the positions of automatic breaks.
Paper size: Choose Page Layout > Size and select the paper you will actually use. A mismatch between the workbook’s paper setting and the printer’s paper can alter the output.
Margins: Choose Page Layout > Margins to select a preset or adjust margins through the page setup options. Smaller margins may make room for more content, if suitable for the printer.
Scaling: In the Page Layout tab’s Scale to Fit controls, adjust Width or Height when you want Excel to fit content to a chosen number of pages. Forcing a large sheet onto one page can make text too small to read.
Print area: Select the cells to print, then choose Page Layout > Print Area > Set Print Area. This can keep notes, helper columns, or unused parts of a sheet out of the printed output.

For instance, imagine a sales report with a heading row and a long list of orders. If the first page ends with only one or two rows of a new section, inserting a horizontal break before that section may make the report clearer. If the table is also too wide, first consider landscape orientation or fitting it to one page wide. Adding a vertical break without considering readability could instead print the left and right halves on separate sheets, making comparisons harder.

Common Page-Break Problems

The break seems to be in the wrong place. Confirm which cell was selected before inserting it. Excel places the break above and to the left of that cell, not below or to its right. Use Page Break Preview to see the exact boundary.

A change to orientation moved the breaks. This is expected when the available printable area changes. Review the boundaries again after changing paper size, margins, or orientation. A break that looked sensible in portrait mode may no longer divide the pages well in landscape mode.

The worksheet prints on more pages than expected. Check for a large print area, extra used cells, narrow page dimensions, and scaling choices. A stray entry or formatting far from the main table can sometimes extend the area Excel considers part of the sheet. Print preview can reveal unexpected blank or nearly blank pages.

Text becomes too small after setting a page limit. Fitting a wide or long worksheet to one page can shrink everything. Instead, allow more pages, use landscape orientation for wide tables, or adjust the print area. A readable multi-page report is often more useful than a single page with tiny text.

A manual break appears to have disappeared. A manual break can be reset, or changes to print settings can make the displayed page layout different. Reopen Page Break Preview and check whether the boundary is still present. If needed, insert it again after settling on paper size, margins, and scaling.

Excel on Mac and Excel for the Web

In Excel for Microsoft 365 on Mac, the ribbon layout and names can vary slightly by version, but the page-break controls are available through the Page Layout tab’s Breaks menu, and Page Break Preview is available from the View tab. Use the same selection principle: the break is placed above and to the left of the selected cell. For printing, Command+P opens the print dialog on Mac; on Windows, use Ctrl+P.

Excel for the web has more limited page setup controls than the desktop app and may not show the same manual Breaks commands. If you need to insert, drag, or reset manual page breaks, open the workbook in the desktop version of Excel. You can then save the workbook and return to the browser for other editing. Always check the print preview in the version you plan to use for printing, because available controls and printer options can differ.

When to Use a Page Break Instead of Scaling

Use a manual page break when a particular row or column should begin a new printed page—for example, to keep a new department’s heading with its data or to separate a summary from detail rows. Use scaling when the priority is controlling the overall number of printed pages, such as fitting a table to one page wide. Use both thoughtfully: scaling affects the space available and can change the practical result of a manual break.

Another option is to adjust the worksheet for printing rather than forcing a break. You might repeat column headings on each page, change orientation, or define a print area. Page breaks are best for controlling where a page ends; they are not a substitute for legible formatting or a well-chosen print area.

Frequently Asked Questions

How do I insert a page break in Excel?
Select the cell below and to the right of the intended page start, then choose Page Layout > Breaks > Insert Page Break. Excel inserts a break above the selected cell and to its left.

Can I insert a page break between two rows?
Yes. Select a cell in the row that should start the next printed page and insert the break. The horizontal boundary is placed above that row.

How do I remove a page break in Excel?
Select a cell below a horizontal break or to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. Use Reset All Page Breaks to clear manual breaks on the worksheet.

Why can’t I see my page breaks?
Switch to View > Page Break Preview, or open File > Print to inspect the page layout. In Normal view, page boundaries may be less obvious, and automatic breaks can change when print settings change.

Does inserting a page break change the worksheet data?
No. It changes how Excel divides the sheet for printing; it does not move, delete, or edit cell contents. The print layout may still change if you later adjust scaling, margins, orientation, or paper size.

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.