Excel Page Break Preview: Add and Move Page Breaks

To add a page break in Excel for Microsoft 365 on Windows, select the row below or the column to the right of the desired break, then choose Page Layout > Breaks > Insert Page Break. To see and adjust the result, choose View > Page Break Preview; you can also drag a break line to move it.

What Page Break Preview shows

Page Break Preview is a worksheet view for arranging how cells divide across printed pages. It displays the printable pages as separate regions, usually with blue boundaries and page-number labels over the sheet. It is useful when a table, report, or schedule must be split at particular rows or columns rather than wherever Excel happens to place a boundary.

Excel creates automatic page breaks based on the paper size, margins, orientation, scaling, and the content in the worksheet. These breaks can change when you alter those settings. A manual page break is one you insert or move yourself. In Page Break Preview, solid blue lines generally indicate manual breaks, while dashed blue lines indicate automatic breaks. The page-number labels are guides; they do not print on the worksheet.

A page break does not insert a blank worksheet page or move data into a new sheet. It tells Excel where to start a new printed page. The cells remain in their original rows and columns, and changing a break does not change the worksheet’s data.

Add a page break with the ribbon

Use the following steps in desktop Excel for Windows. First decide whether the printed page should end after a particular row or column. Then select the row below that point or the column to its right. This selection rule is important: Excel inserts a horizontal break above a selected row and a vertical break to the left of a selected column.

Choose View > Page Break Preview if you want to see the page boundaries while you work. You can insert a break from other worksheet views too, but Preview makes its location easier to check.
For a horizontal break, click the row number immediately below the row where the next printed page should begin. For example, to start the next page at row 36, select row 36.
For a vertical break, click the column letter immediately to the right of the column where the next page should begin. To start a new page at column H, select column H.
Choose Page Layout > Breaks > Insert Page Break.
Check the blue boundary. If you selected a single cell inside the worksheet instead of a full row or column, Excel can insert both a horizontal break above that cell’s row and a vertical break to the left of its column.

For instance, suppose a sales report has one row per month and columns for region, revenue, and notes. Selecting the row where a new group of months should begin and inserting a break can keep each group together on paper. If the columns extend beyond the paper width, a vertical break may split the table, but that is often less readable than fitting the columns to one page wide.

Add or move a break by dragging

Page Break Preview also lets you position boundaries directly. To move a break, point to its blue line and drag it to the new row or column boundary. Drag a horizontal line up or down to change where pages divide by rows; drag a vertical line left or right to change the division by columns. The page labels update to reflect the new arrangement.

Dragging is convenient for visual adjustments, such as moving a page boundary so a section heading stays with the rows that follow it. It can also make a page shorter or narrower than the available paper area, so inspect the resulting page count and printed scale. If dragging a boundary is difficult, zoom in or use the ribbon command after selecting the relevant row or column.

Dragging an automatic break changes its location for the current layout, effectively making it a manual break. If you later change paper size, margins, or scaling, the surrounding automatic divisions may move. Review the preview again after making those changes.

Understand horizontal and vertical breaks

A horizontal page break starts a new printed page below a row. It is useful for separating sections, preventing a subtotal from appearing at the top of a page without its preceding detail, or ensuring each department begins on a fresh page. A vertical page break starts a new printed page to the right of a column. It can divide a very wide worksheet, although readers may have to compare information across multiple sheets of paper.

When a break is inserted at a selected cell, Excel can create both kinds at once: the horizontal boundary is above the cell’s row and the vertical boundary is left of its column. If you only want one direction, select a whole row for a horizontal break or a whole column for a vertical break before using Insert Page Break. This avoids unintentionally splitting the worksheet in both directions.

Page breaks apply to the sheet’s print layout, not to screen scrolling or the way cells are stored. They also do not guarantee that every page will contain a particular amount of text. Row heights, column widths, font sizes, and scaling all affect what fits between boundaries.

Check print settings before placing breaks

Manual breaks make the most sense after the basic print layout is set. A break positioned for letter-size paper in portrait orientation may be misplaced if you later switch to landscape or use a different paper size. Before refining breaks, check these settings on the Page Layout tab:

