Excel Page Breaks Won’t Reset? Fix View and Print Settings

Excel Page Breaks Won't Reset? Fix View and Print Settings

To reset page breaks in Excel for Microsoft 365 on Windows, select the worksheet, choose View > Page Break Preview, then choose Page Layout > Breaks > Reset All Page Breaks. If the page layout still looks unchanged, Excel may be showing automatically calculated breaks, or print settings such as scaling and the print area may be controlling the result.

What Reset All Page Breaks Actually Does

Excel divides a worksheet into printed pages. Some breaks are manual: a person inserted or dragged them to control where one printed page ends and the next begins. Other breaks are automatic: Excel places them according to the printable space available, the sheet’s dimensions, and the current print settings.

Reset All Page Breaks removes manual page breaks from the active worksheet. It does not remove the worksheet’s data, change cell contents, or necessarily restore every print setting to its default. Excel then recalculates automatic breaks using the current page setup. That means a break can still be visible after a successful reset; it may simply be an automatic break rather than one that failed to clear.

In Page Break Preview, manual breaks are generally shown as solid blue lines and automatic breaks as dashed blue lines. The distinction helps diagnose the issue, but the appearance can be difficult to interpret when a sheet has complex formatting or when you are viewing a different worksheet than the one you changed.

Reset Page Breaks in Excel for Windows

Use the ribbon command rather than trying to drag every line back into place. Before starting, click the worksheet tab you want to fix. If several sheets are grouped, check which tabs are selected: changes made while sheets are grouped can apply to more than one worksheet.

Choose View > Page Break Preview. This view shows how the sheet is divided for printing.
Open Page Layout > Breaks.
Choose Reset All Page Breaks.
Check the result in Page Break Preview, then open File > Print to inspect the print preview.

If you only want to remove a particular manual break, select the cell immediately below a horizontal break or immediately to the right of a vertical break, then use Page Layout > Breaks > Remove Page Break. The selected cell matters: a break applies between rows or columns, not inside a cell. If the command is unavailable, confirm that you are on the intended worksheet and that the selected location corresponds to a removable manual break.

There is no standard keyboard shortcut for Reset All Page Breaks. On Windows, Ctrl+P opens the print screen, but it does not reset breaks. Use it to verify the printed layout after making changes.

Why Breaks Reappear After a Reset

The most common explanation is that Excel has recalculated automatic breaks. For example, a worksheet may fit on one page when printed in landscape but span two pages in portrait. Resetting manual breaks does not tell Excel to print the entire sheet on one page; it simply removes the manual boundaries and lets Excel decide where automatic boundaries go.

Other settings can make the new layout seem unchanged or unexpected:

Scaling: In Page Layout > Scale to Fit, options for fitting a sheet to a set number of pages can change how Excel lays out the printout. When a Fit to setting controls the page count, manual breaks may not determine the output as expected.
Paper size and orientation: A switch between letter and A4 paper, or portrait and landscape orientation, changes the printable area and can move automatic breaks.
Margins: Wider margins leave less room for rows and columns on each page. Check Page Layout > Margins.
Row heights and column widths: A wide column or tall row can push later content onto another page even when the sheet has few cells.
Print area: A defined print area can limit what Excel prints. It is separate from page breaks and is not cleared by resetting them.

For instance, suppose a report has a manual break before row 40. Resetting it removes that chosen boundary, but if the sheet is too tall for one printed page, Excel may place an automatic break around row 40 again. The line can appear in nearly the same place even though the manual break is gone.

Check the Print Area and Scaling

If the reset command works but the printout remains wrong, inspect the print setup rather than repeatedly resetting breaks. In Page Layout > Print Area, choose Clear Print Area only if you want Excel to consider the worksheet beyond its existing defined print range. Clearing the print area does not remove cell data, but it can cause additional rows or columns to print.

Next, review Page Layout > Scale to Fit. A width or height value can force a particular number of pages, while automatic settings allow Excel to paginate based on the available space. There is no universally best setting: fitting a very wide worksheet onto one page may make the text too small to read. Check the print preview and consider landscape orientation or a larger paper size before shrinking the whole sheet.

Also verify the printer and paper settings shown in File > Print. A different printer or paper size can change the printable area, so page boundaries in the worksheet view might not match what you expected from an earlier printout. Print preview is the practical check for the current settings, not a guarantee that every printer will produce identical margins.

A Reliable Troubleshooting Order

Work through the following checks in order. This separates a stubborn manual break from a layout rule that is generating new automatic breaks:

Click the worksheet tab that contains the problem and make sure you are not unintentionally working with grouped sheets.
Open Page Break Preview and run Page Layout > Breaks > Reset All Page Breaks.
Look for whether the remaining lines are automatic. If they are, adjust page setup or sheet dimensions rather than repeating the reset.
Review the print area, scaling, orientation, paper size, and margins.
Open File > Print and confirm the preview matches the intended output.
If the page setup still seems to revert, save the workbook, close it, and reopen it. Then check that the same worksheet and printer or paper settings are in use.

If a workbook is shared, stored in a synced location, or being edited by more than one person, confirm that your changes were saved and that you reopened the same file. This is not a special page-break behavior; it is a way to rule out editing a different copy or viewing an older saved version.

Resetting One Break Versus All Breaks

Use Reset All Page Breaks when you want to remove the worksheet’s manual page-break layout and let Excel repaginate the sheet. Choose Remove Page Break when one manual boundary is wrong but the others are deliberate. Removing individual breaks can take longer, but it preserves intentional divisions elsewhere in a long report.

For example, a monthly report might have manual breaks separating departments so each begins on a new printed page. If one extra break makes a department spill onto an unnecessary page, remove that specific break first. Resetting all breaks would remove every manual department boundary and could create a less useful printout.

Neither command is the same as deleting rows, columns, or a print area. Page breaks affect pagination; print areas define which cells are included; scaling changes how content is sized or fitted. Keeping those three concepts separate makes the commands easier to choose correctly.

Excel for Mac and Excel for the Web

In Excel for Mac, the ribbon and available controls can differ slightly by version, but the desktop workflow is to open the page-break view and use the Page Layout tab’s Breaks menu to reset or remove breaks. If the command is not visible, check the ribbon tabs and make sure the workbook is open in the desktop application. The Mac print shortcut is Command+P; on Windows it is Ctrl+P.

Excel for the web has a more limited set of page-layout controls than the desktop app. If you cannot find Page Break Preview or Reset All Page Breaks in the browser, open the workbook in desktop Excel and use the steps above. Avoid assuming that a missing browser command means the workbook’s breaks are damaged.

Frequently Asked Questions

Why do page breaks come back after I reset them?
Resetting removes manual breaks, but Excel still creates automatic breaks to divide the sheet into printable pages. If the sheet is too large for one page, those lines will remain or appear in new positions.

Does Reset All Page Breaks delete my print area?
No. The command removes manual page breaks, not the defined print area. To remove a print area, use Page Layout > Print Area > Clear Print Area.

Why are my manual page breaks being ignored?
Check whether a Fit to page setting under Page Layout > Scale to Fit is controlling the number of printed pages. Also check the print preview, because scaling and other page setup settings can affect the final pagination.

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

Will resetting breaks make my worksheet print on one page?
No. It removes manual breaks but does not force a one-page printout. To control the page count, review Scale to Fit and print preview, keeping readability in mind.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.