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

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

Yes. In Excel for Microsoft 365 on Windows, select the row below or the column to the right of where you want the break, then choose Page Layout > Breaks > Insert Page Break. A page break controls where worksheet content continues on the next printed page; it does not add a new worksheet or change the cells themselves.

What a page break does in Excel

A worksheet can be much larger than a printed page. When you print it, Excel divides the sheet into pages according to the paper size, orientation, margins, scaling, and the amount of content. These divisions are page breaks. Excel creates automatic breaks when it lays out the printout, and you can add manual breaks to choose where a page should end.

For example, suppose a report has a heading in row 1, column labels in row 2, and transaction records in rows 3 through 62. If Excel splits the records in the middle of a group, a manual horizontal break can make the next group begin on a new page. A vertical break can separate columns when a wide table would otherwise be divided in an awkward place.

Page breaks affect printing and print preview, not the way data is entered or calculated. They do not insert blank rows, remove information, or change the worksheet’s cell values. A break is a layout instruction, so the resulting page boundaries can change if you later alter the paper size, margins, print area, or scaling.

Insert a horizontal or vertical page break

In desktop Excel for Windows, the selection determines where Excel puts a manual break. To create a horizontal break, select the row immediately below the point where the new page should begin. To create a vertical break, select the column immediately to the right of the point where the next page should begin.

Open the worksheet and select the appropriate row or column. For a break above row 20, select row 20. For a break before column G, select column G.
Choose Page Layout > Breaks > Insert Page Break.
Check the result in View > Page Break Preview or use print preview before printing.

You can also select a cell at the intersection of the desired boundaries. Excel inserts a horizontal break above that cell’s row and a vertical break to its left. For example, selecting G20 and inserting a break can divide the sheet above row 20 and before column G. If you want only one direction, select the relevant row or column instead of a cell, then verify the result in Page Break Preview.

There is no need to select the last row of the page you want to finish. Excel places the break before the selected row or column. That distinction matters: selecting row 20 means row 20 starts after the horizontal break, rather than ending the page above row 19 by inserting a break after the selection.

Use Page Break Preview to inspect and adjust pages

Page Break Preview gives a visual map of how the worksheet will be divided for printing. In Windows, choose View > Page Break Preview. The worksheet is divided into page areas, often marked with page numbers. Manual breaks appear as solid lines, while automatic breaks appear as dashed lines. The exact appearance can vary with the workbook’s current print settings.

In this view, you can drag a page boundary to change where a page ends. Dragging an automatic boundary makes the layout manual at that location, so Excel will not freely reposition that break in response to every small change in content. This can be useful when a report has a carefully arranged structure, but it also means you may need to revisit the break after changing the sheet or print setup.

Page Break Preview is particularly helpful for wide sheets. It can show that a table is being split between columns, or that one page contains only a narrow strip of the report. If you see an unexpected split, first decide whether the break itself is wrong or whether the print settings are forcing the worksheet to shrink or spread across pages.

To return to the standard worksheet view, choose View > Normal. Page boundaries may still appear as lines in Normal view after you have worked with print settings. Those indicators are not cell borders and do not print as marks on the page.

Automatic breaks, manual breaks, and print settings

Excel places automatic breaks based on the current page layout. A manual break is one you insert or reposition. The two interact: a manual break can influence where Excel divides the sheet, while the remaining pages still depend on the available printable area and the workbook’s settings.

Before adding many manual breaks, check the options that determine the printed page size and shape:

Paper size: A worksheet laid out for Letter paper may paginate differently on A4 paper.
Orientation: Landscape provides more horizontal room; Portrait provides more vertical room.
Margins: Larger margins leave less printable space for rows and columns.
Scaling: Fit-to-page settings can shrink or stretch the output to fit a specified number of pages.
Print area: A defined print area limits which cells Excel includes in the printout.

These settings are available from the Page Layout ribbon and related print settings. If a sheet is set to fit one page wide, for instance, Excel may scale several columns onto the same page instead of splitting them at the vertical boundary you expected. A manual break cannot guarantee readable text if the scaling makes the entire table too small. Adjust the layout, or choose a more suitable number of pages wide, before relying on breaks to solve the problem.

Remove or reset page breaks

To remove one 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. If you are working with a break at the intersection of a row and column, select a cell positioned just below and to the right of it and use the command, checking the preview to confirm the intended boundary was removed.

