Excel Insert Page Break Shortcut: Windows and Mac

In Excel for Microsoft 365 on Windows, press Alt, P, B, I in sequence to insert a page break. First select a cell, row, or column: Excel places breaks above and to the left of a selected cell, or across the selected row or column.

The Windows shortcut, step by step

The keystrokes are ribbon access keys, not a combination you hold down all at once. Click the worksheet area you want to paginate, then press Alt, release it, press P, release it, press B, and then press I. The letters open the Page Layout tab, the Breaks menu, and Insert Page Break. If the sequence does not work, check that Excel has focus and that you are using the English-language ribbon; access-key letters can differ in other languages or customized ribbon layouts.

This is a useful shortcut when you are refining a printout and want to keep your hands on the keyboard. It does not immediately print anything. It adds a manual boundary that affects where Excel starts a new printed page. You can inspect the result in Page Break Preview before printing.

What an inserted page break does

Excel divides a worksheet into printed pages according to the paper size, orientation, margins, scaling, and available print area. It also creates automatic page breaks when the content no longer fits on a page. A manual break tells Excel where a page should end or begin, giving you more control over the split.

A page break is a printing instruction, not a new worksheet, a blank row, or a change to the cells themselves. Inserting one does not delete data or move cell contents. It changes how the sheet is divided when printed or exported to PDF. A break also does not guarantee that a particular row will appear at the top of a page if later changes to scaling or paper size alter the page layout.

Where Excel places the break

The selected location determines which boundary Excel uses. If you select a single cell within a worksheet, Excel inserts a horizontal break above that cell’s row and a vertical break to the left of its column. This can split the sheet in both directions, so one cell selection may create four printed regions around the selected position.

To start a new page above a row: select a cell in the row below the desired boundary, or select the entire row below it, then insert the break.
To start a new page to the left of a column: select a cell in the column to the right of the desired boundary, or select that entire column, then insert the break.
To make only a horizontal or vertical break: select an entire row or column, respectively, rather than a single cell.

For example, if a report has headers in row 1 and you want a new printed page to begin at row 26, select row 26 and insert the break. If you select cell C26 instead, Excel can add a horizontal break above row 26 and a vertical break to the left of column C. That extra vertical split may not be what you intended.

Use the ribbon if you prefer menus

The menu route performs the same action and is a good way to confirm the command name: go to Page Layout > Breaks > Insert Page Break. Select the target cell, row, or column before opening the menu. If Insert Page Break is unavailable, check that the worksheet is not protected in a way that prevents the change and that the selection is not at a boundary where Excel cannot create the requested split.

After inserting a break, switch to View > Page Break Preview to check how the worksheet is divided. You can also return to Normal view using View > Normal. The ribbon route is especially handy when you are learning what a command does or when a keyboard access key differs in your Excel language or setup.

Check the result in Page Break Preview

Page Break Preview shows the printable pages and their boundaries on the worksheet. In this view, Excel commonly displays manual breaks as solid blue lines and automatic breaks as dashed blue lines. The exact appearance can depend on the view and version, so use the page divisions and page numbers as well as the line style when interpreting the layout.

Excel may also show a large page number over each page. Those labels are visual guides, not content that will print over the cells. You can drag some page-break boundaries in Page Break Preview to reposition them, although the resulting layout remains subject to the print settings and scaling. If a break looks misplaced, check whether the sheet is set to fit a certain number of pages wide or tall; that setting can change how the printed pages are arranged.

A practical example for a long report

Suppose a worksheet contains a monthly report with a title and column headings in rows 1 through 4, followed by detail records. You want the next printed page to begin at row 40, rather than letting Excel split a record group wherever the automatic boundary falls. Select row 40, use Alt, P, B, I, and then inspect the worksheet in Page Break Preview. If the next page starts where expected, the manual horizontal break is in place.

Before printing, check whether the headings need to repeat on every page. A page break controls where pages divide; it does not repeat header rows by itself. For that, use Page Layout > Print Titles and set the rows to repeat at the top. Also verify that columns fit the page width. If the report is too wide, a vertical break can create extra pages across; landscape orientation or a suitable scaling choice may be more useful than adding more manual breaks.

How print settings affect breaks

Manual breaks work alongside Excel’s print setup. A worksheet can have a defined print area, margins, portrait or landscape orientation, and scaling options such as fitting the sheet to a specified number of pages. Any of these can influence the final pagination. For instance, changing from portrait to landscape may allow more columns on a page, while fitting all columns to one page can shrink the content and alter the apparent page divisions.

That is why page breaks are best checked after you settle the main print settings. A manual break is not a fixed physical measurement: it marks a boundary in the worksheet, but Excel must still fit the printable content to the selected paper and scaling rules. If a printed page is unexpectedly tiny or a break seems ignored, review Page Layout > Scale to Fit, paper size, print area, and orientation before repeatedly adding breaks.

Excel for Mac and Excel for the web

The Windows sequence Alt, P, B, I is not the Mac equivalent. On Excel for Mac, use the Page Layout ribbon and choose Breaks > Insert Page Break when those controls are available in your version. Ribbon labels and keyboard access differ on Mac, so the menu route is the dependable alternative when a Windows access-key sequence is not recognized.

Excel for the web has a more limited set of page-layout controls than the desktop application, and manual page-break editing may not be available in the same way. If you need precise control over manual breaks, open the workbook in the desktop version of Excel. You can still use the web version’s available print options to review or print a worksheet, but do not assume that a Windows ribbon sequence will work in a browser.

Remove or reset a page break

To remove one manual break, select a cell immediately below a horizontal break or immediately to its right for a vertical break, then choose Page Layout > Breaks > Remove Page Break. Selection matters here too: selecting a cell at an intersection can affect more than one boundary, so inspect the preview afterward.

If the sheet has accumulated several unwanted manual breaks, choose Page Layout > Breaks > Reset All Page Breaks. This removes the manual breaks and lets Excel paginate the sheet automatically again; it does not erase worksheet data. If a boundary remains after resetting, it may be an automatic break created by the current page setup rather than a manual one.

Common mistakes and misconceptions

Pressing Ctrl+Enter: this is not Excel’s insert-page-break command. It is used for entering the same value into multiple selected cells in certain workflows.
Using Ctrl+P: that opens printing options; it does not insert a break.
Selecting the row where the page should end: Excel inserts the horizontal break above the selected row, so select the first row that should begin the next page.
Assuming a break repeats headings: use Print Titles separately to repeat row or column labels on printed pages.
Expecting a break to control the whole printed layout: paper size, scaling, margins, and print area can change the final pagination.

Frequently Asked Questions

What is the shortcut to insert a page break in Excel?
In Excel for Microsoft 365 on Windows, press Alt, P, B, I in sequence. Select the cell, row, or column first so Excel knows where to place the break.

Does Ctrl+Enter insert a page break in Excel?
No. Ctrl+Enter is used for other cell-entry tasks, not for inserting a page break. Use the ribbon access-key sequence Alt, P, B, I on Windows or Page Layout > Breaks > Insert Page Break.

How do I insert a horizontal page break only?
Select the entire row that should start the next page, then insert the break. Selecting a whole row directs Excel to add a horizontal break without the vertical break that can result from selecting a single cell.

Why can’t I see the page break I inserted?
Open View > Page Break Preview to inspect the page divisions. Also check whether the break was placed above or to the left of the selected location, and review print settings that may affect the layout.

Can I insert a page break in Excel for Mac?
Use Page Layout > Breaks > Insert Page Break if the command is available in your Mac version. The Windows Alt-key sequence is not a universal Mac shortcut.

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.