Excel Force Page Breaks: How to Insert and Control Them

To force a page break in Excel for Microsoft 365 on Windows, select the row below where a horizontal break should go, or the column to the right of a vertical break, then choose Page Layout > Breaks > Insert Page Break. Excel will start a new printed page at that point; use Page Break Preview to check the result before printing.

What a forced page break does

A page break tells Excel where to split a worksheet when it is printed or saved as a PDF. A horizontal break separates rows, while a vertical break separates columns. For example, if a monthly report has a summary in rows 1 through 18 and detailed transactions below, a horizontal break can start the transaction list on a fresh sheet of paper.

Excel also creates automatic page breaks according to the paper size, margins, orientation, print area, and scaling settings. Those breaks are not necessarily where a reader would choose to divide a report. A manual, or forced, break lets you set a preferred boundary. It does not add a blank row or column, alter cell values, or change the worksheet itself; it affects the printed pagination.

A manual break is a placement preference, not a guarantee that every page will fit exactly as expected. If the worksheet is later resized, the printer or paper settings change, or Excel is told to fit the sheet to a particular number of pages, pagination can change. Always inspect the print preview after changing the layout.

Insert a horizontal or vertical break

The selected cell or range determines where Excel places the break. For the clearest result, select a whole row or column rather than an individual cell:

To start a new page before a particular row, click that row’s heading. For example, select row 25 to put the break above row 25.
To start a new page before a particular column, click that column’s heading. For example, select column G to put the break to the left of column G.
Open Page Layout > Breaks > Insert Page Break.
Choose View > Page Break Preview to confirm where Excel divided the sheet.

If you select a cell instead of a whole row or column, Excel can insert both a horizontal break above the cell’s row and a vertical break to the left of its column. That may be useful when the page should split in both directions, but it can create an unexpected extra division. Selecting a row heading or column heading makes it easier to request just one direction.

On Excel for Mac, use the Page Layout tab and its Breaks command to insert a break, then check it in Page Break Preview. Ribbon labels and window layouts can vary slightly by release. Excel for the web does not provide the same complete set of desktop page-break controls, so open the workbook in the desktop app when you need to insert and manage manual breaks precisely.

Place breaks in Page Break Preview

Page Break Preview shows the worksheet divided into numbered print pages. Choose View > Page Break Preview to open it. Solid blue lines indicate manual page breaks, while dotted lines generally indicate automatic breaks. The view is useful for seeing whether a table has been split across pages or whether a new section begins where intended.

You can also adjust break positions by dragging a blue line in Page Break Preview. Drag a horizontal line up or down to change the row boundary; drag a vertical line left or right to change the column boundary. This is convenient when the right break is close but not exactly where you want it. If the line is difficult to distinguish from the worksheet grid, zoom in or select the relevant row or column and insert the break from the ribbon instead.

Page Break Preview may show blank-looking areas because it emphasizes the printable pages rather than the normal worksheet grid. To return to the usual editing view, choose View > Normal. Switching views does not remove the breaks.

Manual breaks versus automatic breaks

Excel calculates automatic breaks to fit the printable portion of a sheet onto pages. A dotted boundary can move when you change the paper size, margins, orientation, print area, or scaling. These settings affect how many rows and columns fit on each page, so a break that was previously near the bottom of a page may shift after a layout change.

A manual break is a user-set division and is shown as a solid line in Page Break Preview. It is useful when a logical unit should remain together: for instance, keeping each department’s heading and first rows together, or beginning a new section on a fresh page. However, adding many manual breaks can make a workbook brittle. A later change to column widths or font size may leave a page with very little content or push a section onto an additional sheet.

Use manual breaks for meaningful boundaries, not as a substitute for every print-layout setting. If a report is only slightly too wide, landscape orientation or narrower margins may solve the problem more cleanly than adding vertical breaks. If it is much too large, consider printing selected sheets or adjusting the print area.

Make the printed layout easier to control

Before placing breaks, decide what should appear on each page and check the overall page setup. On the Page Layout tab, use Orientation to choose Portrait or Landscape, Size to choose the paper, and Margins to set whitespace. A landscape page can often accommodate a wide table without splitting its columns. These choices can change automatic pagination, so set them before fine-tuning manual breaks.

The Scale to Fit controls on the Page Layout tab let you set a page width and height for printing. For example, setting Width to 1 page can keep all columns together horizontally, while leaving Height set to Automatic allows the rows to flow across as many pages as necessary. Fitting a very large worksheet to one page both wide and tall can make the text too small to read. Check Print Preview rather than assuming that fewer pages means a better result.

