How to Get Rid of a Page Split in Excel

To remove a page split in Excel, first identify what you are seeing: for a print-page boundary, go to Page Layout > Breaks > Remove Page Break, or choose Reset All Page Breaks to clear manual breaks throughout the sheet. If the worksheet is divided into independently scrolling sections, go to View > Split to turn off the split. These steps are for Excel for Microsoft 365 on Windows; save the workbook before changing its print layout.

What You’ll Need

The Excel workbook with the affected worksheet open. If the workbook is important, save a copy first; changes to page breaks can affect how printed pages are arranged.
Excel for Microsoft 365 on Windows for the exact ribbon paths below. Excel for Mac has similar page-break and view controls, though their positions can vary by release. Excel for the web has fewer print-layout controls, so use the desktop app if you cannot find the commands.

Step-by-Step

Work out which kind of split you have. A page break marks where Excel will begin a new printed page. It may appear as a solid blue line in Page Break Preview, or as a dashed line on a worksheet after you have viewed or printed it. A split-pane divider is usually a thick horizontal or vertical bar in the worksheet; the areas on each side can scroll separately. If you are unsure, click the View tab and look for the Split command. If it is active, the divider is probably a pane split. Page breaks affect printing, not the way you scroll through the sheet.
Remove one manual page break. For a clearer view of print boundaries, select View > Page Break Preview. Find the solid blue line you want to remove. To remove a horizontal break, click a cell in the row immediately below that line. To remove a vertical break, click a cell in the column immediately to the right of that line. Then choose Page Layout > Breaks > Remove Page Break. Excel removes the manual break associated with the selected cell. If you are in Normal view, the command may be harder to use because the break is less obvious; switch to Page Break Preview first.
Clear all manual page breaks on the worksheet if needed. Use this when you do not know which manual breaks were added or want Excel to arrange the sheet again. Select Page Layout > Breaks > Reset All Page Breaks. This clears manually inserted page breaks on the active worksheet; it does not remove content, delete rows or columns, or necessarily make the worksheet fit on one printed page. Automatic breaks can still appear because Excel must divide a large print area into pages.
Return to a regular worksheet view. After removing breaks, select View > Normal. This leaves Page Break Preview and returns to the standard cell grid. In Normal view, Excel can still show page-break indicators as dashed lines, depending on the workbook and your display settings. That does not necessarily mean a manual break remains; the dashed lines commonly indicate automatic print boundaries.
Hide page-break indicators if the lines are the only problem. If you want the worksheet to look clean on screen but do not want to change its print layout, open File > Options > Advanced. Under Display options for this worksheet, select the affected sheet in the drop-down if necessary, clear Show page breaks, and choose OK. This hides the indicators in that worksheet; it does not remove the breaks or change where pages print. The setting is per worksheet, so repeat it for other sheets as needed.
Turn off a split-pane divider. If the sheet is divided into sections that scroll independently, select View > Split. The command toggles the split off. If the divider is actually caused by frozen rows or columns rather than Split, choose View > Freeze Panes > Unfreeze Panes. Split and Freeze Panes are different features: a split creates separate scrollable panes, while freezing keeps selected rows or columns visible as you scroll.
Check the result in print preview. Select File > Print to inspect the page layout before printing, then return to the workbook with the back arrow if you need to make more changes. If the content still breaks across pages, adjust the print settings rather than repeatedly removing breaks. For example, under Page Layout, review Orientation, Size, Margins, and the Scale to Fit options. Use scaling carefully because fitting a wide sheet onto one page can make the text too small to read.

Common Mistakes

Removing an automatic break as if it were manual. Excel creates automatic breaks according to the paper size, margins, scaling, and print area. A dashed line in Normal view is usually automatic. The Remove Page Break command is for manual breaks; clearing a manual break will not make Excel stop dividing a large sheet into printed pages.
Choosing Reset All Page Breaks when only one line needs attention. Reset All Page Breaks removes every manual break on the active worksheet, so it can undo intentional page divisions elsewhere on that sheet. Use Remove Page Break for a single manual boundary. If you do reset them, inspect the print preview and reinsert any deliberate breaks.
Expecting hidden lines to change the printed result. Turning off Show page breaks only changes the screen display. Excel still uses the same print boundaries. Conversely, removing a manual break changes pagination but may not hide every dashed automatic line in Normal view.
Confusing a split with frozen panes. Clicking View > Split will not necessarily unfreeze headings. If rows or columns stay visible while the rest of the sheet scrolls, use Unfreeze Panes. If you remove a split and the sheet still appears divided, check whether panes are frozen instead.
Trying to fix pagination by deleting worksheet data. A page break is a print-layout boundary, not an inserted blank row or column. Do not delete cells or change the worksheet structure just to remove a boundary line. Check the break and print settings first.

