Adjust Page Breaks in Excel: Steps and Tips

To adjust a page break in Excel for Microsoft 365 on Windows, go to View > Page Break Preview, then drag a blue page-break line to where you want the printed page to end. To add one at a specific row or column, select the cell below or to the right of the break, then choose Page Layout > Breaks > Insert Page Break.

Quick steps for adjusting a page break

Page breaks control where a worksheet is divided into pages when printed or saved as a PDF. They do not split, move, or delete worksheet data. For a quick visual adjustment:

Open the worksheet you want to print.
Select View > Page Break Preview. If Excel displays a message about page breaks, confirm it to continue.
Find the blue line that marks the page boundary. Drag it to the row or column boundary where the new page should start.
Choose File > Print or press Ctrl+P to check the page layout in Print Preview.

Use Page Break Preview when possible: the sheet is divided into page-shaped areas, making it easier to see what will print together. If the result is not right, return to the preview, move the line again, and check the print preview once more.

What page breaks do in Excel

A page break tells Excel where one printed page ends and the next begins. A horizontal break separates rows; a vertical break separates columns. For example, if a report has a summary in rows 1 through 20 and detailed records below, a horizontal break above row 21 can keep the summary on its own page. A vertical break can keep a wide worksheet from printing an unwanted sliver of columns on a separate page.

Excel creates automatic page breaks based on the printable page size, paper size, margins, orientation, and scaling. These are recalculated when those settings or the worksheet layout change. You can add manual breaks to take control, but the printed output still depends on the page setup. A break is not a guarantee that a particular number of rows will fit: different fonts, column widths, printer settings, and paper sizes can change the result.

In Page Break Preview, automatic breaks usually appear as dashed blue lines and manual breaks as solid blue lines. A manual break remains in place as a chosen boundary unless you change it or alter settings that affect how Excel scales the sheet.

Insert a horizontal or vertical page break

Excel places a break above and to the left of the selected cell. Select the cell just below the row where a horizontal page should begin, or just to the right of the column where a vertical page should begin. Then choose Page Layout > Breaks > Insert Page Break.

Horizontal example: To start a new page above row 25, select a cell in row 25, such as A25, and insert the break. The page break goes above row 25.
Vertical example: To start a new page before column F, select a cell in column F, such as F1, and insert the break. The break goes to the left of column F.
Both directions: Select a cell such as F25 to insert a horizontal break above row 25 and a vertical break to the left of column F.

If you select an entire row or column before using the command, Excel inserts the corresponding horizontal or vertical break. The command may be unavailable when the selection is at the top or left edge, where a break cannot create a meaningful additional page. Check Page Break Preview after inserting a break to confirm its position.

Move a page break by dragging it

In View > Page Break Preview, position the pointer over the blue line and drag it to a different row or column boundary. Moving a horizontal line changes which rows print on each page; moving a vertical line changes which columns print together. The boundary you choose is a worksheet row or column boundary, not a point within a cell.

Moving an automatic break makes the chosen location a manual break. This is useful when Excel has split a table or section in an awkward place. For instance, if a heading appears at the bottom of one page and its records begin on the next, move the horizontal break so the heading and the first records stay together. You may need to adjust row heights or margins as well if the content still does not fit cleanly.

To make a page taller or wider, drag its boundary outward, but keep the printable area in mind. A page cannot use space beyond the paper edges and margins. Dragging a break too far may cause Excel to create another page or may not produce the layout you expect if scaling is limiting the sheet.

Remove one break or reset all breaks

To remove a single manual break, select the cell immediately below a horizontal break and choose Page Layout > Breaks > Remove Page Break. For a vertical break, select a cell immediately to its right. You can also select the cell below and to the right of an intersection if you want to remove both breaks at that location. Verify the selection in Page Break Preview before removing the break, especially in a sheet with several nearby boundaries.

To clear manual page breaks from the active worksheet, choose Page Layout > Breaks > Reset All Page Breaks. This removes the manual breaks and lets Excel determine the page divisions again. It does not erase worksheet contents or clear the print area. If you only want to undo the most recent edit, Ctrl+Z may undo it, but resetting all breaks is the clearer option when you want to return to automatic pagination.

Check scaling, margins, and paper size