To print only part of a worksheet, select the intended cells and choose Page Layout > Print Area > Set Print Area. A print area limits which cells are included; it is different from a page break, which divides the printable content. If repeated column headings are needed on later pages, use Page Layout > Print Titles and set rows or columns to repeat. Repeating a heading is often better than manually copying it into each section.

Open print preview with File > Print, or press Ctrl+P on Windows. On a Mac, use Command+P. Preview is where to verify page count, orientation, clipping, and whether text remains legible. The preview reflects the current print settings and can reveal that a break was placed correctly but the page still contains an awkward amount of whitespace.

Remove or reset page breaks

To remove one manual break, select the row immediately below a horizontal break or the column immediately to the right of a vertical break. Then choose Page Layout > Breaks > Remove Page Break. In Page Break Preview, you can also drag a manual blue line back to the worksheet edge, where the manual boundary is removed.

To clear all manual breaks on the active worksheet, choose Page Layout > Breaks > Reset All Page Breaks. This removes the manual divisions and lets Excel paginate the sheet automatically again; it does not erase cell contents or remove the print area. Reset All Page Breaks applies to the current sheet, so repeat it on other sheets only if you intend to reset them too.

If you cannot see a break in Normal view, switch to Page Break Preview. Excel can also display page breaks in Normal view after printing, but the display is less useful for positioning them. On Windows, if the worksheet still does not show boundaries in Normal view, check File > Options > Advanced > Display options for this worksheet and the Show page breaks setting. That display option changes visibility, not the actual pagination.

Common problems and practical fixes

A break appears in both directions. You probably selected a cell rather than a whole row or column. Remove the unwanted break, select the row or column heading, and insert it again.
The page break moves after changing settings. Paper size, orientation, margins, scaling, and the print area all influence pagination. Set those first, then position manual breaks and recheck preview.
The printout is unexpectedly tiny. Check Scale to Fit. Fitting a wide and tall sheet onto one page can shrink everything. Set only the dimension that needs controlling, or use a larger paper size or landscape orientation.
A table is cut off at the right edge. A horizontal break will not fix a width problem. Try landscape orientation, adjust margins or column widths, or set the page width to one page and inspect the resulting text size.
Nothing seems to change in preview. Confirm that the intended worksheet is active, check that the cells are inside the print area, and look for a scaling setting that is overriding the layout you expect. A manual break affects printed pagination, not the on-screen grid.
A saved PDF has different pagination. Review the active paper size and print settings, and inspect the PDF preview before sharing. Different output settings can change where automatic boundaries fall.

Choosing a page break or another layout option

Use a manual page break when the exact starting point of a page matters, such as placing a new chapter, department, or category at the top of a page. Use automatic pagination when the sheet is a routine table and small changes in page boundaries do not matter. Use a print area when only a defined portion of the worksheet should print, and use Print Titles when headers need to repeat across pages.

Scaling is better when the main goal is to fit a set number of columns or pages, but it can reduce text size. Orientation and margins are better first adjustments for a modest width mismatch. A useful sequence for a report is to choose the paper and orientation, set the print area and repeating headings, inspect the preview, and only then add manual breaks at meaningful section boundaries.

Frequently Asked Questions

How do I force a page break in Excel?
Select the row below the desired horizontal boundary or the column to the right of the desired vertical boundary, then choose Page Layout > Breaks > Insert Page Break. Review the result in View > Page Break Preview.

How do I insert only a horizontal page break?
Select the row heading below the intended break before using Insert Page Break. Selecting the entire row helps avoid inserting an unwanted vertical break as well.

Can I force Excel to start printing on a new page?
Yes. Insert a manual page break before the row or column where the new printed page should start. The break affects printed output and PDF pagination, not the worksheet’s cell layout.

Why is Insert Page Break unavailable or not behaving as expected?
Check that you are using the desktop Excel app and that the intended worksheet is active. The web app has fewer page-break controls. Also inspect the selection and scaling settings; selecting an individual cell can create breaks in both directions, and fit-to-page settings can change the layout.

How do I remove all page breaks in Excel?
On the active worksheet, choose Page Layout > Breaks > Reset All Page Breaks. This clears manual breaks so Excel can calculate automatic ones, but it does not delete worksheet data.

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.