Tips

Use the right view for the task. Page Break Preview is best for locating and adjusting manual page breaks. Normal view is usually more comfortable for entering and reviewing data. Switch back after making print changes so the worksheet is easier to work in.
Check the active sheet before using Reset All. Page breaks belong to individual worksheets. Click the correct sheet tab first, and avoid selecting multiple tabs unless you intentionally want to work with grouped sheets. If sheet tabs are grouped, changes can apply to more than one sheet.
Use print scaling when the real goal is fewer pages. If the worksheet is only one or two columns too wide, choose a suitable orientation or paper size, or set the width to one page in the Scale to Fit controls. Do not set both width and height to one page for a long report unless shrinking all content is acceptable.
Consider the print area. Excel may include stray formatting or content far outside the data you care about. Select the intended cells and use Page Layout > Print Area > Set Print Area if you want only that range printed. A print-area change affects printing, not the worksheet contents.
On Mac, look for the equivalent view and layout controls. Excel for Mac includes Normal and Page Break Preview views and page-break options, but the ribbon layout and some dialog wording can differ. Use the View and Page Layout tabs, and consult the app’s command search if a control is not where it is on Windows. The Windows File > Options path for hiding indicators does not apply exactly on Mac.
For Excel for the web, open the workbook in the desktop app for detailed control. The browser version may not expose every page-break command or setting found in Microsoft 365 desktop. If the line is merely distracting, changing views may help, but use the desktop version to reliably reset manual breaks, manage display options, and verify print pagination.

Troubleshooting

Remove Page Break is unavailable or does not remove the line. Confirm that you selected a cell directly below a horizontal manual break or directly to the right of a vertical one. Check whether the line is dashed, which commonly indicates an automatic break. If it is automatic, adjust the print area, page orientation, margins, paper size, or scaling instead. You can also use Reset All Page Breaks to clear manual breaks on that sheet, then check whether the line remains.

The lines return after switching back to Normal view. They may be automatic page-break indicators, or Show page breaks may still be enabled. If you only want a clean screen, clear Show page breaks in the worksheet’s Advanced display options. If you need different printed pages, change the print settings; hiding indicators alone will not alter them.

The sheet still prints on several pages after resetting breaks. Resetting removes manual breaks, not the automatic divisions needed to print the sheet. Open File > Print and inspect the preview. Check that the print area does not include unnecessary cells, review margins and orientation, and use scaling only if the resulting text remains legible. Also check for a defined print area that may be forcing an unexpected range.

The worksheet remains divided after clicking Split. Look for a heavy line marking frozen rows or columns and choose View > Freeze Panes > Unfreeze Panes. If the divider remains, click View > Split once more to toggle it off. If the sheet is protected or the workbook opens in a restricted mode, some commands may be unavailable; check whether editing is enabled and whether worksheet protection must be removed by an authorized user.

You cannot find the same commands on Mac or in a browser. Ribbon layouts and feature availability differ by platform and version. In Excel for Mac, search the ribbon for Page Break Preview, Breaks, or Split. In Excel for the web, select Open in Desktop App when available and make the print-layout change there. Avoid assuming that a hidden line has been removed until you inspect the print preview.

Frequently Asked Questions

Does Reset All Page Breaks remove every page break in the workbook?
It clears manual page breaks from the active worksheet, not every worksheet in the workbook. Automatic breaks remain because Excel still has to paginate the content. Repeat the action on other sheets only if you want to reset their manual breaks too.

Can I remove only one page break?
Yes. In Page Break Preview, select a cell just below a horizontal break or just to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. If the boundary is automatic, change the print settings rather than trying to remove it as a manual break.

Why do page-break lines show in Excel but not on the printed page?
The lines are worksheet indicators that show where print pages are divided; they are not worksheet borders or printed marks. They may be hidden through the worksheet’s Show page breaks setting without changing the print layout.

How do I fit a worksheet on one page?
In Page Layout, use the Scale to Fit controls to set the page width and, if appropriate, the height to one page. Review File > Print afterward. Excel may shrink the content substantially, so a landscape orientation, narrower margins, or printing across several pages may be more readable.

Is a page break the same as Freeze Panes or Split?
No. A page break controls where printed pages start. Split divides the on-screen worksheet into independently scrolling panes, and Freeze Panes keeps specified rows or columns visible while scrolling. Use the matching command for the feature you want to change.

Will removing a page break delete cells or change my data?
No. Removing or resetting page breaks changes print pagination only. It does not delete cell contents, rows, or columns. Changing a print area or scaling also affects printing rather than the underlying data.

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.