Excel Adjust Page Breaks for a Better Print Layout

To adjust a print page break in Excel for Microsoft 365 on Windows, choose View > Page Break Preview, then drag a blue page-break line to where you want the printed page to end. For more exact control, select a row or column at the boundary and use Page Layout > Breaks to insert or remove a break.

What a page break controls

A page break marks where Excel divides a worksheet when it prints or creates a PDF. A horizontal break separates rows onto different pages; a vertical break separates columns. For example, a wide sales table might fit on one page vertically but split its columns across two pages. Moving a vertical break can keep related columns together, while moving a horizontal break can prevent a table heading or group of records from being split awkwardly.

Excel calculates automatic breaks using the selected paper size, page orientation, margins, cell dimensions, print area, and scaling settings. A worksheet that looks like one continuous grid on screen may therefore span many printed pages. Page breaks change the division of the printed output, not the data or the worksheet’s on-screen layout.

Show and move page breaks

Open the worksheet and select View > Page Break Preview. If Excel asks whether to show page breaks, confirm.
Look for the blue boundaries around the print pages. The page numbers and gray area outside the printable region help show how the sheet is divided.
Point to a boundary line. When the pointer changes to a two-headed arrow, drag the line to the desired row or column boundary.
Choose View > Normal when you are finished, or use the page-break view to continue adjusting.

Dragging an automatic break changes it into a manual break, giving Excel a specific boundary to follow. A manual break is commonly shown as a solid blue line, while an automatic break is commonly dashed. The exact appearance can vary with the view and application version, so use the page numbers and print preview as well as the line style to judge the result.

For example, if a report’s first page ends after row 38 but row 39 begins a new department, drag the horizontal boundary so the department starts on the next page. If the columns for quantity and price are being split, drag the vertical boundary to put both on the same printed page, provided the resulting page width remains readable.

Insert, remove, and reset breaks

You can insert a page break at a precise cell boundary instead of dragging. To add a horizontal break above a row, select the row below the intended break. To add a vertical break to the left of a column, select the column to its right. Then choose Page Layout > Breaks > Insert Page Break. If you select a cell rather than an entire row or column, Excel can insert both a horizontal break above that cell and a vertical break to its left.

To remove a particular break, select a cell just below and to the right of it, then choose Page Layout > Breaks > Remove Page Break. The selected cell matters when there are breaks in both directions: Excel removes the applicable boundary or boundaries associated with that position. If the result is not the one you intended, use Undo immediately and select a different cell.

To clear manual breaks across the worksheet, choose Page Layout > Breaks > Reset All Page Breaks. This does not erase worksheet data or formatting. Excel returns to calculating the breaks automatically, though the print layout may still be influenced by scaling, margins, print area, and paper settings. Resetting all breaks is useful when a sheet has accumulated many manual adjustments and you want to start over.

Automatic versus manual breaks

Automatic breaks are Excel’s calculated divisions. They move when you change the worksheet’s layout or print settings. If you widen columns, change from portrait to landscape, or use a different paper size, Excel may fit a different number of columns or rows on each page.

Manual breaks are boundaries you add or create by dragging. They can help keep a section together or make a report begin a new page at a meaningful point. However, a manual break is not a command to make the content fit. If a page contains too many wide columns, Excel may scale the content down or create a crowded printout rather than produce a neatly readable page. Check the preview after placing manual breaks, especially after changing margins, paper size, or scaling.

A common misconception is that inserting a break will repeat a table’s heading row on every page. It will not: a page break only determines where a page ends. To repeat headings, use Page Layout > Print Titles and set the rows to repeat at the top. Similarly, a page break does not define which cells print; use Page Layout > Print Area > Set Print Area if you need to limit the output to a specific range.

Plan a readable page layout

Before adding many breaks, decide what the printed pages should communicate. A small worksheet may need only a better orientation or a narrower margin; a long report may need deliberate breaks at section boundaries. Consider these adjustments in a practical order:

Set the paper size and orientation on the Page Layout tab. Landscape orientation can help a wide table, while portrait often suits a list with many rows and few columns.
Review margins. Narrower margins can make room for more content, but leave enough space for printers that cannot print to the very edge of the paper.
Check the print area. A stray value or formatting far from the main table can make Excel treat a larger region as relevant. Set a print area when only a defined range should print.
Use repeating title rows for multi-page tables so readers can identify the columns on later pages.
Use manual breaks to separate meaningful sections, not simply to force every page to contain the same number of rows.