If the sheet has accumulated several manual breaks and you want Excel to lay out the pages again, choose Page Layout > Breaks > Reset All Page Breaks. This removes the worksheet’s manual page-break adjustments and restores automatic pagination. It does not erase worksheet data or undo other print settings such as orientation, margins, or a print area.

Removing a manual break does not always make the visible line disappear. Excel can immediately place a new automatic break at or near the same position because the page still has limited space. Check whether the line is dashed or solid in Page Break Preview and consider the paper size, margins, scaling, and content before assuming the removal failed.

Common page-break problems and fixes

The break appears in the wrong place. Remember that a selected row starts after a horizontal break, and a selected column starts after a vertical break. Recheck the selected row or column, then inspect the boundary in Page Break Preview.
A break moves after a layout change. Changing paper size, orientation, margins, scaling, or the print area can change pagination. Set those options first, then insert or adjust manual breaks.
The printed text is too small. This is often a scaling issue rather than a break issue. Check whether the worksheet is being forced onto one page, and consider allowing more pages or using landscape orientation.
A table is split across pages. Add a horizontal break before the next section, or adjust the print layout so the relevant rows stay together. A break controls the page boundary; it does not repeat column headings automatically.
The lines are visible in the sheet but not on paper. Page-break indicators show pagination; they are not printable borders. Use print preview to inspect the actual output.
The Breaks command is unavailable or behaves differently. Confirm that you are working in the desktop application and not a limited browser view, and check whether the worksheet is protected. Some editing commands may be restricted while protection is on.

If column headings need to appear on every printed page, that is a separate print-layout setting, not a page break. Excel’s Page Layout > Print Titles command lets you specify rows or columns to repeat when printing, where the feature is available. Repeating headings can make a multi-page report easier to read without adding a break after every page.

Excel for Mac and Excel for the web

Excel for Mac also supports manual page breaks in the desktop app. The ribbon layout and wording can differ slightly by release, but look for the page-break controls on the Page Layout tab and use the page-break view to inspect the print layout. The Windows ribbon path and keyboard navigation should not be assumed to match every Mac version; there is no need to use a shortcut when the ribbon command is available.

Excel for the web can handle many workbook and print tasks, but its page-layout controls do not always match the full desktop experience. If you cannot find a control for inserting or dragging manual breaks, open the workbook in the desktop version of Excel to set them. This is especially useful when precise page-by-page control matters. After editing in desktop Excel, save the workbook so the layout changes are retained.

In either desktop version, preview the output after making changes. A break that looks sensible in the worksheet may produce an extra mostly blank page if the print area extends beyond the data, or if a page setting forces content onto additional sheets of paper.

When to use a page break instead of another option

Use a manual page break when you want a particular row or column to begin on a new printed page—for example, to start each department’s section on a fresh page. Use a print area when you want to limit the printout to a defined range, such as a summary table while leaving notes elsewhere on the worksheet. Use Print Titles when headings should repeat across pages.

These tools solve different problems. A print area does not itself decide that every section begins on a new page, and a page break does not exclude cells outside the intended report. If you need a tidy handout, combine the relevant settings: define the print area, choose paper and orientation, set repeating headings if needed, and then add only the manual breaks that improve the page sequence.

Frequently Asked Questions

Can I insert a page break in Excel?
Yes. In desktop Excel, select the row below or column to the right of the intended boundary and choose Page Layout > Breaks > Insert Page Break.

How do I insert a page break after a specific row?
Select the row immediately after the last row you want on the current page. For example, to end a page after row 19, select row 20 and insert a break.

Can I add both a horizontal and vertical page break?
Yes. Select a cell at the intersection where the boundaries should occur and insert a break. Excel can place a horizontal break above its row and a vertical break to its left; check Page Break Preview to confirm the layout.

Why can’t I remove a page break?
The line may be an automatic break, which Excel recalculates from the page setup, or the worksheet may be protected. Use Page Break Preview to identify the boundary and check protection and print settings.

Will page breaks show when I print the worksheet?
The break lines themselves do not print. They determine where one printed page ends and the next begins. Use print preview to see the resulting pages.

How do I remove all manual page breaks?
Choose Page Layout > Breaks > Reset All Page Breaks. Excel then calculates automatic breaks using the current print 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.