Excel Split Print Area Into Two Pages: Page Breaks

How-to basics · Updated November 21, 2026

Yes. In Excel for Microsoft 365 on Windows, select the cells to print and choose Page Layout > Print Area > Set Print Area, then insert a page break where you want the split: select the row below a horizontal split or the column to the right of a vertical split, and choose Page Layout > Breaks > Insert Page Break. Check the result in Page Break Preview before printing.

What a print area and page break do

A print area tells Excel which cells belong in the printout; it does not, by itself, decide how those cells are divided between sheets of paper. Excel paginates the selected area according to its size, paper settings, margins, orientation, scaling, and any manual page breaks. A long report may naturally continue onto a second page, while a wide table may be divided into pages side by side.

A page break marks a boundary in that layout. A horizontal break separates rows, so the rows above it print on one page and the rows below it begin on another. A vertical break separates columns, which is useful for printing a wide table over two pages. If a table is both wide and long, Excel can create a grid of pages rather than just two.

It helps to distinguish two goals: putting a break at a particular place, and making the entire print area occupy exactly two pages. A manual break controls a boundary, but the final page count also depends on scaling and the dimensions of the content. Use both page-break controls and print preview when the page count matters.

Insert a horizontal or vertical page break

First set the print area if you do not want the whole worksheet printed. Select the intended cell range, then use Page Layout > Print Area > Set Print Area. Excel marks the chosen range as the area to print. To set a boundary inside it, use these steps:

  1. Choose View > Page Break Preview. This view shows the worksheet divided into printable pages and makes it easier to choose a boundary.
  2. For a horizontal split, select the row immediately below the row that should finish the first page. For example, to put rows 1 through 30 on page one and start page two with row 31, select row 31.
  3. For a vertical split, select the column immediately to the right of the last column for page one. To put columns A through F on the first page and begin the next page with column G, select column G.
  4. Choose Page Layout > Breaks > Insert Page Break. Return to Page Break Preview and check that the boundary falls where intended.

Selecting a whole row or column makes the intended direction clear. If you select a single cell instead, Excel can insert a horizontal break above it and a vertical break to its left, potentially creating more divisions than you wanted. To remove manual breaks and return to Excel’s automatic pagination, choose Page Layout > Breaks > Reset All Page Breaks.

Choose the direction and position of the split

Think about how someone will read the printed pages. For a list or report that continues downward, a horizontal break is usually the natural choice: page two continues with the next rows. For a broad table, a vertical break may be preferable, but splitting columns can make a reader lose track of which figures belong to which labels. Repeating identifier columns on each page can help.

For example, imagine a monthly sales table with a region column followed by 12 month columns. Splitting after June makes two landscape pages, but the second page may be hard to interpret if it no longer shows the region. You can repeat the region column on subsequent pages using Page Layout > Print Titles, then set the columns to repeat on the left in the Page Setup dialog. Repeated title columns appear on each printed page; they do not create another copy in the worksheet.

A split should generally fall between records or meaningful groups, not through a row of figures or a label that depends on the line above it. If a row is taller than the available printable space, Excel may move it to another page. Use Page Break Preview and inspect the actual page edges rather than assuming a break will divide a table exactly as it appears on screen.

Make the print area fit exactly two pages

If the requirement is exactly two pages, first decide whether the pages should be stacked vertically or placed side by side. In the Page Layout tab’s Scale to Fit group, the Width and Height settings can constrain the output. For two pages across and one page down, set Width to 2 pages and Height to 1 page. For one page across and two pages down, set Width to 1 page and Height to 2 pages.

These settings scale the printout to fit the specified number of pages. That can make text and figures smaller, especially when a large worksheet is squeezed onto two pages. Check readability in File > Print before committing to the layout. If the labels become too small, consider using landscape orientation, narrower margins, a larger paper size, or a smaller print area instead of forcing a tight fit.

There is an important interaction between scaling and manual breaks: when the worksheet is set to fit a specific number of pages, Excel may ignore manual page breaks. If a break you inserted seems to have no effect, check the Width and Height values in Scale to Fit. Set them to Automatic if you want to control pagination with manual breaks. You can then use the Adjust to percentage setting in the Page Setup dialog if you need to enlarge or reduce the printout while retaining manual breaks.

