How to Change Page Breaks in Excel

To change a page break in Excel for Microsoft 365 on Windows, open the worksheet, choose View > Page Break Preview, and drag a blue break line to a new position. To add or remove a break precisely, select the row or column beside the intended break and use Page Layout > Breaks. Page breaks control where printed pages split; they do not change how worksheet cells appear on screen.

What You’ll Need

An Excel workbook with the worksheet you want to print.
Access to the desktop version of Excel for Windows or Mac. Excel for the web has fewer page-break editing controls, so open the workbook in the desktop app if you cannot find the options described below.
A printer is optional. You can check page divisions in Page Break Preview or Print Preview without printing.

Step-by-Step

Open the correct worksheet and check its print setup. Select the worksheet tab containing the data. If you are working with several sheets, make sure you are not editing a different tab by mistake. Before changing breaks, consider the paper size, orientation, margins, and scaling, because those settings determine how much content fits on each printed page. You can find the main controls on the Page Layout tab. For example, use Page Layout > Orientation to choose Portrait or Landscape, and Page Layout > Size to choose a paper size. A different paper size or orientation can shift automatic breaks even if you have not edited them.
Switch to Page Break Preview. Select View > Page Break Preview on the ribbon. Excel shows the worksheet divided into numbered pages, with page-break lines between them. In general, solid blue lines indicate manual page breaks and dashed blue lines indicate automatic breaks that Excel calculates from the current print settings. If a message asks whether to show page breaks, accept it. This view is designed for adjusting pagination; it does not alter cell contents.
Move a break by dragging its line. Point to the blue line you want to change. When the pointer changes to a page-break adjustment pointer, click and drag the line to the row or column where the printed page should end. Drag a horizontal line to change the row division; drag a vertical line to change the column division. Release the mouse button when the preview shows the desired split. Excel treats a manually repositioned break as a manual break, so it can stay in that position until you reset breaks or change settings that affect pagination.
Insert a horizontal break at an exact row. Decide which row should begin the next printed page, then select that row. For instance, to end one page after row 25, select row 26 by clicking its row heading. Choose Page Layout > Breaks > Insert Page Break. Excel inserts a horizontal break above the selected row. If you select an individual cell instead of a whole row, Excel can insert breaks both above and to the left of that cell, so selecting a full row makes the intended horizontal change clearer.
Insert a vertical break at an exact column. Select the column that should start the next printed page. To end a page after column C, select column D by clicking its column heading. Choose Page Layout > Breaks > Insert Page Break. The vertical break is placed to the left of the selected column. This is useful when a wide table needs to print in separate groups of columns. If you select an individual cell, Excel may create both a horizontal and a vertical break at that location.
Remove one break that you no longer need. To remove a horizontal break, select the row immediately below it. To remove a vertical break, select the column immediately to its right. Then choose Page Layout > Breaks > Remove Page Break. In Page Break Preview, confirm that the line is gone or has returned to an automatic division. Removing a manual break does not necessarily make the entire sheet fit on one page; Excel may place an automatic break elsewhere according to the print settings.
Reset all manual breaks if the layout has become confusing. Choose Page Layout > Breaks > Reset All Page Breaks. This removes the worksheet’s manual page breaks and lets Excel calculate breaks again. Use this when several edits have made it difficult to identify which lines are manual. It resets breaks on the active worksheet, so check that the correct sheet is selected first. You can then add back only the breaks you still need.
Review the result before printing. In Page Break Preview, check the page numbers and make sure rows or columns that belong together have not been split awkwardly. Then choose File > Print, or press Ctrl+P on Windows, to inspect the print preview. On Mac, use Command+P to open the print dialog. If the preview does not match what you expected, return to the worksheet and check the break positions, print area, paper size, orientation, margins, and scaling.
Return to a normal worksheet view when finished. Choose View > Normal to leave Page Break Preview. The page-break adjustments remain in place for printing. If you want to see the sheet’s print-page arrangement without the large page labels and editing lines, use View > Page Layout, or check File > Print for the final print preview.

Excel for Mac has comparable page-break controls in its desktop ribbon, although their placement or labels can differ slightly between builds. Look for Page Break Preview under View and the break commands under Page Layout. In Excel for the web, available print and page-layout options may not include the full manual-break editing workflow. If the Breaks commands are missing or disabled, choose the option to open the workbook in the desktop app rather than trying to edit the breaks in the browser.

Common Mistakes

