How to Enter a Page Break in Excel and Control Printing

To enter a manual page break in Excel for Microsoft 365 on Windows, select the row below or the column to the right of where you want the split, then choose Page Layout > Breaks > Insert Page Break. Use View > Page Break Preview to check the result and adjust the printed pages before you print.

Insert a page break in Excel

A page break tells Excel where one printed page should end and the next should begin. It changes the print layout, not the worksheet’s cell contents or the way data is arranged on screen. You can insert a break in a worksheet using the ribbon:

Open the worksheet you intend to print and select a cell, row, or column at the proposed break.
Choose Page Layout > Breaks > Insert Page Break.
Switch to View > Page Break Preview to see how the break divides the printout.
If the split is not where you want it, move it in Page Break Preview or remove it and insert another.

For a horizontal break, select the row that should begin the next page. For example, to start a new printed page at row 21, select row 21 or a cell in that row before inserting the break. For a vertical break, select the column that should begin the next page. Selecting a cell rather than a whole row or column can insert both a horizontal break above that cell and a vertical break to its left. Choose the selection carefully if you only want one direction.

Choose where the split goes

Horizontal breaks divide the worksheet into bands of rows; vertical breaks divide it into side-by-side groups of columns. They are useful when a table should start a fresh page at a meaningful point, or when a printed report needs to keep related columns together. A break is a boundary, not a blank line: Excel does not add a row or column to the worksheet when you insert one.

For instance, imagine a monthly report with a heading and a list of transactions. If the next month’s heading would otherwise appear at the bottom of a page, insert a horizontal break above the row containing that heading. The following month will begin on a new page. If a wide table has identifying columns on the left and notes on the right, a vertical break can divide those columns across pages, though it may be clearer to adjust the page orientation or scaling instead.

Keep in mind that a page break can create a nearly empty page if it is placed too early or if other print settings constrain the available space. It also cannot make a large table fit legibly on one sheet by itself. Check the whole print preview after adding breaks, rather than judging the result from the worksheet grid alone.

Use Page Break Preview

Page Break Preview is the most direct way to inspect and refine pagination. Choose View > Page Break Preview. Excel displays page regions and boundaries; worksheet areas outside the print region may appear shaded. You can drag a break boundary to a different row or column, subject to the worksheet’s print settings. When finished, return to View > Normal to resume the usual worksheet view.

In Page Break Preview, automatic breaks and manual breaks are shown differently: automatic boundaries are typically dashed, while manual boundaries are solid. The exact appearance can vary with the display and Excel version, so use the page numbers and the printed preview as well as the line style. A manual boundary is the one you deliberately added or repositioned; automatic boundaries are Excel’s pagination based on paper size, margins, scaling, and content.

Page Break Preview is a layout aid, not a separate copy of the data. Editing a cell in this view still edits the worksheet. If the page divisions make the grid difficult to read, switch back to Normal view; the breaks remain part of the worksheet’s print setup.

Automatic and manual page breaks

Excel automatically divides a worksheet into pages when it is printed. It calculates where content will fit using the selected paper size, page orientation, margins, scaling, and print area. Those automatic divisions may change when you modify any of those settings, change column widths, or add or remove content.

A manual page break adds a deliberate boundary to that automatic layout. It is helpful when the natural split interrupts a section, separates a heading from its rows, or divides a small report into sections. Manual breaks do not guarantee an identical page layout on every printer: paper sizes, printer margins, and other print settings can affect the available area. Preview on the intended setup before distributing a final printout or PDF.

Automatic breaks are not errors, and manually adding more breaks is not always the best fix for an awkward page. If a page has only a few rows, first consider whether the print area is too large, the margins are too wide, or the chosen orientation is unsuitable. A good layout balances page boundaries with readable text.

Move, remove, or reset breaks

To reposition a break visually, open View > Page Break Preview and drag the boundary to the desired row or column. This is often easier than deleting and inserting a break when you are fine-tuning several pages. If a boundary will not move as expected, check the scaling settings described below; a fit-to-page setting can limit the effect of manual breaks.

To remove a particular 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. If you select a cell at the intersection of the relevant breaks, Excel can remove the breaks associated with that location. For a clean slate, choose Page Layout > Breaks > Reset All Page Breaks. Resetting removes the manual break layout and lets Excel paginate automatically again; it does not delete worksheet data.

Take care with Reset All Page Breaks if you have spent time arranging a report. It removes all manual breaks in the active worksheet, not just the one currently selected. If you only need to correct one boundary, use Remove Page Break instead.

