Formatting Issues

Fix Excel Page Break Lines That Cannot Be Moved or Removed

Bushra ParveenBushra Parveen Nov 22, 2026 868 views

Question details

The user wants to remove or change dotted lines in an Excel worksheet that cannot be moved or removed as page breaks.

Fix Excel Page Break Lines That Cannot Be Moved or Removed
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user is adjusting worksheet layout and finds lines that may be page-break indicators or view-related markers.
Observed behavior
The dotted lines cannot be moved, and page-break removal commands may be unavailable.
Before you start

Open the affected worksheet and check whether the lines appear in Normal view or Page Break Preview. Automatic page breaks and view markers are not removed in the same way as manual page breaks.

Solution 1Recommended

Return to Normal view and check the ruler

Use this first when the lines may be related to the worksheet view or layout display.

1
Check the ruler

Select View > Page Layout. On the View tab, clear the Ruler checkbox if it is selected.

2
Switch views

Select View > Normal under Workbook Views and check whether the lines remain.

3
Reopen the workbook

Select File > Save, close Excel, and reopen the workbook to check the display again.

Return to Normal view and check the ruler
Ruler and page-break lines are different: Turning off the ruler changes the Page Layout view display; it does not remove worksheet page breaks.
Free Microsoft Office alternative

Review spreadsheet print layouts with WPS Office

WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files and review their print layouts while moving between office suites.

Review spreadsheet page layouts and print settingsCompatible with Microsoft Excel XLSX and XLS filesFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why are dotted lines still visible after I reset page breaks?

Reset All Page Breaks removes manual breaks, but Excel still calculates automatic breaks. In desktop Excel, you can hide their indicators in Normal view through File > Options > Advanced > Display options for this worksheet > Show page breaks.

Why can't I move a manual page break?

Print scaling may be set to Fit to. Open the Page Setup dialog from the Page Layout tab, select Adjust to on the Page tab, and try moving the break in View > Page Break Preview.

How do I remove one manual page break?

Select a cell immediately below a horizontal break or immediately to the right of a vertical break, then select Page Layout > Breaks > Remove Page Break. This command applies to manual breaks.

Does hiding page breaks change how the worksheet prints?

No. Clearing Show page breaks only hides the indicators in Normal view. To change printed page boundaries, adjust settings such as scaling, margins, or paper size on the Page Layout tab.