Extend a Page Break in Excel: Adjust Print Layout

To extend a page break in Excel, open View > Page Break Preview, then drag the blue page boundary to the row or column where you want the printed page to end. A horizontal boundary moved down includes more rows on that page; a vertical boundary moved right includes more columns.

What extending a page break means

Excel divides a worksheet into printed pages using page breaks. A horizontal break separates one group of rows from the next printed page, while a vertical break separates columns. Moving a break changes where the page ends; it does not lengthen a line inside a cell or change the worksheet itself. The change affects print layout, not the values or arrangement of your data.

People often say they want to extend a page break when they want more of a table to fit on one printed page. For example, if a report prints columns A through F on the first page and columns G through J on the next, moving the vertical break to the right may bring more columns onto the first page. If a page contains rows 1 through 35 and you want it to include rows through 45, move its horizontal break down.

Excel creates automatic breaks based on the paper size, margins, orientation, scaling, and printer settings. In Page Break Preview, automatic breaks appear as dashed blue lines, while manually adjusted or inserted breaks appear as solid blue lines. The preview also shows page numbers and helps you see which parts of the sheet will print on each page.

Move a page break in Page Break Preview

Open the worksheet you want to print in the Excel desktop app.
Select View > Page Break Preview. If Excel displays a message about the print area, confirm it or adjust the area first.
Find the blue line that marks the page boundary. Drag a horizontal line up or down, or a vertical line left or right, to the desired row or column boundary.
Check the page numbers and the resulting page divisions. If the layout looks right, select View > Normal to return to the regular worksheet view.
Open File > Print and inspect the preview before printing. Page divisions can look different if the selected printer or paper settings change.

Drag the boundary itself rather than a cell border. Excel places page breaks between rows or columns, so you cannot position one halfway through a row or column. If dragging a line is difficult, zoom in or use the horizontal and vertical scroll bars to bring the boundary into view.

Extend one page without changing the whole worksheet

Moving a break can affect how several adjoining pages are divided. Before adjusting it, identify the exact rows and columns that should print together. In a wide table, you might move a vertical break so that a small final column joins the other columns on page one. In a long report, you might move a horizontal break so a short section heading and its first few data rows stay together.

If the adjustment creates an awkward page elsewhere, you can add another manual break to control the next division. Select the cell below and to the right of the point where you want the break, then use Page Layout > Breaks > Insert Page Break. Excel inserts a horizontal break above the selected cell and a vertical break to its left. Selecting a whole row or column before inserting a break creates a break in that direction. Use this carefully: extra manual breaks can produce more pages than expected.

To remove a particular manual break, select a cell immediately below or to the right of it and use Page Layout > Breaks > Remove Page Break. To clear manual breaks throughout the worksheet, choose Page Layout > Breaks > Reset All Page Breaks. Resetting returns the layout to automatic breaks; it does not erase worksheet content.

How print settings affect page breaks

A page break is not an independent print setting. Excel calculates where content fits using the paper size and the available printable area, which is affected by margins and orientation. A change to any of these can move automatic breaks. For instance, switching from portrait to landscape gives a wide table more horizontal room, while narrow margins usually allow more content on each page.

Check these settings when the break will not stay where you expect:

Paper size: Confirm the size selected for the worksheet and the printer, such as Letter or A4.
Orientation: Use landscape for a wide report if that makes the columns easier to read.
Margins: Review Page Layout > Margins; larger margins leave less printable space.
Print area: Check Page Layout > Print Area. A defined print area can exclude rows or columns you expect to see.
Scaling: Look at the Scale to Fit settings on the Page Layout tab, and at the scaling options in the File > Print screen.

A useful sequence is to set paper size, orientation, margins, and print area first, then adjust page breaks. Otherwise, changing one of those settings afterward may cause Excel to recalculate the automatic divisions and undo the layout you were trying to achieve.

Page breaks versus fitting a sheet to a page

Moving a break and scaling a sheet solve different problems. Moving a break determines where one printed page ends and the next begins. Scaling reduces or enlarges the printed worksheet so that a chosen amount of content fits into a specified number of pages.

If you need every column on one page but can allow the rows to continue across multiple pages, use the Scale to Fit controls on Page Layout: set Width to 1 page and leave Height at Automatic. If you set both width and height to one page, Excel attempts to squeeze the entire print area onto a single page. For a large worksheet, the resulting text may be too small to read. The File > Print scaling menu also includes options such as fitting the sheet to one page; check its preview to judge the result.

Use page breaks when the print size is already readable and you want to control the page divisions. Use scaling when the main goal is to fit a set number of rows or columns onto pages. Sometimes a combination works best: set a sensible width, keep the height automatic, and then adjust horizontal breaks to avoid separating related sections.

Common problems and practical fixes

The blue line will not move. Make sure you are in Page Break Preview and dragging the line, not a worksheet gridline. Also check whether the line is an automatic break; dragging it in this view is the way to set a manual division. A protected sheet or a view that is not Page Break Preview can also prevent the expected interaction.

The break moves back after a layout change. Excel may recalculate page divisions when you change orientation, paper size, scaling, margins, or the printer. Set those options first, then reposition the breaks and review the print preview again.

Some columns or rows are missing. Check whether a print area is limiting the output. Use Page Layout > Print Area > Clear Print Area if you want the whole used sheet considered for printing. Also check for hidden rows or columns and confirm that the preview is showing the intended worksheet.

The page is technically correct but hard to read. Avoid forcing a large worksheet onto one page just to remove extra pages. Use landscape orientation, adjust margins, or print related columns on separate pages with repeated headings. For a multipage table, Page Layout > Print Titles lets you specify rows or columns to repeat on each printed page, so readers do not have to guess what the values represent.

The preview differs from the printout. Check that the selected printer and paper size match the physical printer. Printer drivers can have different printable margins, and selecting another printer may change the page layout. Review File > Print after making the final printer selection.

Excel on Mac and Excel for the web

In Excel for Microsoft 365 on Windows, use View > Page Break Preview and drag the blue boundaries. Excel for Mac also has Page Break Preview and page-break controls, although ribbon placement and wording can vary slightly by version. If the view or command is not visible, check the View and Page Layout tabs in the Mac app. The desktop steps are preferable when you need precise manual control over printed page divisions.

Excel for the web has a more limited set of print-layout controls than the desktop app, and its available page-break editing options can differ. If you cannot drag or insert the break in the browser, choose to open the workbook in the desktop Excel app, make the change there, and save the workbook. Avoid assuming a browser print preview exposes every desktop page-break setting.

Frequently Asked Questions

How do I make an Excel page break go farther down? In Page Break Preview, drag the horizontal blue boundary downward to the row where you want that printed page to end. Then check File > Print to confirm the page contains the intended rows.

Can I extend a page break to include more columns? Yes. Drag a vertical blue boundary to the right in Page Break Preview. If the columns become too small or spill onto more pages, consider landscape orientation or setting the print width to one page.

Why are page breaks dotted in Excel? Dotted blue lines indicate automatic page breaks, which Excel calculates from the current print settings. Solid blue lines indicate manual breaks. Adjusting a boundary in Page Break Preview lets you control the division.

How do I remove all page breaks in Excel? Select Page Layout > Breaks > Reset All Page Breaks. This removes manual page-break adjustments from the worksheet and lets Excel calculate the divisions again.

Can I extend a page break without shrinking the text? Yes. Move the break rather than choosing a fit-to-one-page scaling option. A page may then use an additional sheet of paper, but Excel will not need to shrink all the content simply to force it onto one 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.