How to Remove Page Breaks in Excel (Manual and Automatic)

You opened a workbook, hit print preview, and there it was again. A weird page break right in the middle of your data table. Maybe a dotted blue line splitting a chart. Maybe a solid line you swear you never asked for. Page breaks in Excel can feel like uninvited guests. They show up, they rearrange the furniture, and they leave you staring at a print job that needs cleanup.

Here is the good news. Removing page breaks in Excel is straightforward once you know which kind you are dealing with. There are two flavors. Manual page breaks, which you (or somebody before you) added on purpose. And automatic page breaks, which Excel sprinkles in based on paper size, margins, and scaling. The trick is telling them apart and then using the right command for each.

This guide walks through every method. The ribbon route via Page Layout > Breaks. The Page Break Preview view where you can drag and delete visually. The nuclear option called Reset All Page Breaks. And the quieter trick most people miss: hiding page break lines from Normal view entirely so they stop distracting you while you work. By the end, you will know exactly how to clean up any worksheet, regardless of how many breaks are hiding inside it.

One more thing before we start. The steps work the same in Excel 2016, 2019, 2021, Microsoft 365, and the latest Excel for Mac. Where the Mac shortcut differs, you will see it called out. Web Excel handles page breaks a little differently, and we cover that too.

Sometimes you remove every visible break and the print preview still splits awkwardly. That is almost always a print area problem. A print area is a saved range that Excel treats as the only thing to print. If your print area covers rows 1 to 50 but your data goes to row 80, those last 30 rows will not print at all, and the page boundary at row 50 will look exactly like a page break.

Clear it from Page Layout > Print Area > Clear Print Area. The boundary disappears. From there you can either let Excel print everything or set a new, larger print area that actually matches your data.

Manual page breaks and automatic page breaks look different on screen, and they behave differently when you try to remove them. Excel uses a dotted line for automatic breaks and a solid line for manual breaks. That visual cue matters because the Remove Page Break command only works on manual ones. You cannot delete an automatic break directly, but you can push it around or hide the indicator entirely.

Manual breaks are added two ways. Either you placed your cursor in a cell and clicked Page Layout > Breaks > Insert Page Break, or somebody else did. They stay put until you remove them. Automatic breaks shift around. Change your margins, change your scale, change paper from Letter to A4, and Excel recalculates where the page should end. Useful behavior most of the time. Maddening when you wanted everything on one sheet.

The third character in this story is the print area. If you have set a print area, Excel treats its edges as breaks too. Clearing the print area can sometimes solve what looks like a stubborn page break problem. We cover that further down.

Below is the cleanup checklist. Run through it any time you take over a workbook from somebody else and the print layout looks wrong. The order matters. Start with the manual breaks because those are the easiest to fix. Move to print area and scale settings. Hide stray indicators last so you can see the changes as you go.

The fastest way to remove a single manual page break is the ribbon. Click any cell directly below or to the right of the break. Open the Page Layout tab. Click Breaks. Choose Remove Page Break. The line vanishes. Excel will then recalculate automatic breaks based on the new flow.

Worth noting: the Remove Page Break option only appears when your active cell is in the right spot. If the command is greyed out or shows as Insert Page Break instead, your cursor is on the wrong row or column. Move it one cell down or right of the break line and try again. Small detail, big source of frustration.

For a worksheet stuffed with manual breaks, doing it one at a time is painful. That is where Reset All Page Breaks comes in. Same Breaks menu, different command. Reset All Page Breaks strips out every manual break in one click and lets Excel recompute automatic breaks from scratch. It does not touch your print area, margins, or scale settings, so the layout still respects whatever you have configured.

Page Break Preview is the unsung hero of break management. Open the View tab and click Page Break Preview. The worksheet shifts into a zoomed-out view with clear blue boundaries. Manual breaks show as solid blue lines. Automatic breaks show as dashed blue lines. Page numbers appear watermarked behind the cells so you can see what prints where.

From this view you can do three powerful things. Drag a break to move it. Drag it off the edge of the worksheet to delete it. Right-click any cell and choose Reset All Page Breaks for a clean slate. It is the most visual way to handle break cleanup, and it works in every desktop version of Excel.

When you are done, click View > Normal to go back. If you still see dotted page break indicators in Normal view and they bug you, jump down to the section on hiding page break lines.

Sometimes the real fix is not to remove the break but to remove the need for the break. Scale to Fit lives on the Page Layout tab. Two dropdowns let you force the worksheet to a fixed width and height in pages. Set Width to 1 page and Height to 1 page and Excel will shrink the print to fit on one sheet. The dashed page break lines move accordingly.

You can also use Scale to Fit at finer settings. Width 1 page, Height Automatic, for example, prints any number of rows but always keeps your columns together. That is the right choice for long financial reports where you want one tall continuous column run, not a grid of overflow pages.

For more control, click Page Setup > Scaling and either set a Fit To option or use the Adjust To percentage. Anything between 60 and 100 percent usually keeps text readable while pulling stray columns back onto the page.

Hiding page break lines from Normal view is the cleanup nobody talks about. Even after you remove every manual break, Excel may keep showing dashed lines for automatic breaks. They linger because once Excel has rendered a print preview, it remembers where pages would land. The fix is a single checkbox.

