How to Remove Page Breaks in Excel (Complete Guide)

Method 1: Reset All Page Breaks (the quickest route)

This is the method to reach for first when you want a clean slate, as the figure below shows.

1. Click any cell on the worksheet.
2. Go to the Page Layout tab.
3. Click Breaks in the Page Setup group.
4. Select Reset All Page Breaks.

Every manual page break on that worksheet is removed instantly. Excel recalculates its own automatic breaks based on the current print settings, so the page layout returns to how a fresh sheet would print.

Method 2: Remove a Single Manual Page Break

When you want to keep most of your breaks and delete just one, target it directly.

To remove a horizontal page break, click a cell in the row directly below the blue break line. To remove a vertical page break, click a cell in the column directly to the right of the line. Then open Page Layout > Breaks > Remove Page Break. The single break disappears while the others stay in place.

If your cursor sits at the intersection where a horizontal and a vertical break meet, choosing Remove Page Break clears both at that spot.

Note: the same Breaks menu also holds an Insert Page Break command, so if you ever need to force content onto a new page later, that option sits right beside the removal tools.

Method 3: Remove Page Breaks from the Right-click Menu

The right-click menu gives you the same controls without hunting through the ribbon.

1. Click the cell next to the break you want to clear, using the same row-below or column-right rule from Method 2.
2. Right-click the cell.
3. Choose Remove Page Break from the context menu, or Reset All Page Breaks to clear every manual break at once.

This route feels quicker once you get used to it, since your hand stays on the sheet instead of moving up to the ribbon.

Method 4: Use Page Break Preview to See and Drag Breaks

Page Break Preview turns page breaks into visible, movable lines, which makes stubborn breaks much easier to spot and fix.

1. Go to the View tab.
2. Click Page Break Preview.
3. Solid blue lines mark manual breaks. Dashed blue lines mark automatic breaks.
4. To delete a manual break, drag its line left toward the edge of the print area, or right-click it and choose Remove Page Break. Dragging a break instead moves it to a new location on the sheet.

Page Break Preview is especially helpful for understanding where Excel wants to split your printout, since every break is displayed clearly on a wide worksheet where lines are easy to miss in Normal view.

Method 5: Hide the Dashed Lines that Stay in Normal View

A common frustration is that dashed lines remain across the worksheet even after every break is removed. Those lines are Excel showing you where automatic page breaks fall, and they usually appear the first time you preview or print. You can switch the display off.

1. Open File > Options.
2. Select the Advanced category.
3. Scroll to Display options for this worksheet.
4. Clear the Show page breaks check box.
5. Click OK.

The dashed lines disappear from Normal view. Your data and print settings stay exactly as they were, so this simply cleans up the on-screen clutter.

Note: the same Advanced category page holds the Editing options section, where the Enable fill handle and cell drag-and-drop setting lives, so it is a handy spot to know for other Excel sheet tweaks.

Method 6: Remove Page Breaks with a Macro (for larger workbooks)

If you have many worksheets and want to clear them in one pass, a short macro handles the whole workbook. This is optional and works once macros are enabled, meant for people comfortable with copy and paste into the macro editor.

1. Press Alt + F11 to open the Visual Basic editor.
2. Click Insert > Module.
3. Paste one of the snippets below.
4. Press F5 to run it.

Clear every manual break on the active sheet:

Sub RemoveAllPageBreaks()
    ActiveSheet.ResetAllPageBreaks
End Sub

Clear manual breaks across every sheet in the workbook:

Sub RemoveBreaksAllSheets()
    Dim ws As Worksheet
    For Each ws In ActiveWorkbook.Worksheets
        ws.ResetAllPageBreaks
    Next ws
End Sub

A macro is the fastest option once a workbook grows past a handful of tabs, since it skips the click-through entirely.

Common Issues and Troubleshooting

The Remove Page Break option is greyed out. Confirm that you selected a cell directly below or to the right of a manual break, and confirm the break is manual, shown as a solid line. Excel keeps automatic breaks locked, so they stay unavailable in that menu.

The breaks remain visible after removal. When the dashed lines remain visible even after every break is gone, they are automatic breaks or the leftover display setting. Use Method 5 to turn off Show page breaks in Excel Options to get rid of them. If they still show, close and reopen the workbook so the view refreshes.

The page breaks come back after removal: Automatic breaks regenerate whenever you change margins, paper size, scaling, or column widths. To keep pages predictable, set a Print Area under the Page Layout tab, or use Fit to scaling in the Page Setup dialog so Excel stops recalculating breaks on its own.

Reset All Page Breaks did not clear everything: That command affects manual breaks only. Any dashed lines that remain are automatic and are controlled through print settings and the display option, not the Breaks menu.

The menu looks different on Mac - Current versions of Excel for Mac place these controls under the Page Layout tab, matching Windows. For instance, older versions use a Layout tab instead, with the same Breaks options inside it.

One break shows in preview but more appear in print - Switch to Page Break Preview from the View tab, where both manual and automatic breaks appear as lines across your Excel worksheets, and a quick check verifies the final layout before you print.

Handling Page Breaks in Code with IronXL

When Excel files are generated or cleaned up automatically, stray manual page breaks tend to creep in during editing and merging. Controlling the layout in code keeps every output consistent, which matters for scheduled reports and batch exports where nobody is clicking through the ribbon.

IronXL is a .NET library that reads, edits, and creates Excel files without Microsoft Office or Interop installed. By setting the print area directly, you decide exactly what appears on each printed page, so pagination stays predictable across every file your process produces.

using IronXL;

// Open the spreadsheet
WorkBook workBook = WorkBook.Load("quarterly-report.xlsx");
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Set exactly what prints so pagination stays predictable
workSheet.SetPrintArea("A1:F45");

// Save a clean copy
workBook.SaveAs("quarterly-report-clean.xlsx");

using IronXL;

// Open the spreadsheet
WorkBook workBook = WorkBook.Load("quarterly-report.xlsx");
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Set exactly what prints so pagination stays predictable
workSheet.SetPrintArea("A1:F45");

// Save a clean copy
workBook.SaveAs("quarterly-report-clean.xlsx");

Imports IronXL

' Open the spreadsheet
Dim workBook As WorkBook = WorkBook.Load("quarterly-report.xlsx")
Dim workSheet As WorkSheet = workBook.DefaultWorkSheet

' Set exactly what prints so pagination stays predictable
workSheet.SetPrintArea("A1:F45")

' Save a clean copy
workBook.SaveAs("quarterly-report-clean.xlsx")

This approach fits reporting pipelines, exports from web apps, and any workflow where spreadsheets are produced on a schedule rather than by hand. You can explore the full IronXL Excel library to see how it fits alongside your existing .NET reporting.

Wrapping up

Removing page breaks in Excel comes down to picking the method that matches your situation. For a fast clean slate, Page Layout > Breaks > Reset All Page Breaks clears every manual break in one click, which is the simplest solution for tidier printed documents. To target a single break, select the cell next to it and use Remove Page Break from the ribbon or the right-click menu. When faint dashed lines linger, switching off Show page breaks in Excel Options tidies the view, and a short macro clears an entire workbook at once. If your spreadsheets end up in code-driven reports, the same layout control is available when you read Excel data or convert spreadsheets to PDF as part of an automated pipeline. You can also download a free trial to explore its features in your own projects.