Add a Page Break in Excel: Steps, Layout, and Print Tips

To add a page break in Excel for Microsoft 365 on Windows, select the cell where the next printed page should begin, then choose Page Layout > Breaks > Insert Page Break. Excel places a horizontal break above the selected cell and a vertical break to its left; use Page Break Preview to check the result before printing.

What a page break does

A page break tells Excel where to divide a worksheet into separate printed pages. It changes the print layout, not the worksheet data: it does not insert a blank row or column, move cells, or change what appears on screen in Normal view. Page breaks are useful when a report should start a new page at a particular row, when a wide worksheet needs a deliberate column split, or when a section should not be divided across pages.

Excel already inserts automatic page breaks based on the worksheet’s size and print settings. A manual break gives you some control over those divisions, but it does not guarantee that every page will have a particular number of rows or columns. Paper size, margins, orientation, scaling, and the printer’s printable area all affect the final pagination.

Insert a horizontal or vertical break

The selected cell determines where Excel puts manual breaks. To start a new printed page above a particular row, select a cell in that row. To start a new page to the left of a particular column, select a cell in that column. If you select an ordinary cell, Excel can add both a horizontal break above it and a vertical break to its left.

Open the worksheet you intend to print and select the cell where the next page should begin.
Choose Page Layout > Breaks > Insert Page Break.
Choose View > Page Break Preview to inspect the page divisions.
If the break is not in the right place, drag it in Page Break Preview or remove it and insert it again.

For example, suppose a monthly report has a title and summary in rows 1 through 8, followed by detailed transactions. To make the transactions begin on a new printed page, select a cell in row 9 and insert a break. The break runs across the worksheet above that row. If the report has columns A through H and you want columns E through H to print on a separate page, select a cell in column E and insert a break; the vertical division is placed to the left of E.

To add only a horizontal break, select the row heading for the row where the next page should start, then use the Insert Page Break command. To add only a vertical break, select the column heading where the next page should start. Selecting a whole row or column helps make the intended direction clear and avoids accidentally adding both types of break.

Preview and move page breaks

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 dashed blue lines generally indicate automatic breaks. The preview is a practical way to see whether a table is split, whether a page is mostly empty, and whether a break has created more pages than expected.

You can reposition a break by dragging its blue line to a new row or column boundary. Moving a horizontal line changes which rows print on each page; moving a vertical line changes which columns appear together. Excel may adjust the other page divisions as a consequence, especially if the worksheet is scaled to fit a set number of pages. After moving a break, check the numbered pages again rather than assuming only one page has changed.

Page Break Preview is a layout view, not a separate copy of the worksheet. To return to the usual grid, choose View > Normal. You can also use View > Page Layout to see a page-oriented view, but Page Break Preview is usually the more direct choice for placing and reviewing breaks.

Remove or reset breaks

If a manual break is in the wrong place, 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 break outside the print area to remove it. Check the result in the preview because the removed manual break may be replaced by an automatic one elsewhere.

To clear all manual page breaks on the active worksheet, choose Page Layout > Breaks > Reset All Page Breaks. This removes the manual divisions and lets Excel repaginate the sheet using its automatic rules. It does not clear cell contents or reset other worksheet formatting. If you have carefully positioned several breaks, use Remove Page Break on the specific one instead of resetting them all.

How automatic breaks and scaling interact

Excel calculates automatic breaks from the printable dimensions of the sheet. For instance, a worksheet may fit 40 rows on one page with a particular paper size and margin setting, but only 32 rows after the margins are widened. Changing from portrait to landscape can also change how many columns fit across a page. A break that looked sensible before changing those settings may no longer produce the intended layout.

Scaling is especially important. On the Page Layout tab, the Scale to Fit controls can shrink a worksheet to fit a specified number of pages wide or tall. When the Fit to scaling option is used, Excel ignores manual page breaks. If you need breaks at fixed row or column boundaries, avoid forcing the whole sheet to fit a page count; instead, set scaling to a percentage or leave it at 100%, then adjust paper size, orientation, margins, or the breaks themselves. Scaling a large sheet to one page can make the print too small to read, even if it technically fits.

