Excel Page Break Dotted Lines: How to Move Them in Print

Yes. In Excel for Microsoft 365 on Windows, open View > Page Break Preview, then drag a dotted page-break line to the position you want; Excel changes that automatic break into a manual one. If the line is already solid, it is a manual break and you can drag it in the same view.

What Excel’s dotted page-break lines mean

Excel uses page breaks to divide a worksheet into pages for printing or for saving as a PDF. In Page Break Preview, a dotted line marks an automatic page break: Excel has calculated that the content on one side of the line fits on a page and the remaining content belongs on the next. A solid line marks a manual page break that someone has inserted or moved.

You might also see dotted page boundaries in the usual worksheet view after opening Print Preview or printing. Those marks indicate where Excel expects pages to end; they are not cell borders or a formatting style. To reposition them, switch to Page Break Preview. There, the page layout and break lines are easier to inspect and adjust.

Page Break Preview also displays page numbers and gray areas outside the printable pages. These are guides, not worksheet content. They will not appear in the printed sheet. The exact page boundaries depend on settings such as paper size, orientation, margins, scaling, and the active printer.

Move a dotted line in Page Break Preview

Open the worksheet you plan to print and select View > Page Break Preview.
If Excel asks whether to continue in Page Break Preview, confirm. Look for the dotted line that divides the pages.
Point to the line. When the pointer changes to indicate that it can be moved, drag the line to the desired row or column boundary.
Release the mouse button, then check the page numbers and the contents of the surrounding pages.

Drag a horizontal line up or down to change which rows print together. Drag a vertical line left or right to change which columns appear on a page. For example, if a report’s totals row has been pushed onto a second page by itself, moving the horizontal break down may keep the totals with the preceding data, provided the resulting page still fits.

When you move an automatic dotted break, Excel makes it a manual break, so it appears as a solid line afterward. That is expected: you have overridden Excel’s calculated position. If you cannot grab a line, confirm that you are in Page Break Preview rather than Normal view, and check that the worksheet is not protected in a way that prevents the change.

Insert, remove, or reset manual page breaks

Dragging an existing line is not the only option. To create a break at a particular point, select the row below where a horizontal break should go, or the column to the right of where a vertical break should go. Then choose Page Layout > Breaks > Insert Page Break. If you select a cell instead of a whole row or column, Excel can insert a horizontal break above the cell and a vertical break to its left.

Manual breaks are useful when a section should always begin on a new printed page, such as a new department’s report or a separate appendix. They can also prevent a small table from being split at an awkward point. Use them sparingly: a manual break can make a later print layout less convenient if you add rows, change the paper size, or adjust scaling.

To remove one, select a cell just below a horizontal break or just to the right of a vertical break, then use Page Layout > Breaks > Remove Page Break. The selected position matters because Excel removes the relevant break around that cell. To discard all manual breaks on the worksheet and let Excel calculate the divisions again, choose Page Layout > Breaks > Reset All Page Breaks. Resetting breaks does not delete worksheet data.

Why a page break appears in the wrong place

An automatic break is based on the printable page area, not simply on the number of rows or columns. Excel considers the selected paper size, portrait or landscape orientation, margins, scaling, and the printer’s printable area. A worksheet that fits on one page with narrow margins may spill onto two pages when printed with wider margins or a different paper size.

Other settings can change the layout too. A print area limits which cells are included; repeated rows or columns can add headings to each page; and changing a column width can push a column onto a new page. Before moving several breaks by hand, check the relevant choices on the Page Layout tab, including Margins, Orientation, Size, and Print Area.

For a broad report, first decide whether you want a specific number of pages or particular rows and columns kept together. These are different goals. A fixed manual break controls where one page ends, while scaling can shrink content to fit a page count. If you choose a Fit to scaling option in Page Setup, Excel may disregard manual page breaks, so inspect the print preview after changing scaling rather than assuming the old breaks still control the output.

