Fix Excel Page Break Lines That Cannot Be Moved or Removed
Question details
The user wants to remove or change dotted lines in an Excel worksheet that cannot be moved or removed as page breaks.

- 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.
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.
Return to Normal view and check the ruler
Use this first when the lines may be related to the worksheet view or layout display.
Select View > Page Layout. On the View tab, clear the Ruler checkbox if it is selected.
Select View > Normal under Workbook Views and check whether the lines remain.
Select File > Save, close Excel, and reopen the workbook to check the display again.

Inspect and reset manual page breaks
Use Page Break Preview to distinguish manual breaks from automatic breaks and reset manual breaks if needed.
Hide page-break indicators in Normal view
Use this when the remaining lines are page-break indicators and you want to hide them rather than change the print layout.
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.

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.