A page break can appear misplaced because the worksheet is being scaled or the page setup differs from what you expect. On the Page Layout tab, check the Scale to Fit group, where the Width, Height, and Scale controls affect how much of the sheet is fitted onto pages. Setting the width to one page, for example, can shrink many columns to fit across a single printed page. That may make text too small even though it avoids extra pages.

You can also open the Page Setup dialog from the small dialog box launcher in the Page Setup group. Its Page tab includes orientation, paper size, and scaling options. In the dialog, choosing Fit to a specified number of pages can cause Excel to disregard manual page breaks. If you need precise manual boundaries, avoid fitting the entire sheet to a fixed page count; use a suitable paper size and orientation, then adjust breaks and preview the result.

Margins reduce the usable printing area. If a worksheet is only a little too wide or tall, Page Layout > Margins may offer a cleaner solution than shrinking all content. Landscape orientation can help a wide table, while portrait may suit a long, narrow list. These choices affect pagination, so make them before fine-tuning breaks.

Common page-break problems and fixes

The break will not move as expected: Check whether the sheet is using Fit to scaling. Switch to a layout that allows the required manual breaks, then revisit Page Break Preview.
There are more pages than expected: Check for narrow printable space caused by margins, portrait orientation, a large paper size mismatch, or columns extending beyond the intended report. Print Preview shows the actual page count and divisions.
Text is tiny: Excel may be shrinking the sheet to fit a page or page count. Try a wider paper orientation, adjust margins, or allow additional pages instead of forcing all content onto one.
A page contains only a few columns or rows: Look for a manual break, then remove it or use Reset All Page Breaks. Also check whether the print area includes unintended blank rows or columns.
Page breaks seem to change after editing: Automatic breaks are recalculated when content or page setup changes. Manual breaks can also be affected by scaling choices. Recheck the preview after changing column widths, row heights, paper size, or orientation.

Normal view is useful for editing data, but it may not show the full page arrangement. Excel can display page-break indicators in Normal view after you have viewed or printed the sheet, but Page Break Preview is the more direct way to inspect and move boundaries. Do not rely on a dotted line seen in the worksheet alone; confirm the final output in File > Print.

Page breaks, print areas, and repeated headings

Page breaks solve a different problem from print areas and print titles. A print area limits which cells are included in printing. Select the desired range and choose Page Layout > Print Area > Set Print Area. Clear it from the same menu if Excel is printing only part of the sheet unexpectedly. A print area can reduce unwanted pages, but it does not decide where the remaining content is divided.

Print titles repeat selected heading rows or columns on each printed page. Choose Page Layout > Print Titles and set rows to repeat at the top or columns to repeat at the left in the Page Setup dialog. For a long table, repeating the header row is often more useful than manually placing a break after every page. Page breaks establish boundaries; print titles make continued pages easier to read.

For example, a 60-row sales report might use a print area containing the report only, repeat its column headings on each page, and use a manual break to keep a new regional section at the top of a page. These settings work together, but each addresses a separate part of print layout.

Excel for Mac and Excel for the web

In current desktop Excel for Mac, use View > Page Break Preview to inspect the layout and drag a page boundary. The Page Layout tab also provides page setup and break controls, though ribbon arrangement and dialog details can differ from Windows. For printing, the Mac shortcut is Command+P, rather than Windows Ctrl+P.

Excel for the web has fewer page-layout controls than desktop Excel and does not provide the same full manual page-break workflow as the Windows desktop app. If you need to insert, drag, or carefully manage manual breaks, open the workbook in desktop Excel. You can then save the workbook so the layout changes are available in the file.

Frequently Asked Questions

How do I change where a page ends in Excel?
Choose View > Page Break Preview, then drag the blue boundary to a different row or column. Check File > Print to confirm the result.

How do I insert a page break after a certain row?
Select a cell in the row that should begin the next page, then choose Page Layout > Breaks > Insert Page Break. Excel inserts the horizontal break above the selected row.

Why does Excel ignore my manual page breaks?
One common cause is Fit to scaling, which can override manual breaks. Review the Scale to Fit controls or Page Setup scaling options, then preview the worksheet again.

How do I remove all page breaks in Excel?
Choose Page Layout > Breaks > Reset All Page Breaks. Excel removes the manual breaks on the active sheet and recalculates automatic ones.

Can I adjust page breaks in Excel for the web?
The web version has more limited page-layout tools than desktop Excel. Open the workbook in desktop Excel for the full Page Break Preview and manual break controls.

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.