Check the printed result before changing many breaks

Page Break Preview is a planning view, but the print preview is the final check. Use File > Print to see how the current settings paginate the worksheet. Check that important headings are not separated from their data, that no essential columns have been pushed onto an extra page, and that page numbers and margins look sensible. Return to the worksheet if you need to move a line or adjust the print settings.

Consider a sales table with columns for region, representative, quarter, and total. If the total column falls on a page by itself, a vertical break may be poorly placed, but the best fix may be landscape orientation or a smaller print scaling rather than manually forcing a break. If a long list splits in the middle of a customer’s details, a horizontal manual break can help, but changing row heights or margins might solve the underlying fit problem more cleanly.

For a PDF, use the same preview process. Exporting or printing to PDF follows the worksheet’s page setup, so a break that looks wrong on paper can also produce an awkward PDF. After changing the layout, reopen the preview and verify each page, especially if the document has multiple print areas or several worksheets selected.

Hide page-break lines without changing the print layout

If the dotted marks are distracting while you edit, you can hide the page-break indicators in Normal view. In Windows Excel, choose File > Options > Advanced. Under Display options for this worksheet, select the relevant worksheet from the list if needed, then clear Show page breaks and choose OK. The setting changes what you see on the worksheet; it does not remove page breaks or alter the printed pagination.

If the lines are visible only in Page Break Preview, return to View > Normal to leave that view. This also does not change the print layout. Hiding indicators is therefore different from removing manual breaks: use the display option to declutter the worksheet, and use Page Layout > Breaks when you intend to change the actual page divisions.

On Excel for Mac, switch views from the View tab or menu and look for the page-break display option in Excel’s settings. Labels and locations can vary between Mac releases. Excel for the web has more limited page-layout controls than the desktop app; if you need to drag, insert, or reset page breaks, open the workbook in desktop Excel.

Common problems and practical fixes

The dotted line will not move: Switch to Page Break Preview and drag the line itself, not a cell boundary. If the worksheet is protected, review its protection settings.
The line turns solid after dragging: That means the automatic break has become a manual break. It is normal, and you can still move or remove it.
The printout ignores a manual break: Review scaling in Page Setup. A Fit to page-count setting can take precedence over manual breaks; try adjusting the scaling or page setup, then check File > Print.
A page still contains too much blank space: Check whether the print area includes unused rows or columns, whether margins are large, and whether scaling is set to fit the sheet across a chosen number of pages.
Breaks moved after changing paper or printer: Excel recalculates automatic breaks based on the available printable area. Recheck the layout with the intended printer and paper size before finalizing the file.

A useful rule is to make the least disruptive change first. If every page is slightly too wide, adjust orientation or scaling. If only one section needs to start on a fresh page, use a manual break. If the worksheet’s page divisions are generally wrong after a series of experiments, reset manual breaks and build the layout again from the print settings.

Frequently Asked Questions

Can I move dotted page breaks in Excel?
Yes. In Page Break Preview, drag a dotted line to a new position. Excel converts that automatic break into a manual break, shown as a solid line.

What is the difference between dotted and solid page-break lines?
Dotted lines indicate automatic breaks calculated by Excel. Solid lines indicate manual breaks that have been inserted or moved by a user.

How do I get rid of page-break lines in Excel?
To leave Page Break Preview, choose View > Normal. To hide break indicators in Normal view on Windows, go to File > Options > Advanced and clear Show page breaks for the worksheet. Neither action removes the actual manual breaks.

How do I remove a page break but keep the worksheet data?
Select a cell just below a horizontal break or just to its right for a vertical break, then choose Page Layout > Breaks > Remove Page Break. Use Reset All Page Breaks to remove all manual breaks on that worksheet.

Why do my Excel page breaks change when I print?
Page divisions depend on page setup and the printable area available to the chosen printer. Paper size, orientation, margins, scaling, and column widths can all affect where Excel places automatic breaks.

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.