Check scaling, orientation, and print area

Page breaks work together with other print settings. In Page Layout, the Scale to Fit controls let you set a page width and height; the Orientation and Margins controls also affect how much content fits. When Excel is set to fit a sheet to a specified number of pages, it may scale the sheet to meet that target, so manual breaks may not behave as expected. For more control over deliberate breaks, set Width and Height to Automatic in Scale to Fit, then inspect the pages in Page Break Preview.

Scaling can solve one problem while creating another. Fitting a wide worksheet to one page across may prevent columns from spilling onto extra pages, but it can shrink text substantially. If the printout becomes hard to read, try Landscape orientation, narrower margins, a smaller print area, or a deliberate division across pages instead of forcing the entire sheet onto one page.

A print area limits which cells Excel prints. To define one, select the cells and choose Page Layout > Print Area > Set Print Area. This can prevent notes or unrelated calculations far from the main table from creating extra pages. If a page break appears to have no useful effect, verify that the intended cells are inside the print area and that the print preview includes the section you expect.

Examples of useful page-break decisions

Keep a section heading with its details: If a new section heading is stranded at the bottom of a printed page, place a horizontal break above the heading’s row.
Start each department on a new page: If departments occupy separate row ranges, insert breaks before the first row of each department, then inspect whether any department spans multiple pages.
Print a wide table: Before placing a vertical break, try Landscape orientation and check whether a readable scale is possible. If the columns must span pages, choose a split that keeps related columns together.
Remove unwanted blank pages: Check for an oversized print area, distant formatting, or a manual break that creates an extra page. Adjust the print area or remove the unnecessary break, then preview again.

For long lists that continue across pages, a break is not a substitute for repeating column headings. Excel’s Page Layout > Print Titles command lets you specify rows to repeat at the top or columns to repeat at the left of printed pages. Repeated titles make later pages understandable even when the table itself spans several pages.

Common problems and fixes

The break seems to do nothing. Confirm that you are looking at Page Break Preview or Print Preview, not expecting a visible blank line in the normal grid. Then check whether the sheet is being scaled to fit a set number of pages. Set the Scale to Fit width and height to Automatic if you need the manual boundaries to govern pagination.

The printout still has too many pages. A page break only controls where a page ends; it does not reduce the amount of content. Review orientation, margins, scaling, and the print area. If there is content outside the intended report, define a smaller print area instead of squeezing everything onto fewer pages.

A blank page appears. An unnecessary manual break, a print area extending farther than the visible report, or content in distant rows or columns can produce an extra page. Use Page Break Preview to locate the page boundary, check the selected print area, and remove or reset breaks as appropriate. Also review Print Preview before sending the job to a printer.

The layout changes after editing. Excel recalculates automatic pagination when content, column widths, paper settings, or scaling changes. A manual break may remain, but the surrounding page boundaries can shift. Recheck Page Break Preview after changing the worksheet or its print setup.

Excel for Mac and Excel for the web

In Excel for Mac, the ribbon labels and controls can vary slightly by release, but the desktop workflow is generally to select the row, column, or cell and use the Page Layout tab’s Breaks controls. Use the workbook’s page-break or print preview view to inspect the layout. Keyboard shortcuts and some screen layouts differ between Windows and Mac, so the ribbon commands are the clearest route when instructions need to work across platforms.

Excel for the web has more limited page-layout controls than the desktop application. If you need to insert, move, or carefully manage manual page breaks, open the workbook in the Excel desktop app and use Page Layout > Breaks. You can still use the web app for ordinary worksheet editing, but confirm that the needed print controls are available before relying on it for final pagination.

Frequently Asked Questions

How do I insert a horizontal page break in Excel?
Select the row that should start the next printed page, then choose Page Layout > Breaks > Insert Page Break. Check the boundary in View > Page Break Preview.

How do I insert a vertical page break?
Select the column that should begin the next printed page, then choose Page Layout > Breaks > Insert Page Break. Review the resulting column split in Page Break Preview.

Can I insert a page break in Excel without changing the data?
Yes. A page break changes worksheet pagination for printing; it does not insert, remove, or move cell data.

Why does Excel ignore my manual page break?
Check whether the sheet is set to fit a specified number of pages in Scale to Fit. Set Width and Height to Automatic, then review the print layout again. Printer and paper settings can also affect pagination.

How do I remove all page breaks?
On the active worksheet, choose Page Layout > Breaks > Reset All Page Breaks. This clears manual breaks so Excel can paginate the sheet automatically; it leaves the worksheet contents intact.

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.