For instance, a monthly report with columns A through H and several hundred records may be easier to read in landscape orientation, with the date and account headings repeated at the top. A manual horizontal break before a new month can make the report easier to scan, but forcing all eight columns onto one page wide may shrink text too much. In that case, consider reducing unnecessary column widths or printing a selected range rather than accepting unreadably small scaling.

Use print preview to verify results

Page Break Preview is useful for arranging boundaries, but always check the actual output before sharing or printing. Press Ctrl+P on Windows to open the Print screen and preview the pages. Inspect page count, clipped text, blank pages, and whether important columns appear together. On a Mac, use Command+P for printing; the ribbon labels and dialogs are similar, although details can differ by Excel release.

If the preview does not match the intended layout, check the settings that affect pagination. The Page Layout tab includes orientation, size, margins, print area, and Scale to Fit controls. In Scale to Fit, setting Width to 1 page can put all selected columns across one page, but it may reduce text size substantially. Use Height as well only when fitting the entire sheet onto a fixed number of pages is appropriate. Compare the result at normal reading size instead of assuming that fewer pages means a better layout.

For reports that need predictable output, verify the selected printer or PDF destination too. Different printers can have different printable margins, and a change of paper size can alter page boundaries. If the workbook will be opened on another computer, save it after setting the print layout and ask the recipient to review the preview because printer settings may differ.

Common page-break problems

The line will not move: Check whether the sheet is in Page Break Preview and whether scaling is set to fit the sheet to a specified number of pages. Excel may ignore manual page breaks when the Fit to scaling option is used. Try setting Width and Height to Automatic in Scale to Fit, or adjust scaling using the percentage option, then revisit Page Break Preview.
The printout has unexpected blank pages: Inspect the print area and the used range, and look for stray content or formatting far from the table. Also check for manual breaks and print scaling. Resetting all page breaks can help identify whether a manual boundary caused the extra page.
A heading appears only on the first page: A page break will not repeat headings. Set repeating rows through Page Layout > Print Titles.
Everything is tiny after a change: A fit-to-width setting may have compressed many columns onto one page. Allow more pages across, reduce unnecessary column widths, or use landscape orientation rather than forcing a single page.
Break lines are not visible in Normal view: Return to View > Page Break Preview. Normal view is intended for editing worksheet content, not arranging page boundaries.

Excel for Mac and Excel for the web

In Excel for Mac, Page Break Preview and the Page Layout tab provide similar ways to arrange print pages, though the ribbon and dialog layout may vary slightly by version. Use the Mac menu and ribbon labels shown in your installation if a command is in a different location. The common print shortcut differs: Command+P on Mac, rather than Ctrl+P on Windows.

Excel for the web can print a workbook and offers print-related options, but its editing experience does not provide the same full desktop page-break workflow in every situation. If you need to drag or manage manual breaks and cannot find the relevant controls in the browser, open the workbook in the Excel desktop app. After making changes, review the browser or desktop print preview because rendering can depend on the print settings and destination.

Frequently Asked Questions

How do I move a page break in Excel?
Choose View > Page Break Preview, then drag the blue boundary to a new row or column boundary. Check the Print preview afterward to confirm that the page count and content are still suitable.

How do I remove a page break without resetting all of them?
Select a cell below and to the right of the break, then choose Page Layout > Breaks > Remove Page Break. If the wrong boundary is affected, undo and try a cell in a different position.

Why does Excel ignore my manual page break?
A Fit to scaling setting can cause Excel to disregard manual breaks. Check Page Layout > Scale to Fit and set Width and Height to Automatic, or use percentage scaling, before adjusting the break again.

Can I make Excel print all columns on one page?
Yes. Set Width to 1 page in the Scale to Fit controls, but inspect the preview for text that has become too small. Landscape orientation or narrower columns may be more readable than squeezing a very wide table onto one sheet.

Do page breaks repeat column headings on every printed page?
No. Page breaks decide where pages divide. To repeat headings, choose Page Layout > Print Titles and specify the rows to repeat at the top of each page.

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.