Remove a Page Break in Excel: Manual and Automatic

To remove a manual page break in Excel for Microsoft 365 on Windows, 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. To clear every manual break on the worksheet, choose Page Layout > Breaks > Reset All Page Breaks. Automatic breaks cannot be deleted one by one; change the print layout or scaling to move them.

What You’ll Need

A workbook open in the Excel desktop app, with the worksheet containing the break selected. If the workbook is important, save it before changing its print layout.
A way to identify the break: Page Break Preview is usually easiest. It shows how the worksheet is divided into printed pages.
Access to the Page Layout tab. Excel for the web may not offer the same full page-break controls, so open the workbook in desktop Excel if you cannot find the commands.

Step-by-Step

Open the correct worksheet. Click the sheet tab at the bottom of the Excel window. Page breaks belong to individual worksheets, so changing a break on one sheet does not remove breaks from the others. If you are unsure which sheet is affected, check the tabs before proceeding.
Show the page breaks. Choose View > Page Break Preview. Excel displays page boundaries on the worksheet. In this view, solid blue lines generally mark manual breaks, while dotted blue lines indicate automatic breaks that Excel has placed based on the current print settings. Page numbers and gray areas can also appear; those are preview indicators, not worksheet content.
Identify the break you want to remove. A horizontal break divides the sheet between rows. A vertical break divides it between columns. Check the line’s position against your intended printed pages, and make sure it is on the active worksheet. If several lines are close together, note the row or column next to the particular line before choosing a command.
Select the cell on the far side of the break. For a horizontal break, click a cell in the row immediately below the line. For a vertical break, click a cell in the column immediately to the right of the line. For example, if the horizontal break is between rows 20 and 21, select a cell in row 21. If the vertical break is between columns D and E, select a cell in column E. You do not need to select the whole row or column.
Remove the selected manual break. Go to Page Layout > Breaks > Remove Page Break. Excel removes the manual break associated with the selected row or column. The page division may shift because Excel can put an automatic break elsewhere to fit the sheet to the current print settings.
Check the result in the preview. Look at the same area in Page Break Preview. Confirm that the unwanted solid line is gone and that the resulting page boundaries make sense. If the line remains, check whether it is dotted and automatic, or whether you selected the row or column on the wrong side. Use the correction steps under Troubleshooting if needed.
Remove all manual breaks if that is what you intend. To start over on the current worksheet, choose Page Layout > Breaks > Reset All Page Breaks. This clears manual page breaks from that sheet and returns its layout to automatically determined breaks. It does not reset the breaks on other worksheets. Review the preview afterward because pages may now split at different rows or columns.
Return to normal worksheet view and check printing. Choose View > Normal when you have finished editing. To verify the printed result, open File > Print and inspect the preview. Check the page count and the placement of headings, totals, and tables before printing or saving the workbook.

Common Mistakes

Trying to delete an automatic break as if it were manual. Excel inserts automatic breaks when the worksheet exceeds the printable area of a page. They may appear as dotted lines in Page Break Preview, and the Remove Page Break command will not permanently delete them. Adjust the print setup instead, or add a manual break where you want Excel to divide the pages.

Selecting the wrong side of the line. For a horizontal break, the selection must be in the row below it; for a vertical break, it must be in the column to its right. Selecting a cell above or to the left can target a different break or leave the one you meant to remove untouched. Use the row and column headings to confirm the location.

Resetting every break when only one needs attention. Reset All Page Breaks is a worksheet-wide change. It can undo carefully arranged breaks elsewhere on the same sheet. Use Remove Page Break for one specific manual break; choose Reset All only when you want to clear the manual layout across that worksheet.

Confusing a page break with a print area or blank space. A print area limits which cells Excel includes in a printout, while blank rows, columns, or formatting can make the preview appear to split oddly. Removing a break does not clear a print area or delete blank cells. Review Page Layout > Print Area and the actual used range if the preview still looks unexpected.

Assuming a dotted line means the change failed. After a manual break is removed, Excel still has to divide the worksheet into pages. It may draw a new automatic boundary close to the old one. Check whether the line changed from solid to dotted, and use File > Print to judge the output rather than relying on the line’s position alone.

Tips

