Excel Page Break Keyboard Shortcut and How to Use It

In Excel for Microsoft 365 on Windows, press Alt, P, B, I in sequence to insert a manual page break. Select a row, column, or cell first to control where the break goes; this ribbon KeyTip sequence is not typed all at once.

The Windows shortcut, step by step

The shortcut uses Excel ribbon KeyTips: each key opens or selects a ribbon level, and the next key chooses a command. To insert a break:

Select the row below the position for a horizontal break, the column to the right of a vertical break, or a cell below and to the right of a point where both kinds of break should meet.
Press and release Alt, then press and release P, then B, then I.
Check the page layout in Page Break Preview or Print Preview to confirm that the break divides the sheet where you intended.

Do not hold all four keys down together. The letters are sequential KeyTips for the Page Layout tab, its Breaks menu, and Insert Page Break. In a non-English installation, or if ribbon KeyTips differ because of a customized interface, use the visible KeyTips or click the command directly. The menu route is Page Layout > Breaks > Insert Page Break.

What a page break does

A page break tells Excel where to divide worksheet content when it is printed or saved as a PDF. It does not split, move, or delete cells, and it does not add a new worksheet. It changes pagination: the content after the break starts on another printed page. This is useful when a table would otherwise be split at an awkward row, or when a new section should begin on a fresh sheet of paper.

Excel creates automatic page breaks as it fits the printable area to the selected paper size, orientation, margins, and scaling. A manual break is an instruction you add yourself. It can help make a report easier to read, but it cannot make an oversized table fit without affecting other print settings. For example, forcing a break after each department may produce clear sections, yet also create extra pages with substantial blank space.

Choose the right row, column, or cell

The selected object determines which edge Excel uses. To put a horizontal break before row 25, select row 25; the printed page above ends at row 24. To put a vertical break before column G, select column G; the page on the left ends at column F. These choices are often easiest when the sheet has clear headings or section boundaries.

Selecting a cell inserts breaks above and to the left of that cell. For example, selecting G25 and inserting a break creates a horizontal division above row 25 and a vertical division to the left of column G. This can divide a worksheet into four print regions, which may be helpful for a deliberately tiled layout but surprising if you intended only one break. If you need just one direction, select an entire row or column rather than an individual cell.

Start a new printed page before a section: select the first row of that section.
Print a wide worksheet as separate column groups: select the first column of the next group.
Split both down and across: select the cell at the top-left corner of the area that should begin after both breaks.

See breaks in Page Break Preview

Normal view is convenient for editing data, but Page Break Preview makes pagination easier to inspect. Choose View > Page Break Preview. Excel displays the printable pages and their boundaries. In this view, automatic breaks generally appear as dashed lines and manual breaks as solid lines. The exact appearance can vary with the Excel version and display settings, so check the Print Preview as well when the final printed result matters.

You can drag a boundary in Page Break Preview to adjust where a page ends. That changes the break position and may change how many rows or columns print on each page. Choose View > Normal when you want to return to the usual worksheet editing view. Page Break Preview is a layout aid; it does not change the underlying values or formulas in cells.

For a realistic final check, open File > Print. The preview shows the effect of the printer paper size, orientation, margins, scaling, print area, and page breaks together. If the preview differs from what you expected, inspect those settings before inserting more manual breaks. A break can be correctly placed and still produce an unexpected page if the printable area or scaling has changed.

Remove or reset manual breaks

If a break is misplaced, 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 created from a selected cell, selecting the relevant row or column and removing the break is generally the clearest approach. You can also use the Breaks menu while in Page Break Preview, where the boundary is visible.

To clear manual breaks throughout the worksheet, choose Page Layout > Breaks > Reset All Page Breaks. This removes the manual break instructions and lets Excel paginate automatically again; it does not remove the worksheet data. Use Reset All only when you want to discard the manual layout decisions on that sheet. It is different from removing one break, and it does not mean that the worksheet will have no page boundaries: Excel still adds automatic breaks for printing.

How print settings affect the result

Page breaks are only one part of printed layout. A defined print area can exclude cells outside the selected range. Orientation determines whether the page is taller or wider, while paper size and margins determine how much room remains for worksheet content. If a report has repeated column headings on each page, set those separately using Page Layout > Print Titles; a page break does not repeat a heading row by itself.

Scaling is especially important. If you choose a Fit to setting to force a worksheet to a specified number of pages wide or tall, Excel may adjust the output to meet that page count, and manual breaks may not control the result as expected. For precise manual pagination, review the scaling options in the Page Setup controls and use a percentage-based scale rather than a fit-to-pages setting where appropriate. The best choice depends on whether the priority is preserving readable text, controlling page boundaries, or limiting the total page count.

For example, suppose a monthly report has 60 rows, with a new department beginning at row 21. A horizontal break before row 21 can keep the next department together on a fresh page. But if the sheet is also set to fit all 60 rows onto one page tall, the scaling goal conflicts with that manual division. Check the preview after changing either setting rather than assuming the break alone determines the final pages.

Windows, Mac, and Excel for the web

The Alt, P, B, I sequence is for Excel desktop on Windows. On a Mac, use the Page Layout ribbon and choose Breaks > Insert Page Break; there is not a single universal Mac keystroke equivalent that should be assumed across keyboard layouts and Excel settings. The ribbon command gives the same selection-based result.

Excel for the web has fewer page-layout and printing controls than the desktop application, and the Windows ribbon KeyTip sequence is not a web shortcut. If you need to insert, reposition, or carefully manage manual page breaks, open the workbook in the desktop version of Excel and use Page Layout or Page Break Preview. When working in a browser, use the available print preview to check what the web version can print, but do not assume it exposes every desktop page-break control.

Common page-break problems

The break appears in the wrong direction: you may have selected a cell, which adds both a horizontal and a vertical break. Select a whole row or column when you want only one direction.
The break seems to disappear: return to Page Break Preview and check the print settings. Changes to paper size, margins, scaling, or the print area can alter the displayed pagination.
The printed page is still divided unexpectedly: Excel may have added automatic breaks elsewhere. A manual break controls a chosen boundary, but it does not remove every automatic division.
The shortcut does not work: make sure you are using desktop Excel for Windows and press the KeyTips one by one. If the interface language or ribbon customization changes the displayed letters, use the Page Layout menu path instead.
A title row does not repeat: configure Print Titles separately. Inserting a break controls where a page starts, not which rows repeat at the top.

Frequently Asked Questions

What is the keyboard shortcut to insert a page break in Excel?
In Excel for Microsoft 365 on Windows, press Alt, P, B, I in sequence. These are ribbon KeyTips, not a combination to hold down together. On Mac, use Page Layout > Breaks > Insert Page Break.

How do I insert a horizontal page break in Excel?
Select the row that should start the next printed page, then insert the break. For example, select row 25 to make the page above end before row 25.

How do I insert a vertical page break?
Select the column that should begin on the next printed page, then insert the break. Selecting column G places the boundary before column G. Check Page Break Preview to see how the worksheet will be divided.

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. To clear all manual breaks on the worksheet, choose Reset All Page Breaks instead.

Why does Excel show a page break I did not insert?
Excel creates automatic breaks to divide content for printing. These are normal and can shift when you change paper size, orientation, margins, scaling, or the print area. Page Break Preview helps distinguish automatic boundaries from manual ones.

Does inserting a page break create a new worksheet?
No. It only changes where printed output is divided into pages. The cells remain on the same worksheet, and the break does not change the data or repeat heading rows automatically.

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.