Remove a Hard Page Break in Excel: Step-by-Step

To remove a hard (manual) page break in Excel for Microsoft 365 on Windows, select the cell below a horizontal break or to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. To remove every manual break on a sheet, choose Page Layout > Breaks > Reset All Page Breaks. These changes affect printed pages, not the worksheet’s cell data.

What You’ll Need

An Excel workbook with the worksheet that contains the break.
Excel for Microsoft 365 on Windows for the ribbon paths below. Excel for Mac has similar page-break controls, though some ribbon labels and locations may differ slightly.
Permission to edit the workbook. If it is shared or protected, you may need to save an editable copy or ask the owner to change the sheet settings.

You do not need an add-in or a formula. If the break affects a report you must print, save a copy first so you can compare the page layout before and after the change.

Step-by-Step

Open the worksheet that has the problem. Click its sheet tab at the bottom of the Excel window. Page breaks belong to individual worksheets, so changing one sheet does not automatically change the others. If you are unsure which sheet contains the break, check each relevant tab in Page Break Preview.
Switch to Page Break Preview. Select View > Page Break Preview. Excel displays the worksheet as printable pages, with page numbers in the background and boundaries between pages. This view makes it easier to tell whether the unwanted line is a manual break or simply where Excel currently divides pages automatically.
Find the break you want to remove. A manual break is usually shown as a solid blue line in Page Break Preview; an automatic page boundary is usually dotted or dashed. A horizontal break divides rows, while a vertical break divides columns. If the line is difficult to see, zoom in or inspect the area around the page number and the cells that move to the next page.
Select the cell on the far side of the break. For a horizontal break, select a cell in the row immediately below it. For a vertical break, select a cell in the column immediately to its right. For example, if the horizontal line is between rows 20 and 21, select a cell in row 21. If the vertical line falls between columns D and E, select a cell in column E. The selected cell helps Excel identify which boundary you mean.
Remove that manual break. Open Page Layout > Breaks > Remove Page Break. Excel removes the relevant manual boundary, and the print layout may reflow. Check the surrounding pages: the rows or columns that were pushed onto a separate page may now fit with the preceding section, or Excel may place a different automatic boundary nearby.
Repeat for any other manual breaks. Select a cell below or to the right of each unwanted line, then use Page Layout > Breaks > Remove Page Break again. Work one break at a time if you want to keep other intentional page divisions in place. Removing a break in one direction does not necessarily remove a nearby horizontal or vertical break.
Reset all breaks if you want a clean slate. If the sheet has many unwanted manual boundaries, choose Page Layout > Breaks > Reset All Page Breaks. This clears the manual page breaks on the active worksheet and lets Excel recalculate the page divisions. Use this only when you are happy to discard all manually positioned breaks on that sheet, including any that were added intentionally.
Check the result in print preview. Choose File > Print or press Ctrl+P on Windows. Review the page thumbnails and confirm that the content is divided as intended. Press Esc to return to the worksheet. On a Mac, use Command+P to open the print screen; the ribbon paths for managing breaks may vary by Excel version.

When finished, you can return to View > Normal. Page Break Preview is only a way to inspect and adjust the print layout; it does not change the appearance of the sheet when someone views it normally.

Common Mistakes

Trying to remove an automatic break as if it were manual. Excel creates automatic page divisions based on paper size, margins, orientation, scaling, print area, and the amount of content. A dotted or dashed line is generally automatic, so Remove Page Break may be unavailable or may not produce the result you expect. You can remove a manual break, but you cannot permanently delete an automatic one. Instead, adjust the settings that determine where Excel fits the content.

Selecting the wrong side of the line. To remove a horizontal break, select a cell in the row below it; to remove a vertical break, select a cell in the column to its right. Selecting a cell above or to the left may target a different boundary. If a line runs through a busy area, identify the exact row or column in the worksheet headings before using the command.

Using Reset All Page Breaks when only one needs to go. Resetting is convenient, but it removes every manual break on the active sheet, including deliberate divisions between chapters, forms, or sections. For a single unwanted line, use Remove Page Break instead. If you reset accidentally, try Ctrl+Z immediately; however, not every page-layout change is necessarily undoable in every situation, so keeping a copy is safer.

Confusing a page break with a print-area boundary. A print area determines which cells Excel includes when printing. Changing or clearing it can alter the number and shape of pages, but it is not the same as removing a manual break. If content is missing or the preview shows an unexpected range, check Page Layout > Print Area before changing breaks.

