Excel Page Breaks: How to Set, Move, and Remove Them

To set a page break in Excel for Microsoft 365 on Windows, select the cell where the next printed page should begin, then choose Page Layout > Breaks > Insert Page Break. Excel adds a horizontal break above the selected row and a vertical break to the left of the selected column; use Page Break Preview to check and adjust the result before printing.

How Excel page breaks work

A page break marks the boundary between printed pages. Excel creates automatic breaks based on factors such as the worksheet’s printable area, paper size, orientation, margins, and scaling. These breaks are recalculated when those settings or the amount of content change. A manual break is one you insert or move to control where a page ends; it stays in place unless you change or reset it, although scaling and other print settings can affect the final output.

Page breaks apply to printed or exported pages, not to the worksheet’s cell layout. Adding one does not move data, insert a row, or change what appears on screen in Normal view. In Page Break Preview, solid blue lines usually indicate manual breaks and dotted blue lines indicate automatic breaks. The worksheet may show page numbers and shaded areas to help you see how the printout is divided.

For example, if a report has a heading in row 18 that should start on a new page, select a cell in row 18 and insert a break. The break runs across the sheet above that row. If columns A through D should print on one page and column E should begin another, select a cell in column E and insert a break; it appears to the left of that column.

Insert a manual page break

Use the desktop version of Excel when you need precise control over page boundaries. Before inserting breaks, confirm that you are working in the correct worksheet and have a rough idea of the print layout. These steps apply to Excel for Microsoft 365 on Windows:

Select a cell in the row where the new page should start, or in the column where the next page should begin. To add both a horizontal and vertical break at once, select a cell below and to the right of the intended boundaries.
Open Page Layout > Breaks > Insert Page Break.
Choose View > Page Break Preview to inspect where Excel placed the break and whether it created the intended pages.
Return to the worksheet or adjust the break in Page Break Preview if the split is not quite right.

Excel places a horizontal break above the active cell’s row and a vertical break to the left of its column. The first row and first column do not have a preceding worksheet area in which to insert a break, so select a cell farther down or to the right. If you select a cell such as D18, Excel can add breaks above row 18 and left of column D. Consider whether that creates extra pages you do not want before using a two-direction break.

On Excel for Mac, the Page Layout tab also provides the Breaks commands; the precise ribbon arrangement can vary slightly by release. Excel for the web does not offer the same full controls for inserting and moving manual breaks. If those commands are unavailable, open the workbook in the desktop app to set them.

Move, remove, or reset breaks

To reposition an existing break, switch to View > Page Break Preview, point to the blue line, and drag it to the new row or column boundary. A horizontal break can be moved up or down; a vertical break can be moved left or right. When moving a line, watch the shaded page areas: moving a boundary may change the number of pages or make a page too wide or too tall.

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. If removing a break in Page Break Preview, select a cell on the appropriate side of the boundary and use the same ribbon command. The nearby cell selection matters because Excel uses it to identify which break to remove.

To clear manual breaks throughout the active sheet, choose Page Layout > Breaks > Reset All Page Breaks. This returns the sheet to automatic pagination; it does not erase worksheet contents. Resetting is useful when a workbook has accumulated many manual boundaries and it is easier to start over. It is different from removing one break, so check the sheet first if other manually placed breaks are still needed.

Use Page Break Preview to plan pages

Page Break Preview is the most useful view for understanding how a worksheet will divide. Choose View > Page Break Preview. Excel displays page boundaries and may show page numbers over the sheet. Dragging a boundary changes the printed area assigned to each page, while the cells themselves remain where they are. To return to the usual grid, choose View > Normal.

Use the preview to check more than the position of one line. Look for headings stranded at the bottom of a page, totals separated from the rows they summarize, narrow columns pushed onto a mostly empty page, or blank pages caused by formatting far from the main data. If you see a problem, decide whether the best fix is a manual break, a print-area adjustment, a page orientation change, or a scaling change. A manual break is not always the right solution.

Page Break Preview can make a large worksheet look crowded because it displays boundaries over the grid. That view is a planning aid, not a permanent change to the worksheet’s formatting. The final printout can still differ if you change the printer, paper size, margins, or scaling after arranging breaks. Recheck the preview after changing those settings.

