How to Edit Page Breaks in Excel | Visual & Manual Methods

Edit page breaks in Excel by switching to Page Break Preview and dragging blue break lines, or via the Page Layout tab’s Breaks menu to insert, remove, or reset breaks.

Most people don’t realize that Excel’s page breaks are temporary visual guides — they reset when you close the file unless you manually adjust them in the right view. Luckily, editing them takes seconds. Whether you need to move an automatic break, add a manual one, or clean up a mess of reset lines, here’s exactly how to do it in two reliable ways.

Editing Page Breaks Visually (Drag-and-Drop)

The fastest way to edit page breaks is to see them. Enter Page Break Preview and drag the blue lines to where you want each page to split.

1. Click the View tab on the ribbon.
2. In the Workbook Views group, select Page Break Preview. (You can also click the small page-break icon on the status bar at the bottom right.)
3. Automatic breaks appear as dotted blue lines; manual breaks you’ve set appear as solid blue lines.
4. Hover over a break line until the cursor turns into a double‑headed arrow.
5. Click and drag the line to the row (for horizontal breaks) or column (for vertical breaks) where you want it.
6. Release the mouse. Excel instantly applies the change.

A beginner sees the double‑arrow cursor immediately — if you don’t, make sure drag‑and‑drop is enabled under File > Options > Advanced > Enable fill handle and cell drag‑and‑drop.

Using the Ribbon Menu to Edit Page Breaks

When you need precision, the ribbon’s Breaks menu gives you exact control over inserting, removing, and resetting page breaks without touching the blue lines.

Insert a Manual Break

1. Select the row below where you want a horizontal break (or the column to the right for a vertical break).
2. Go to the Page Layout tab.
3. In the Page Setup group, click Breaks > Insert Page Break.

If your cursor is in column A, only a horizontal break is created. If it’s in any other column, a vertical break appears to the left of the selected column too — knowing this quirk prevents accidental splits.

Remove a Specific Break

1. Select the row below a horizontal break (or the column to the right of a vertical break).
2. On the Page Layout tab, click Breaks > Remove Page Break.

Reset All Manual Breaks

1. Go to Page Layout > Breaks > Reset All Page Breaks.

This reverts every manual adjustment back to Excel’s automatic calculation, which depends on your margins, paper size, and scaling settings.

Common Page Break Mistakes (and How to Fix Them)

Most errors come from a simple wrong selection. Here are the three you’ll run into most often.

• Selecting the wrong row or column. Insert and remove operations target the row above or the column to the left. Always pick the row below a horizontal break or the column to the right of a vertical one.
• Accidentally creating two breaks at once. Insert a break when your cursor is in column B, and Excel splits both above the row and left of the column. Stick to column A if you only want a horizontal break.
• Drag‑and‑drop not working. The cursor stays normal because the feature is disabled. Go to File > Options > Advanced and under Editing options, check Enable fill handle and cell drag‑and‑drop.

How Do You Fix Hidden Page Breaks?

If you can’t see the blue lines at all, or you can see them but can’t interact with them, the display setting is likely off.

1. Click File > Options.
2. Select Advanced and scroll to Display options for this worksheet.
3. Make sure Show page breaks is checked.

If the check box is already checked but breaks still don’t appear, switch to Page Break Preview anyway — breaks are always visible there.

Editing Page Breaks in Excel: What to Remember

• Always work in Page Break Preview for visual adjustments.
• Use the Page Layout > Breaks menu for insert/remove/reset commands.
• Check your selection: row below for horizontal, column to the right for vertical.
• If your cursor doesn’t change to a double arrow, enable drag‑and‑drop in Excel Options.
• Page breaks are layout settings, not cell data — they won’t affect formulas or values.

Knowing these two methods means you can control exactly how your spreadsheet prints, whether you’re splitting a budget report or fixing a stubborn table that keeps breaking in the wrong place. For official documentation, see Microsoft’s page break guide.