Before inserting many breaks, decide whether the priority is a specific page count or a specific split point. For a compact overview, fitting to a page width may be useful. For a form, schedule, or report whose sections must begin on chosen pages, manual breaks with appropriate scaling are usually more predictable.

Print area, titles, and page setup

A page break controls divisions within the printable worksheet, but it does not decide which cells are included. To print only a specific range, select it and choose Page Layout > Print Area > Set Print Area. You can inspect the output with File > Print, where Excel shows a print preview. A defined print area can make a break outside that area irrelevant to the pages being printed.

If a long table spans several pages, you may want its heading row repeated at the top of each page. Choose Page Layout > Print Titles, then enter the row or rows in Rows to repeat at top. This setting is different from inserting a page break: a break determines where a page starts, while print titles repeat selected headings on each printed page. Repeating the header often makes a multi-page report easier to read without adding manual breaks between every section.

Use Page Layout settings to check orientation, paper size, and margins before fine-tuning breaks. For example, changing a wide sales table from portrait to landscape may keep related columns together and reduce the number of horizontal page divisions. The best layout depends on the document’s purpose, the printer or PDF page size, and whether readers need to read it on paper or on screen.

Common page-break problems

The break seems to do nothing: Confirm that you are in the intended worksheet and inspect it in Page Break Preview. If Fit to scaling is active, Excel may be ignoring manual breaks. Check the Scale to Fit settings on Page Layout.
The printed pages do not match the preview you expected: Recheck paper size, orientation, margins, print area, and scaling in Page Layout and File > Print. A printer’s printable area can also affect where content fits.
A break appears in an unexpected direction: Selecting a single cell can add both a horizontal and a vertical break. Select a whole row or column when you want to add only one type.
A page contains only a few rows or columns: Review nearby manual breaks and remove unnecessary ones. Also check for narrow margins, a different paper size, or scaling settings that cause the worksheet to be divided unexpectedly.
Dashed lines remain after a break is removed: Those may be automatic breaks, not leftover manual breaks. Excel still needs to divide the printout into pages. Resetting manual breaks does not remove automatic pagination.

For a final check, use File > Print and review every page in the preview. This can reveal a clipped column, a nearly blank page, or a heading separated from its table. If the output is intended as a PDF, the print preview is still useful because it reflects the page layout Excel will use for printing or saving to PDF.

Excel for Mac and Excel for the web

In current desktop versions of Excel for Mac, page breaks can also be managed from the Page Layout tab using the Breaks controls, and Page Break Preview is available from the view controls. Ribbon wording or placement can vary slightly by release. If the Breaks command is not visible, check the Page Layout tab and switch to Page Break Preview to inspect the sheet.

Excel for the web has fewer page-layout controls than the desktop application, and manual page-break editing may not be available in the same way. If you cannot find the Breaks commands, open the workbook in the Excel desktop app to insert, move, or reset manual breaks. The web version can still be useful for editing worksheet data, but confirm print layout in the desktop app when precise pagination matters.

Frequently Asked Questions

How do I insert a page break in Excel?
Select the cell where the next printed page should begin, then choose Page Layout > Breaks > Insert Page Break. Check the result in View > Page Break Preview.

How do I insert only a horizontal page break?
Select the row heading for the row that should begin the next printed page, then choose Page Layout > Breaks > Insert Page Break. Selecting the whole row targets a horizontal division.

How do I remove a page break in Excel?
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. Use Reset All Page Breaks to remove every manual break on the active sheet.

Why is Excel ignoring my manual page break?
A common cause is Fit to scaling, which ignores manual page breaks. Check Page Layout > Scale to Fit and choose a scaling approach that allows your intended divisions, then review the sheet in Page Break Preview.

Does adding a page break change the worksheet data?
No. It changes where Excel divides the worksheet for printing; it does not insert rows, columns, or blank cells. The worksheet’s data remains in place.

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.