How To Insert And Remove Page Breaks In Excel (2026)

When you print an Excel sheet, Excel decides where one page ends and the next begins, and the cut often lands in the middle of a table.

A page break lets you choose that spot yourself, and Page Break Preview shows you where every break is before anything prints.

Here is how to add, move and remove page breaks, and what to check when a manual break does nothing.

Quick answer: insert a page break

StepWhat to do
1View tab > Workbook Views group > Page Break Preview
2Select the row below, or the column to the right of, where the break should go
3Page Layout tab > Page Setup group > Breaks > Insert Page Break
4Check the solid line, then View > Normal

Automatic and manual page breaks

Excel adds automatic page breaks based on the paper size, margins, scaling and any manual breaks you insert.

You can override them with manual breaks, which you can insert, move or delete, or reset all at once.

Line in Page Break PreviewMeaningCan you delete it?
Dashed lineAutomatic break added by ExcelNo
Solid lineManual break you addedYes

Open Page Break Preview first

Go to the View tab and select Page Break Preview in the Workbook Views group, or click the Page Break Preview icon on the status bar.

Microsoft recommends this view over Normal view because you can see how changes to orientation, formatting, row height and column width affect the automatic breaks.

If you only want to look at the pages without changing anything, File > Print opens a Print Preview of each page.

Insert a page break

  1. Select the worksheet and switch to Page Break Preview.
  2. Select the row below the place where the break should go, or the column to the right of it.
  3. On the Page Layout tab, in the Page Setup group, select Breaks.
  4. Choose Insert Page Break.

You can also right-click the row or column and choose Insert Page Break from the menu.

Which row or column to select

You wantSelect
A new page to start at a certain rowThe row below the break location
A new page to start at a certain columnThe column to the right of the break location

The same rule applies in Excel for Mac, where Microsoft gives the same instruction for horizontal and vertical breaks.

Move a page break

  1. Turn on drag and drop with File > Options > Advanced.
  2. Under Editing options, check Enable fill handle and cell drag-and-drop, then select OK.
  3. Switch to Page Break Preview.
  4. Drag the break line to its new position.

If drag and drop is turned off, you may not be able to move any breaks.

Moving an automatic break turns it into a manual break, which will not adjust if your content changes later.

Delete a manual page break

  1. Switch to Page Break Preview.
  2. Select the row below the break, or the column to the right of it.
  3. On the Page Layout tab, select Breaks, then Remove Page Break.

You can also drag a break outside the preview area, past the row headers or column headers, and this also needs drag and drop to be enabled.

Microsoft states you cannot delete automatic breaks.

Reset all page breaks at once

Reset All Page Breaks removes every manual break and restores only the automatic ones.

In Page Break Preview, go to Page Layout > Page Setup group > Breaks > Reset All Page Breaks, or right-click any cell and choose Reset All Page Breaks.

If a manual break does nothing

The Fit To scaling option can cause manual breaks to be ignored.

  1. Go to Page Layout > Page Setup group and open the dialog box launcher.
  2. On the Page tab, change the scaling from Fit To to Adjust to.
  3. Select OK and check the preview again.

Our guide to fitting an Excel sheet on one page covers that scaling option in more detail.

Change where automatic breaks fall

Because automatic breaks cannot be removed, Microsoft’s Mac page suggests other ways to change where they land.

ChangeEffect on automatic breaks
Column widthsFewer or more columns fit across a page
MarginsMore or less room on each page
ScalingContent fits on fewer pages

Go back to Normal view

Select View > Workbook Views > Normal, or click the Normal icon on the status bar.

Page breaks can still show in Normal view after you use Page Break Preview, because Excel turned them on automatically.

To hide them, go to File > Options > Advanced, scroll to Display options for this worksheet, and clear Show page breaks.

That setting controls whether page breaks show in Normal view at any time.

Page Setup options that move automatic breaks

Microsoft’s Page Setup page lists where these settings live, and each one changes how much fits on a page.

Page Setup tabWhat you can change
PagePortrait or landscape, scaling by percentage or fit to pages wide and tall, paper size
MarginsSpace around the data, header and footer distances, centering on the page
SheetPrint area, repeated rows or columns, page order

Microsoft advises keeping header and footer distances smaller than the margins so they do not overlap your data.

Page breaks in Excel for Mac

On a Mac, switch to Page Break Preview from the View tab and use the Breaks button on the Page Layout tab for Insert Page Break, Remove Page Break and Reset All Page Breaks.

To drag a break, hover over the line until the pointer changes shape, then drag it to the new position.

On a Mac, automatic breaks show as dashed lines in Normal view and as bold solid lines with the page number in the center in Page Break Preview.

To hide the dashed lines in Normal view, go to Excel > Preferences > View and clear the Page breaks checkbox under Show in Workbook.

Pages that print without your column labels can be fixed by repeating header rows on every printed page.

You can also keep the printout to one section with a print area or add numbers with our guide to page numbers and headers in Excel.

Sources

Steps come from Microsoft’s pages Insert, move, or delete page breaks in a worksheet and View page breaks.

Mac details come from Microsoft’s page on manual page breaks in Excel for Mac.

Leave a Reply

Your email address will not be published. Required fields are marked *