For a simple, predictable result, you can also use the Page Setup dialog. Open its dialog launcher on the Page Layout tab, then choose the Page tab. The scaling choices include fitting the sheet to a specified number of pages or printing at a percentage of normal size. The best choice depends on whether exact page count or comfortable text size matters more.

Check the layout in Page Break Preview and Print

View > Page Break Preview is the most useful place to inspect how Excel divides the sheet. It shows the page boundaries in relation to the cells, so you can spot a split through a heading, an unexpected extra page, or a large blank area. Depending on the version and view, automatic and manual breaks appear with different line styles. You can drag a boundary in this view to adjust it, but confirm the result because dragging may change the scale or page layout.

Then open File > Print to see the print preview and confirm the page count. In the settings, check that Excel is printing the active sheet or the intended selection, rather than an unintended part of the workbook. On Windows, Ctrl+P opens the Print screen; on Mac, use Command+P. The print preview is also where you can check printer, paper size, orientation, and other output settings before printing.

For two separate pages, each page should contain a useful portion of the data, not merely an empty continuation caused by an oversized print area. If the preview shows three pages, look for an extra automatic break caused by the sheet’s width or height. If the preview shows only one page, a fit-to-one-page setting may be shrinking everything together.

Fix common page-splitting problems

  • The manual break appears to be ignored: Check whether Scale to Fit is set to a specific page count. Change Width and Height to Automatic if you want the manual break to govern the division.
  • The printout has more than two pages: A break in one direction does not prevent additional breaks in the other direction. Inspect both the width and height in Page Break Preview, and check for automatic breaks beyond the intended boundary.
  • The content is tiny: Excel may be fitting a large area onto a set number of pages. Use more pages, reduce the print area, adjust margins, or change orientation rather than shrinking everything until it is unreadable.
  • The wrong cells print: Review the print area using Page Layout > Print Area. Choose Clear Print Area to remove an old setting, select the correct range, and set it again. Also verify the print selection in File > Print.
  • A break creates both vertical and horizontal divisions: It may have been inserted with a single cell selected. Reset the breaks, then select the whole row or column at the intended boundary before inserting a new one.
  • The page looks different from the worksheet: Gridlines and headings are not necessarily printed by default, and printer paper settings can differ from the worksheet’s layout. Check the print options and paper size in the preview.

Alternatives when a hard split is not ideal

A manual page break is not always the clearest solution. If a wide table is becoming difficult to read across two pages, consider printing it in landscape orientation or simplifying the report to include only relevant columns. If the report must remain readable at normal size, allowing three pages can be better than compressing it to two. You can also print selected cells as a one-off without changing the worksheet’s saved print area by selecting the cells and choosing to print the selection in the Print settings.

If your goal is to keep column headings visible as pages continue, use Print Titles rather than copying the heading row manually. If the worksheet is intended to be viewed electronically, exporting it to PDF after checking the page layout can make the page boundaries easier to share consistently. Excel for the web has fewer page-layout controls than the desktop application; if you need to insert or manage precise manual page breaks, open the workbook in the desktop version of Excel.

Frequently Asked Questions

Can I split one Excel print area into two pages?
Yes. Set the print area, then insert a horizontal break to divide rows or a vertical break to divide columns. Check File > Print to confirm that the full print area uses the two pages you expect.

How do I print columns on two pages instead of shrinking them?
Insert a vertical page break by selecting the column immediately to the right of the intended split and choosing Page Layout > Breaks > Insert Page Break. Make sure Scale to Fit is not forcing the sheet onto one page wide.

Why does Excel ignore my page break?
A fit-to-page setting in Scale to Fit can take precedence over manual page breaks. Set Width and Height to Automatic, then check the break again in Page Break Preview.

How do I remove a page break?
Select the row below a horizontal break or the column to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. To clear all manual breaks, choose Reset All Page Breaks.

Can I repeat a column on both printed pages?
Yes. Use Page Layout > Print Titles and specify the column or columns to repeat at the left in the Page Setup dialog. This is especially helpful when a wide table is split across pages.

Related

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.