Choose where a page should end

Manual breaks are most helpful when page boundaries should follow the meaning of the information rather than simply the amount of content that fits. Good locations often occur before a new report section, a monthly table, a group of records, or a repeated block of calculations. If a printed page should start with a clear heading, place the break above that heading rather than splitting the heading from its rows.

Before inserting one, consider these practical questions:

Will the page still be readable? A break that keeps a section together may leave very little content on the preceding page.
Are the columns meant to stay together? A vertical break can divide a table so that readers have to compare pages to understand one record.
Will the layout survive updates? If rows are frequently added or removed, a manually fixed boundary may need maintenance.
Could print settings solve the problem more simply? Landscape orientation, narrower margins, or a defined print area may produce a cleaner result than many breaks.

For a simple one-page summary, it may be better not to add manual breaks at all. For a multi-section report that is printed regularly, deliberate boundaries can make the output more consistent. The right choice depends on whether preserving a particular grouping matters more than letting Excel flow the content automatically.

Understand scaling and other print settings

Scaling changes how much worksheet content Excel fits onto a printed page. In the Page Layout tab, the Scale to Fit controls let you specify a page width or height; for example, setting the width to one page can keep all selected columns across a single page. That may shrink the text substantially if the sheet is wide. Check a print preview before using it for a report that people need to read.

Scaling can also affect the apparent placement and usefulness of manual breaks. When a sheet is set to fit a specified number of pages, Excel may scale the content to meet that target, so the resulting pagination may not match the boundaries you expected. If exact manual break placement is important, avoid forcing the entire sheet into a fixed page count; use a scaling percentage or adjust the layout and inspect the preview. If your version’s settings or the workbook’s print behavior seem to conflict with a break, test the output in Print Preview rather than relying only on the grid view.

Other settings matter too. Paper size must match the paper you will print on, and portrait versus landscape changes the available width. Margins reduce the printable area. A print area limits which cells are included; set it with Page Layout > Print Area > Set Print Area. If a sheet uses repeated headings on every page, configure print titles separately; a page break does not make a heading repeat automatically.

Common page-break problems

The page break is in the wrong place. Check whether you selected the intended row or column, then use Page Break Preview to move the line. Also verify that the worksheet has not been scaled to fit a set number of pages, which can change the final layout.

Excel prints an unexpected blank page. Look for stray formatting or content far to the right or below the main table, an oversized print area, or a manual break that creates an almost empty page. Check the preview and reset manual breaks if you cannot identify a useful layout. You can also select the intended cells and set a smaller print area.

A break cannot be dragged where expected. Confirm that you are in Page Break Preview and that you are dragging the blue boundary itself, not a cell edge. If worksheet protection or the current view prevents changes, switch to the desktop app and check the sheet’s protection settings.

The printout does not match the preview you remember. Recheck paper size, printer selection, orientation, margins, scaling, and print area. A different printer may report a different printable region. Page layout can change when these settings change, so preview again immediately before printing or saving a PDF.

Manual breaks keep getting in the way. Use Page Layout > Breaks > Reset All Page Breaks on the affected worksheet, then let Excel paginate automatically. This removes manual breaks from that sheet, so use it only when you are ready to discard those custom boundaries.

Frequently Asked Questions

How do I insert a page break in Excel?
Select a cell in the row or column where the next page should begin, then choose Page Layout > Breaks > Insert Page Break. Excel places the break above the selected row and to the left of the selected column.

What do dotted lines mean in Excel Page Break Preview?
Dotted blue lines generally show automatic page breaks, which Excel calculates from the current sheet and print settings. Solid blue lines generally mark manual breaks that you inserted or moved.

How do I remove a page break without removing all of them?
Select the 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 only when you want to clear every manual break on the sheet.

Why is Excel ignoring my manual page breaks?
Check the sheet’s scaling, print area, and page setup, then inspect Page Break Preview and Print Preview. Fit-to-page settings can change how content is paginated, and changes to paper size, margins, or orientation can alter the result.

Can I set page breaks in Excel for the web?
The web app does not provide the full desktop controls for inserting and dragging manual page breaks. Open the workbook in Excel for Windows or Mac to make precise manual adjustments.

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.