Orientation: Portrait is usually suitable for long lists; landscape can help with wide tables.
Size: Choose the paper size that will actually be used by the printer or print service.
Margins: Larger margins leave less printable space and can increase the page count.
Scale to Fit: Check the width and height settings. Fitting a wide report to one page can shrink text considerably.
Print Area: If a print area is set, Excel prints that selected region rather than every used cell on the sheet.

For example, a report that is one column too wide may be clearer in landscape orientation or with a smaller margin than with a manual vertical break that splits the table. If the report must fit across one page, use the width setting in Page Layout > Scale to Fit and then inspect the text size. Excel’s Fit to options can override manual page-break placement, so do not assume that a manually drawn boundary will control pagination while the sheet is being forced to fit a specified number of pages.

Fix common page-break problems

If an inserted break seems to do nothing, check whether the selected row or column is the one immediately after the intended boundary. A break above row 36 means row 36 begins the next page; selecting row 35 would put the break above row 35 instead. For a vertical break, select the column that should begin on the next page.

If breaks move after you insert them, review paper size, orientation, margins, scaling, and print area. These settings influence automatic pagination, and a change to any of them can alter the layout. Also confirm that you are viewing the intended worksheet: page breaks are sheet-specific, so a break on one tab does not automatically apply to another.

If the printed text is tiny, the issue may be scaling rather than the break location. A setting that fits a large worksheet to one page can reduce the whole sheet to an unreadable size. Try fitting to one page wide while allowing multiple pages tall, or adjust orientation and margins. Use File > Print to inspect the print preview before sending the job.

If a row or column appears to be missing, check whether it lies outside a defined print area or is hidden. A page break controls where printed pages divide; it cannot make excluded or hidden content appear. Likewise, setting a print area does not insert a break at every section boundary.

Remove or reset page breaks

To remove one manual break, select the row below a horizontal break or the column to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. If selecting a cell at the intersection is more convenient, select that cell and use the same command to remove the relevant break or breaks associated with that position. Verify the result in Page Break Preview.

To clear manual breaks across the worksheet, choose Page Layout > Breaks > Reset All Page Breaks. This restores Excel’s automatic pagination for the sheet; it does not delete worksheet data. Automatic breaks will still appear because Excel must divide a multi-page printout somehow. Resetting breaks is a useful starting point when a sheet has accumulated many adjustments and the page layout is difficult to understand.

Page Break Preview versus Print Preview

Page Break Preview is for changing the worksheet’s page divisions. Print Preview, reached through File > Print, is for checking how the pages are likely to look when printed, including scaling and page order. Use both: make structural changes in Page Break Preview, then inspect the final paper layout in Print Preview.

Neither view changes the worksheet’s content. If you need different headers, footers, repeating title rows, or margins, use the relevant page-layout or print settings rather than adding breaks. For example, a long table often benefits from repeating its header row on every printed page; a page break alone does not repeat that row.

Mac and Excel for the web

In Excel for Mac, the same general approach applies: use View > Page Break Preview to inspect boundaries and the Page Layout break controls to insert or remove manual breaks. Ribbon labels and their placement can differ slightly between Mac builds, so look for the Breaks command on the Page Layout tab if the Windows path is not displayed exactly.

Excel for the web does not offer the same complete manual page-break editing workflow as the desktop application. If you need to insert or drag manual breaks, open the workbook in desktop Excel. You can still use the web version for many worksheet edits, but check its print settings and preview separately because print controls may differ from the Windows desktop interface.

Frequently Asked Questions

Can I add a page in Page Break Preview?
Excel does not add a blank worksheet page as a separate object. Insert a page break to make the next row or column begin on a new printed page; the page count then reflects the revised layout.

Why is Insert Page Break unavailable?
Check that you are working in a worksheet rather than a chart sheet, and that the workbook is not in a state that prevents editing. If the command remains unavailable, switch to a standard worksheet view and check whether the sheet or workbook is protected.

What is the difference between a dotted and solid blue line?
In Page Break Preview, a dashed line generally marks an automatic break calculated by Excel. A solid blue line generally marks a manual break that was inserted or moved by a user.

Does inserting a page break change my worksheet data?
No. It changes the print layout, not cell values, formulas, or the location of data. Removing or resetting breaks also leaves worksheet content intact.

How do I make a wide worksheet print on one page?
Use the width control under Page Layout > Scale to Fit or a fit-to-page option in print settings, then check readability in File > Print. A manual vertical break is not the same as fitting all columns onto one page.

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.