Excel Page Break Reset: How to Restore Defaults

To reset page breaks in Excel for Microsoft 365 on Windows, select the worksheet, then choose Page Layout > Breaks > Reset All Page Breaks. This removes manual page breaks on that sheet and lets Excel place automatic breaks again; it does not clear the print area or reset every print setting.

Reset page breaks in Excel

Page-break settings belong to individual worksheets. If your workbook has several affected sheets, repeat the reset on each one, or select multiple sheet tabs first to apply the command to the grouped sheets. Take care with grouped sheets: changes you make while several tabs are selected can affect all of them.

Click the worksheet tab whose page breaks you want to reset.
Open Page Layout on the ribbon.
Select Breaks in the Page Setup group, then choose Reset All Page Breaks.
To inspect the result, choose View > Page Break Preview, or open File > Print and review the page previews.

The reset command is not the same as removing one break. If you only want to undo a particular manual break, select a cell immediately below the horizontal break or immediately to its right for a vertical break, then choose Page Layout > Breaks > Remove Page Break. Reset All Page Breaks is the broader option when the worksheet’s manual layout has become confusing.

What resetting changes—and what it leaves alone

Excel divides a worksheet into printed pages according to its paper size, orientation, margins, scaling, print area, and the amount of content. It also allows manual breaks that tell Excel where a page should end. Reset All Page Breaks removes those manual instructions for the selected worksheet. Excel then recalculates automatic page breaks using the current print settings and worksheet contents.

The command does not delete cell data, formulas, formatting, or worksheet rows and columns. It also does not necessarily restore a worksheet to the exact print layout it had when the file was first created. For example, a custom paper size, narrow margins, landscape orientation, or a defined print area can still make the automatic page layout look unusual after the reset.

It also does not clear a print area. A print area limits which cells Excel prints; page breaks divide the printable content into pages. If a sheet prints only part of its data, clearing the print area may be relevant. If the whole range prints but breaks at unwanted positions, resetting page breaks is more directly related.

Manual breaks versus automatic breaks

Excel creates automatic page breaks when it calculates how much content fits on each printed page. These positions can change when you edit the sheet, change the paper size, adjust margins, alter scaling, or change the printer. Manual page breaks are inserted by a user and can override where Excel would otherwise divide the worksheet.

In Page Break Preview, Excel distinguishes the two visually: automatic breaks are generally shown as dashed blue lines, while manual breaks appear as solid blue lines. The preview is useful for identifying whether a break was deliberately inserted. A reset removes the manual breaks, but the dashed automatic boundaries remain because Excel still needs to divide the sheet for printing.

That distinction explains a common misconception: a reset does not make a worksheet print as one page. If the sheet is larger than one printable page, Excel will still create automatic breaks unless you change the scaling or print settings. The reset restores automatic pagination; it does not turn off pagination.

Remove or insert only the breaks you need

For a small correction, editing one break is often better than resetting every manual break. In Page Break Preview, you can drag a visible break line to another position. This changes how content is divided for printing, not the position of the worksheet data itself. The resulting page may contain fewer rows or columns than neighboring pages.

You can also select the relevant cell and use the Breaks menu. A horizontal break is placed above the selected cell, and a vertical break is placed to its left. Selecting a cell away from the top-left corner can therefore create both a horizontal and a vertical break. To insert a break across a whole row or column, select the row or column heading before using Page Layout > Breaks > Insert Page Break.

Remove one break: select a cell below or to the right of the break, then choose Page Layout > Breaks > Remove Page Break.
Remove all manual breaks on a sheet: choose Page Layout > Breaks > Reset All Page Breaks.
Change a break visually: use View > Page Break Preview and drag a break line.

Be aware that dragging an automatic boundary in Page Break Preview can turn it into a manual break. If the layout becomes harder to manage, resetting all breaks returns the sheet to automatic breaks.

If the page breaks come back after a reset

Automatic breaks will remain after a reset, so seeing blue boundaries afterward is expected. They may also move when Excel recalculates the page layout. For instance, switching from portrait to landscape gives the sheet more horizontal room, while choosing a smaller paper size can create more pages. A printer or paper-size change can affect the preview even if you have not changed any breaks yourself.