Expecting the worksheet itself to move or change. Removing a break changes how Excel divides a sheet into printed pages. It does not delete rows, shift cells, or remove content. If text appears missing in print preview, inspect the print area, hidden rows or columns, and print settings rather than assuming the break deleted data.

Tips

Use Page Break Preview before making changes, even if you think you know where a break is. A solid line can be easier to identify there than the faint page-break marks that may appear in Normal view after printing. If you have several sheets to fix, handle them separately and check the active sheet tab before using either break command.

Make one change and preview the result before making another. Page boundaries can shift after a single break is removed because Excel recalculates the remaining automatic breaks. This is especially useful for worksheets with wide tables, long reports, or repeated sections where moving one boundary could affect several later pages.

If Excel keeps splitting a table in an awkward place, consider changing the page setup rather than repeatedly removing breaks. Under Page Layout, options such as Orientation, Margins, and Size can create more room. The Scale to Fit controls can also shrink a sheet to fit a chosen number of pages, though very small scaling can make printed text difficult to read. Always check the print preview at a readable zoom before printing.

For a report that must retain exact page divisions, keep an untouched copy of the workbook or worksheet before resetting breaks. A saved copy is particularly helpful when the file contains many manually arranged pages, because rebuilding those divisions later can take longer than removing the wrong one.

Troubleshooting

Remove Page Break is unavailable. First confirm that the selected sheet is not protected and that you have selected a cell below or to the right of a manual break. Then inspect the line in Page Break Preview. If it is an automatic boundary, change the page setup or scaling instead; the command cannot remove a boundary that Excel generated from the current print settings.

The line disappears but another one appears nearby. That is often normal. Excel recalculates automatic page divisions after a manual break is removed. Look at the full page layout, not just the original line. If the new split is still unsuitable, try adjusting the paper size, orientation, margins, scaling, or print area, then check print preview again.

The page layout does not seem to change. Confirm that you are editing the correct worksheet and that the selected cell is on the right side of the intended break. Also check whether the sheet is set to fit to a specified number of pages; scaling can override or make manual page-break adjustments difficult to interpret. Review File > Print to see the actual output Excel is preparing.

The workbook is protected or opens read-only. A protected worksheet may prevent page-layout changes. If you have the password and authorization, use Review > Unprotect Sheet, make the change, and protect it again if required. If the workbook is read-only or you lack permission, use File > Save As to create an editable copy when allowed, or ask the file owner to update the print layout.

You are using Excel for the web. Page-break controls may be limited compared with desktop Excel. If you cannot find the Breaks commands or Page Break Preview, open the workbook in the desktop app for Windows or Mac, make the change there, save the workbook, and then reopen the updated file online. Avoid assuming that a visual line in a browser view is a removable manual break.

Print preview still shows an extra page. Removing a manual break does not guarantee that everything fits on fewer pages. Check whether the worksheet has extra used cells, a defined print area, large margins, landscape or portrait orientation, or scaling that affects the page count. A single cell far to the right or below the main table can expand the print range; inspect the preview and print-area settings before deleting worksheet content.

Frequently Asked Questions

What is a hard page break in Excel?
A hard page break is a manual boundary inserted to control where printed content starts on a new page. It affects printing and print preview, not the values or layout of cells in the ordinary worksheet view.

How can I tell whether a page break is manual?
Open View > Page Break Preview. Manual breaks are generally shown as solid blue lines, while automatic boundaries are generally dotted or dashed. If the line is automatic, adjust the print settings that determine page fit instead of trying to remove it.

Can I remove just one page break?
Yes. Select a cell in the row below a horizontal break or in the column to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. Check the result in Page Break Preview because nearby automatic boundaries may move.

What does Reset All Page Breaks do?
It removes the manual page breaks from the active worksheet and lets Excel recalculate the divisions. It does not delete data, and it does not guarantee a particular page count. Use it when you want to clear several manual breaks, not when you need to preserve the other custom breaks on that sheet.

Will removing a page break change my printed page count?
It may, but not always. Excel may combine content onto fewer pages, or it may create a new automatic division elsewhere based on paper size, margins, print area, and scaling. Use print preview to confirm the final page count and the position of each section.

Can I remove a page break in Excel for Mac?
Excel for Mac includes page-break controls, but the ribbon arrangement can differ by version. Look for the Breaks commands on the Page Layout tab and use Page Break Preview to identify the boundary. If you cannot find the controls in your edition, use Excel desktop for Windows or consult that version’s ribbon options.

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.