Excel Change Page Breaks: Adjust Print Layout

To change a page break in Excel for Microsoft 365 on Windows, open View > Page Break Preview and drag a break line to a new position. To add or remove a break precisely, select the relevant row or column, then use Page Layout > Breaks. Page breaks affect printed pages, not the rows or columns shown on your worksheet.

What Page Breaks Do in Excel

Excel divides a worksheet into printed pages by placing horizontal breaks between rows and vertical breaks between columns. Some breaks are automatic: Excel calculates them from the paper size, page orientation, margins, print area, scaling settings, and available printer information. You can add manual breaks to control where a page ends, such as keeping a report heading with its data or starting each department on a separate sheet of paper.

In Page Break Preview, solid blue lines indicate manual page breaks, while dashed blue lines indicate automatic breaks. The preview also shows the printable pages and the areas outside the print range. A break is a print-layout instruction; it does not insert a blank row, split a cell, or change the underlying data.

Page breaks are useful when a worksheet is too large to print as one page, but they are not always the best first adjustment. If a table is only slightly too wide, changing orientation or margins may produce a more readable result than forcing an extra vertical break.

Move a Page Break in Page Break Preview

Open the worksheet you want to print and select View > Page Break Preview. You can also use the Page Break Preview button near the view controls at the bottom of the Excel window.
If Excel displays a message about page breaks, confirm it to continue. The worksheet will show page boundaries and page numbers.
Point to the blue horizontal or vertical line you want to move. When the pointer changes to a move pointer, drag the line to the desired row or column boundary.
Choose View > Normal when you are finished. Use File > Print, or press Ctrl+P on Windows, to check the resulting pages in print preview.

Moving a line changes the boundary between printed pages. For example, if a page ends after row 25 and you drag its horizontal break below row 30, rows 26 through 30 move onto the first page, provided the paper and scaling settings leave enough room. If you drag a break past another boundary, Excel may rearrange which rows or columns fit on each page. Check the preview rather than assuming a particular number of pages will result.

Insert or Remove a Specific Break

Use the Breaks command when you know the exact row or column where a page should begin. To insert a horizontal break above row 26, select row 26, then choose Page Layout > Breaks > Insert Page Break. To insert a vertical break to the left of column D, select column D and choose the same command. If you select a cell instead of an entire row or column, Excel can insert a horizontal break above it and a vertical break to its left.

To remove an individual break, select a cell immediately below the horizontal break or immediately to the right of the vertical break, then choose Page Layout > Breaks > Remove Page Break. The wording in the menu can vary slightly by Excel build, but the Breaks menu contains the insert, remove, and reset commands. If you want to remove all manual breaks from the worksheet, choose Page Layout > Breaks > Reset All Page Breaks. That restores Excel’s automatic page-break layout; it does not clear the print area or erase worksheet data.

When a horizontal and vertical break meet at a corner, select a cell on the appropriate side of the break you intend to remove. If you are unsure which line is manual, switch to Page Break Preview: the solid and dashed line styles help distinguish them.

Understand Automatic and Manual Breaks

Automatic breaks are Excel’s best fit for the current print settings, not fixed boundaries. Changing the paper from Letter to A4, switching from portrait to landscape, adjusting margins, or choosing a different printer can move them. A change in the worksheet’s print area or scaling can also alter where automatic breaks fall. It is therefore normal for a worksheet to paginate differently after a layout change.

A manual break gives you more control, but it does not guarantee that a page will contain a certain amount of information under every setup. If you change the paper size or scaling after placing manual breaks, the printed result can still change. In particular, when the Fit to option is used in Scale to Fit, Excel ignores manual page breaks. If you need the breaks themselves to control pagination, review the scaling choice as well as the break lines.

Excel may adjust or reposition automatic breaks after a manual break is added. That does not mean the manual break failed: it means Excel has recalculated the remaining page boundaries around your instruction. Revisit Page Break Preview after changing other layout settings.

Adjust Print Settings Before Adding Breaks