If a solid manual line appears again, check whether it was reinserted or moved after the reset, including by another person who edited the workbook. Also check whether you are looking at the same worksheet: a reset on one tab does not reset breaks on other tabs unless those sheets were selected together. Save the workbook after making the intended change if you want the revised layout to persist.

When a break seems to be in the wrong place, inspect the related print settings before repeatedly resetting it. Look at orientation and paper size under Page Layout, and review Page Layout > Margins and Page Layout > Print Area. A large margin or restricted print area can make the automatic layout differ from what the worksheet’s screen view suggests.

Check print area and scaling separately

Scaling is a frequent reason a reset seems not to solve a printing problem. Under Page Layout, the Scale to Fit controls can adjust the width and height of the printed sheet. Setting a sheet to fit one page wide, for example, may shrink its columns onto one page horizontally while still allowing it to span several pages vertically. A page-break reset does not cancel those scaling choices.

To print a selected range, use Page Layout > Print Area > Set Print Area. To remove a previously defined print area, choose Page Layout > Print Area > Clear Print Area. Then check File > Print to see which cells and page divisions will actually be printed. These controls address different problems:

If some rows or columns are missing from the printout, check the print area and print selection.
If the content is included but divided at inconvenient places, inspect manual breaks or reset them.
If all content is present but too small or spread over too many pages, review scaling, paper size, and orientation.

For example, a wide sales table might split a customer name column from its sales figures. Resetting manual breaks can restore automatic placement, but setting the page to landscape or fitting it to one page wide may be the more useful adjustment. Fitting a large table to one page can make text difficult to read, so check the print preview before relying on that setting.

View and verify the printed layout

Page Break Preview gives a worksheet-level view of page boundaries and lets you move manual breaks. Choose View > Page Break Preview to enter it, then use View > Normal to return to the standard grid view. The preview may show page numbers and shaded areas outside the print range; those markings are visual aids, not cell content.

For the most practical check, open File > Print. The print screen shows page previews and the selected printer’s available paper settings. If the preview differs from Page Break Preview, confirm the printer, paper size, orientation, scaling, and print-area settings. The physical output can depend on the printer and its driver, so a layout may shift when the selected printer changes.

Windows, Mac, and Excel for the web

The steps above describe Excel for Microsoft 365 on Windows. Excel for Microsoft 365 on Mac also provides page-break controls from the Page Layout tab; the exact ribbon arrangement can vary with the window size and Excel build. If the command is not immediately visible, expand the ribbon or look in the Page Setup area for Breaks. The Windows ribbon keyboard sequence is not a universal shortcut across platforms, so using the visible command is the reliable method.

Excel for the web has a more limited page-layout editing experience than the desktop application, and the same Reset All Page Breaks control may not be available there. If you need to reset or precisely adjust manual breaks, open the workbook in the desktop Excel app. The web version’s print options can still help with a basic preview, but use desktop Excel when the page-break menu is required.

Frequently Asked Questions

Does Reset All Page Breaks delete my data?
No. It removes manual page-break settings on the selected worksheet. It does not delete cell contents, formulas, or worksheet formatting.

Why are there still lines after I reset page breaks?
Excel still displays automatic page boundaries because it must divide printable content into pages. Resetting removes manual breaks, not the automatic ones.

Can I reset page breaks on every sheet at once?
Select the worksheet tabs you want to group, then use the reset command. It applies to the selected sheets. Click a single tab afterward to ungroup them before making unrelated edits.

Will resetting page breaks clear the print area?
No. Use Page Layout > Print Area > Clear Print Area to remove a print area. Resetting breaks and clearing the print area are separate actions.

How do I reset just one page break?
Use Page Layout > Breaks > Remove Page Break with a cell below a horizontal break or to the right of a vertical one. You can also reposition a break in Page Break Preview.

Why does my worksheet still print on several pages?
Resetting restores automatic breaks; it does not force a one-page printout. Review scaling, paper size, orientation, margins, and the print area if you want to change the number of pages.

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.