Confusing a page break with a cell border. Page-break lines appear in Page Break Preview and affect printing. A border is cell formatting and can appear in the worksheet and on printouts. Changing a border will not move a page division.
Selecting the wrong row or column. A horizontal break goes above the selected row, and a vertical break goes to the left of the selected column. Select the row or column that should begin the next page, not the last one that should remain on the previous page.
Expecting the break to control screen scrolling. Page breaks are print-layout instructions. They do not freeze rows, split the window, or change where the worksheet scrolls. Use View > Freeze Panes for keeping headings visible while scrolling; that is a separate feature.
Moving a break without checking scaling. If the sheet is set to fit on one page or to fit to a specific number of pages, Excel may shrink the content or recompute pagination. A break can appear to have little effect when scaling is overriding the layout you expect.
Resetting breaks on the wrong sheet. Breaks are set per worksheet. Selecting Reset All Page Breaks while another tab is active will reset that sheet’s manual breaks instead of the one you meant to fix.

Tips

Plan page divisions around the data. For a table with a heading row, try to keep the heading and its first data rows together. If a table spans several printed pages, repeat the heading rows using Page Layout > Print Titles rather than inserting a separate break after every page just to repeat labels.
Use both horizontal and vertical breaks for wide reports. A vertical break can keep a set of key columns together, while horizontal breaks can separate sections by rows. Check the combined page grid in Page Break Preview so the resulting pages are readable and not excessively small.
Set the print area before fine adjustments. If only part of a worksheet should print, select the intended cells and choose Page Layout > Print Area > Set Print Area. Breaks outside the print area may not affect the printed output you review. Clear or redefine the print area if the preview omits information.
Make small changes, then recheck the preview. Page size, margins, font size, hidden rows or columns, and column widths can all alter pagination. Adjust one relevant setting at a time so you can identify what changed the page layout.
Keep a copy before major layout changes. Page-break edits are usually easy to reverse with Undo, but print settings and multiple changes can become hard to track. Saving a separate copy is a simple safeguard when preparing a report for an important print run.

Troubleshooting

The Breaks command is unavailable or greyed out. First, confirm that you are in the desktop version of Excel and that the worksheet is active. If the workbook is in a mode or format that restricts editing, try saving it as an Excel workbook (.xlsx) if appropriate, or check whether the sheet is protected. A protected worksheet can prevent layout changes. If necessary and authorized, use Review > Unprotect Sheet; a password may be required.

The break moves back or the printed pages still look wrong. Review Page Layout settings, especially the Scale to Fit controls, paper size, orientation, margins, and print area. Scaling to fit one page wide or one page tall can change how the worksheet is divided. In Page Layout, check the Width and Height options in the Scale to Fit group; set them to Automatic if you want page breaks to determine the page count without forcing the sheet to a fixed number of pages. Then inspect Page Break Preview and File > Print again.

A page is blank or contains only a few columns or rows. Look for an accidental manual break, a print area that extends beyond the data, or blank formatted cells that expand the used print range. In Page Break Preview, remove an unnecessary break or use Page Layout > Breaks > Reset All Page Breaks to start over. Check the print area through Page Layout > Print Area; use Clear Print Area if the selected area is wrong. Also inspect the print preview for hidden rows or columns that may affect what is included.

You cannot see the page-break lines. Switch to View > Page Break Preview and make sure you are viewing the correct worksheet. If you are in Normal view, automatic page breaks may be shown differently or not be as easy to adjust. If the workbook is open in a browser, open it in desktop Excel to use the full page-break editing tools. After changing settings, give Excel a moment to recalculate the preview.

Frequently Asked Questions

How do I change a page break without adding a new one?
Open View > Page Break Preview and drag the existing blue line to the new row or column boundary. Check the print preview afterward because scaling and page setup can affect the final pages.

How do I add a page break between two rows?
Select the row that should begin the next page, then choose Page Layout > Breaks > Insert Page Break. Excel places the horizontal break above that selected row.

Can I remove just one page break?
Yes. 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. Use Reset All Page Breaks only when you want to clear all manual breaks on the active worksheet.

Why does Excel show dashed and solid page-break lines?
Dashed lines generally mark automatic breaks that Excel calculated from the current sheet and print settings. Solid blue lines generally mark manual breaks that have been inserted or moved. The preview can change when you adjust paper size, orientation, margins, or scaling.

Will changing a page break change how the spreadsheet looks on screen?
No. It changes where the worksheet is divided when printed or exported to a print-ready format. It does not change cell values, formatting, or the regular worksheet layout.

Can I edit page breaks in Excel for the web?
Some print settings are available in the browser, but the full desktop page-break controls may not be. If you cannot find Page Break Preview or the Breaks menu, open the workbook in Excel for Windows or Mac and make the adjustments there.

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.