Before adding many manual breaks, decide whether the sheet should be narrower, wider, or split into a different number of pages. On the Page Layout tab, the Page Setup group provides Size, Orientation, and Margins. The Scale to Fit group lets you set the printed width and height. These options often solve awkward pagination more cleanly than inserting breaks one by one.

Wide tables: Try Page Layout > Orientation > Landscape, or reduce left and right margins. If the table must fit across one page, set Width to 1 page in Scale to Fit and leave Height set to Automatic. This keeps the columns together while allowing the rows to continue onto additional pages.
Large worksheets: Avoid forcing both width and height to 1 page unless the sheet is small. Excel may shrink the content so much that text becomes difficult to read. Letting the height remain automatic is often more legible.
Unwanted blank pages: Check the print area and look for stray formatting or content far beyond the intended table. Page Layout > Print Area > Clear Print Area removes a defined print area so Excel can calculate the printable range again.
Repeated headings: If readers need column labels on every printed page, use Page Layout > Print Titles to repeat rows or columns. Repeating headings is different from adding a page break and may be more useful for long reports.

After changing settings, open File > Print to inspect each page. Print preview is important because Page Break Preview shows boundaries but does not make small text, clipped columns, or repeated headings as easy to evaluate as the final print view.

Common Page-Break Problems

The break will not move. Check whether the worksheet is protected and whether the page is being scaled with Fit to. Also confirm that you are dragging a visible break in Page Break Preview rather than trying to move a line in Normal view. If the layout settings keep overriding your intended result, adjust the scaling first and return to the preview.

Excel keeps changing my page breaks. Automatic breaks recalculate whenever relevant print settings change. A different printer selection can also affect pagination. Set paper size, orientation, margins, print area, and scaling before fine-tuning manual breaks, then check the layout again if any of those settings change.

A page is blank or nearly empty. Look for an unintended manual break, a print area that includes extra rows or columns, or content formatted far from the main table. Use Page Break Preview to locate the affected page. Remove the unwanted manual break or reset all breaks, then check Page Layout > Print Area and the print preview.

The printed text is too small. A setting that fits a worksheet to one page in both directions can shrink a large sheet dramatically. Set one dimension to Automatic, use landscape orientation for wide data, or print the report across more pages. The goal is readable pages, not necessarily the smallest possible page count.

Break lines are missing in Normal view. Page Break Preview is the clearest place to work with them. In desktop Excel for Windows, you can also check File > Options > Advanced > Display options for this worksheet and the Show page breaks setting. If a workbook contains a very large range or Excel has not recalculated the display, reopening the worksheet or switching views may help refresh the visible boundaries.

Excel for Mac and Excel for the Web

In Excel for Mac, use the View tab’s Page Break Preview and the Page Layout tab’s Breaks menu to work with page breaks. The exact ribbon arrangement may differ from Windows, but the same basic method applies: drag a boundary in the preview, or select a row or column and use the break command. On a Mac, use Command+P to open print options; Ctrl+P is the Windows shortcut.

Excel for the web has a more limited set of print-layout controls than the desktop application. It can help you review and print a workbook, but if you need to position or manage manual page breaks precisely, open the file in the desktop version of Excel. Print settings and pagination can also vary with the browser and available print options, so inspect the final print preview before sending pages to a printer.

Frequently Asked Questions

How do I change a page break in Excel? Choose View > Page Break Preview and drag the blue break line. To set a break at a particular row or column, select that row or column and choose Page Layout > Breaks > Insert Page Break.

How do I delete all page breaks in Excel? Choose Page Layout > Breaks > Reset All Page Breaks. Excel removes manual breaks and recalculates automatic breaks. This does not delete data or clear a print area.

Why are my Excel page breaks dotted? Dashed or dotted lines usually mark automatic page breaks, which Excel calculates from the current paper and print settings. In Page Break Preview, solid blue lines identify manual breaks.

Can I change page breaks without changing the worksheet? Yes. Page breaks control how worksheet content is divided for printing; changing them does not move or delete cells. They may change which rows and columns appear together on each printed page.

Why does Excel ignore my manual page break? One common cause is using Fit to in the Scale to Fit settings, which overrides manual page breaks. Review the scaling settings, then check the worksheet again in Page Break Preview.

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.