Use Page Break Preview for editing, Print Preview for the final check. Page Break Preview helps you locate and manage boundaries. File > Print shows the pages as they are likely to print, including the effects of paper size, margins, orientation, and scaling.
Make a targeted change first. If just one printed page is split in an inconvenient place, remove or reposition that manual break rather than resetting the whole sheet. This preserves intentional divisions in other parts of the worksheet.
Review scaling before adding more breaks. On the Page Layout tab, inspect the Scale to Fit settings for width, height, and scale. Forcing a wide sheet onto one page can make text too small; setting width to one page while leaving height automatic may be a better compromise. Check the print preview after each adjustment.
Check paper and margin settings. A different paper size, printer, orientation, or margin can change where automatic breaks fall. If a layout seems to change unexpectedly, inspect Page Layout > Orientation, Size, and Margins before manually rearranging breaks.
Undo promptly if the result is wrong. In Windows, press Ctrl+Z to undo a recent removal or reset. On Mac, use Command+Z. If you have made other changes since then, reopening a saved copy or undoing carefully may be safer than making additional layout edits blindly.
Keep in mind that the page-break view is not part of the data. Switching between Normal and Page Break Preview changes how the worksheet is displayed, not the cell values. A break affects printed pagination; it does not insert a blank row or alter formulas.

Troubleshooting

The Remove Page Break command is unavailable or has no visible effect. First confirm that you are in the correct worksheet and that the selected cell is below the horizontal break or right of the vertical one. Then inspect the line style in Page Break Preview. If it is an automatic break, use print-layout changes rather than Remove Page Break. If the command is still unavailable, check whether the worksheet is protected; protection can restrict layout changes. If appropriate, use Review > Unprotect Sheet, providing the password if Excel asks for one, and try again.

The break disappears, but another line appears nearby. This usually means Excel recalculated automatic pagination after the manual break was removed. Open File > Print and check how the pages are divided. If the new division is still unsuitable, adjust orientation, margins, paper size, scaling, or the size of the rows and columns. You can also insert a manual break at a more suitable point, but remember that automatic boundaries will still respond to print settings.

Dotted lines remain in Normal view after printing. They may be page-break indicators rather than active manual breaks. To hide indicators in Windows, choose File > Options > Advanced, scroll to Display options for this worksheet, and clear Show page breaks for the selected sheet. This hides the on-screen lines; it does not change pagination. On Mac, the Excel preferences and view controls can differ by release, so look in Excel’s settings for page-break display options. Return to Page Break Preview or File > Print when you need to inspect the actual pages.

The printed pages do not match what you expected. Check that the correct printer and paper size are selected in the print settings, and confirm the worksheet’s orientation, margins, print area, and scaling. A printer driver or paper-size change can move automatic breaks. If only part of the sheet prints, inspect the print area and clear or reset it only if that restriction is unintended.

You are using Excel for the web and cannot find the controls. Some page layout and manual-break options are limited or arranged differently in the browser. If you need to remove a specific manual break or reset all breaks and cannot see the commands, open the file in the Excel desktop app, make the change there, save the workbook, and then return to the browser.

Frequently Asked Questions

Can I remove one page break without changing the others?
Yes. Select the cell in the row immediately below a horizontal break or in the column immediately to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. Avoid Reset All Page Breaks if you need to keep other manual breaks.

How do I remove all page breaks from a worksheet?
Choose Page Layout > Breaks > Reset All Page Breaks on that worksheet. This removes manual breaks and lets Excel paginate automatically. It does not remove breaks from other sheets in the workbook.

Why can’t I remove a dotted page break?
A dotted line usually represents an automatic break. Excel calculates it from the printable page size and current layout settings, so it cannot be removed individually. Change settings such as orientation, margins, paper size, or scaling to move it.

Does removing a page break delete rows, columns, or data?
No. Removing a page break changes where Excel divides pages for printing. It does not delete worksheet cells, values, formulas, or formatting.

Can I hide page-break lines without changing the print layout?
Yes. In Windows, go to File > Options > Advanced, find Display options for this worksheet, and clear Show page breaks. That hides the indicators in the worksheet view but does not remove manual breaks or alter printed pagination.

Does removing a page break change how the worksheet looks on screen?
It can change the page-break indicators and the preview, but it does not rearrange cells in Normal view. To see the printed effect, use File > Print; to return to the usual editing display, choose View > Normal.

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.