Go to File > Options > Advanced. Scroll to the section called Display options for this worksheet. Uncheck Show page breaks. Click OK. The dashed lines disappear immediately. They will come back the next time you print preview, but for daily work the view stays clean.

Mac users follow Excel > Preferences > View, then uncheck Page Breaks under Show in workbook. Same effect, slightly different menu path.

What if Remove Page Break is greyed out, or the line refuses to budge? Nine times out of ten the issue is one of three things. Your active cell is in the wrong location. The worksheet is protected. Or the break you are seeing is not actually a page break at all, but a frozen pane border or a print area edge.

Check the cell first. Click the cell directly below the break line you want to delete and try Page Layout > Breaks > Remove Page Break again. If that still does not work, unprotect the sheet via Review > Unprotect Sheet. You may need a password. If the line stays, switch to Page Break Preview and look at the colour and style. Solid blue means a manual break. Dashed grey-blue means automatic. Black thin lines are usually frozen panes or table borders, not page breaks at all.

Frozen panes deserve a quick aside because they are mistaken for page breaks more often than anything else. Open View > Freeze Panes and pick Unfreeze Panes. If the line you thought was a break disappears, it was a frozen pane all along. Conversely, if it stays, you have a real break to deal with.

Another sneaky source of mystery lines is conditional formatting that applies a thick border under certain values. Look at Home > Conditional Formatting > Manage Rules and scan for any rule that draws borders. Edit the rule or clear it from the affected range. The line vanishes once the underlying format is gone.

Tabs below give you the keyboard shortcuts and menu paths side by side. Use them as a quick reference while you work. The web version of Excel is included even though it has fewer options. If you are stuck with Excel for the web and you cannot find break controls, the answer is usually to open the file in the desktop app and edit there.

A few last gotchas worth knowing. If you copied a worksheet from another workbook and the page breaks came with it, those breaks were saved as part of the sheet definition. They will not vanish on their own. Run Reset All Page Breaks on the new copy to clean them out before you print. Same story when you import sheets from old Excel 97-2003 files. The legacy breaks survive the conversion and keep showing up until you remove them.

Named ranges can interact with breaks in surprising ways too. If somebody saved a named range called Print_Area, Excel automatically treats that as the print area for the sheet. Renaming or deleting the range frees the layout. Open Formulas > Name Manager, find Print_Area, and either edit the reference or delete it outright.

Multi-sheet workbooks deserve their own warning. Page breaks are stored per worksheet, not workbook-wide. Reset All Page Breaks only affects the active sheet. If you have ten tabs to clean up, you will need to run the command on each one, or write a small macro to loop through every sheet. The VBA snippet for that is two lines: For Each ws In Worksheets: ws.ResetAllPageBreaks: Next ws. Paste it into the immediate window with Ctrl + G and press Enter. Done.

Pivot tables are another corner case. When you refresh a pivot, Excel can insert page breaks between row groups if the field settings call for it. The fix lives inside the pivot. Right-click any row label, choose Field Settings, open the Layout & Print tab, and uncheck Insert page break after each item. Refresh and the offending breaks come out with the next refresh.

If your worksheet still prints across more pages than it should after every fix above, drop the margins. Page Layout > Margins > Narrow gives you a half-inch all around, and the extra space usually pulls a stray column or two back into the body. Combine Narrow margins with Scale to Fit Width = 1 and you can rescue most prints without ever touching the actual break lines.

Every approach has tradeoffs. Reset All Page Breaks is the fastest, but it deletes everything including breaks you wanted. Page Break Preview gives you total control, but the view itself can confuse newer users. Scale to Fit avoids deletion entirely, but at small scales the print becomes hard to read. Pick the method that matches the situation rather than the one you used last time.

A rough rule of thumb. Cleaning up a sheet somebody else built? Reset All Page Breaks first, then Page Break Preview to verify. Tweaking your own working file? Stick with the ribbon and remove breaks one at a time so you keep the ones you want. Printing a long report? Scale to Fit handles the layout without you ever opening the Breaks menu. Match the tool to the job and the cleanup goes quickly.

One more practical tip before the FAQ. When you save a workbook as PDF, Excel uses your current page break and scale settings to lay out the PDF pages. Cleaning up breaks before exporting almost always produces a tidier file. If you ever wondered why your shared PDF reports look fragmented, this is usually why. Fix the breaks, set Scale to Fit if appropriate, then export.

For more printing fundamentals, see our walkthrough on how to print in Excel and the companion guide on how to set print area in Excel. Both cover settings that interact with page breaks and often solve the same problem from a different angle.

You now have every tool you need to take control of page breaks in Excel. Manual breaks come out via Page Layout > Breaks. Stubborn ones surrender to Reset All Page Breaks. Automatic breaks bend to Scale to Fit. And the lingering dashed indicators in Normal view disappear with one checkbox in Options. Combine those four moves and you can clean up any worksheet, no matter how many breaks somebody left behind.

Practice the moves on a real sheet. Open one of your messier workbooks, switch to Page Break Preview, and walk through the checklist above. You will likely find a stray print area, a manual break or two that nobody needed, and a Scale to Fit setting that wants a quick adjustment. Fix all three and your print output will look like it belongs to somebody who actually knows Excel. Because now you do.