Can You Put a Page Break in Excel? Here’s How

Can You Put a Page Break in Excel? Here's How

Yes. In Excel for Microsoft 365 on Windows, select the cell below and to the right of where you want the new page to begin, then choose Page Layout > Breaks > Insert Page Break. Excel adds a horizontal break above the selected cell and a vertical break to its left; you can also insert just one kind by selecting an entire row or column.

What a page break does in Excel

A page break marks where Excel should divide a worksheet when it is printed or saved as a PDF. It does not split the worksheet itself, move data to another sheet, or change what appears on screen during ordinary editing. Instead, it controls the boundary between printed pages.

Excel places automatic page breaks according to the paper size, margins, orientation, scaling, and the amount of printable content. A manual page break lets you adjust that layout—for example, to keep a report section together or start a new department’s figures on a fresh sheet of paper. The worksheet can still be edited normally after you add one.

Page breaks are different from page layout options such as margins or print areas. A print area tells Excel which cells to print; a page break tells it where to divide those cells across pages. You may use both when you want to print only part of a worksheet and control how that part is divided.

How to insert a horizontal or vertical break

Choose the location based on the direction you want the printed pages to divide:

Horizontal break: Select the row immediately below the point where the next printed page should start. Choose Page Layout > Breaks > Insert Page Break.
Vertical break: Select the column immediately to the right of the point where the next printed page should start. Choose Page Layout > Breaks > Insert Page Break.
Both directions: Select the cell below and to the right of the desired intersection. Excel inserts a horizontal break above it and a vertical break to its left.

For example, suppose a worksheet has a heading in row 1, data in rows 2 through 40, and a second section beginning in row 41. To start the second section on a new printed page, select row 41 and insert a break. If columns A through D should print separately from columns E onward, select column E and insert a break. Check the result in Page Break Preview before printing; a break can create a page that is too narrow or leave a large blank area.

On Excel for Mac, the equivalent command is also on the Page Layout tab under Breaks. Ribbon details can vary with the Excel version and window size, so if the command is not immediately visible, expand the ribbon or look for the Breaks menu on that tab.

See and adjust breaks in Page Break Preview

Page Break Preview gives you a view of the worksheet divided into printed pages. In Windows, choose View > Page Break Preview. Excel outlines the page boundaries and displays page numbers over the sheet. This is usually the clearest way to see whether your manual break is where you intended and how automatic breaks divide the remaining content.

You can adjust a break by dragging its boundary in Page Break Preview. Moving a horizontal boundary changes how many rows fit on one page; moving a vertical boundary changes how many columns fit. Be careful not to make a page impractically small: fitting one more row may leave too little room for readable headings or notes.

Return to the normal worksheet view by choosing View > Normal. The breaks may still appear as dashed or solid lines after you return to editing. Those indicators do not print as worksheet content. If they are distracting, you can hide page break indicators in Excel’s display options for the current worksheet, though the exact options dialog can differ by version.

Manual breaks, automatic breaks, and resetting them

Excel creates automatic breaks when it calculates how worksheet content fits on the selected paper. In Page Break Preview, automatic breaks generally appear as dashed lines and manual breaks as solid lines. The distinction matters: a manual break is an instruction you added, while an automatic break can shift when the layout changes.

To remove a particular manual 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. For a break in both directions, select the cell immediately below and to the right of the intersection and use the removal command. If you want to clear all manual breaks from the sheet, choose Page Layout > Breaks > Reset All Page Breaks.

Resetting removes the manual adjustments, not the worksheet’s data. Excel recalculates automatic breaks from the current print settings. If you are unsure whether you will want to restore your layout, note the locations first or save a copy of the workbook.

Make page breaks work with print settings

A break’s position is only one part of the printed layout. Before refining page boundaries, check the settings that affect how much content fits on a page:

Orientation: Page Layout > Orientation lets you choose Portrait or Landscape. Landscape often helps when a table has many columns.
Paper size and margins: Page Layout includes controls for paper size and margins. A printer may not support every paper size, so confirm the selected size matches the paper or PDF layout you need.
Print area: Select the intended cells, then choose Page Layout > Print Area > Set Print Area to exclude unrelated worksheet content.
Print titles: If a table spans multiple pages, Page Layout > Print Titles lets you repeat selected rows or columns, such as a header row, on each printed page.
Scaling: Page Layout’s Scale to Fit controls can shrink a sheet to fit a set number of pages. Scaling can change how much content fits and may make manual breaks behave differently, so inspect the result rather than assuming the original layout is preserved.

Use File > Print to inspect the print preview before sending the job to a printer. The preview can reveal a blank page, a split heading, or a table that has become too small. You can revise the page setup, return to the worksheet, and preview again. A good sequence is to set the print area and paper orientation first, then add manual breaks, and finally check the preview.

Common page-break problems and fixes

The break appears in the wrong place. Remember that Excel places a horizontal break above the selected row and a vertical break to the left of the selected column. If you selected the row or column where you want content to begin, that is the correct selection. Selecting the row or column just before the intended start is a common source of confusion.

The break seems to disappear. Check that you are viewing the worksheet in Page Break Preview and that the change was made on the sheet you intend to print. Also review scaling settings: forcing a sheet to fit a specified page count can alter the layout you expected from manual breaks.

A blank page prints. Content or formatting far beyond the visible table, a print area that includes extra cells, or a misplaced manual break may create an additional page. Inspect the page boundaries in Page Break Preview, review the print area, and use File > Print to confirm which pages Excel will produce.

A row of data is split across pages. Insert a horizontal break before the row that should begin the next page, or adjust the existing boundary in Page Break Preview. If the entire table is simply too long for one page, repeating its header row with Print Titles can make the continuation easier to read.

The printed pages are too small. A manual break can create more pages, but it cannot make an oversized table readable if other settings shrink it heavily. Try Landscape orientation, narrower margins, or a sensible print area. If readers need to examine the data, several legible pages are often better than squeezing every column onto one sheet.

Excel for the web and printing

These instructions are for the desktop version of Excel for Microsoft 365 on Windows. Excel for the web can open and print workbooks, but its page-layout controls do not provide the same full manual page-break workflow as desktop Excel. If you need to insert, move, or carefully manage manual breaks, open the workbook in the desktop application. Avoid assuming that a layout created in one environment will print identically in another; printer settings and available layout controls can differ.

On Mac, use the Page Layout tab and its Breaks command for manual page breaks. You can also use the print preview to review the output. The ribbon’s appearance differs somewhat from Windows, but the page-break concept is the same: select the row, column, or cell that determines the boundary, then insert or remove the break.

Frequently Asked Questions

Can I insert a page break in Excel without printing?

Yes. You can add and adjust breaks while editing the workbook, but they affect printed output or a PDF rather than the normal on-screen worksheet grid. Use Page Break Preview to inspect them.

How do I start a new printed page at a specific row?

Select the row where the new page should begin, then choose Page Layout > Breaks > Insert Page Break. Excel places a horizontal break above that row.

Can I remove all page breaks at once?

Yes. Choose Page Layout > Breaks > Reset All Page Breaks. Excel clears the manual breaks on the worksheet and recalculates automatic breaks.

Do page breaks change the worksheet or delete data?

No. Inserting or removing a page break changes the printed-page layout, not the cell contents. Resetting breaks also leaves worksheet data intact.

Why does my page break not match the printed result?

Paper size, margins, orientation, scaling, and printer settings all affect pagination. Check the settings and review File > Print before printing; a preview is the best way to catch differences in page count or layout.

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.