Excel Page Break Shortcut: Insert, Remove, and Reset

In Excel for Microsoft 365 on Windows, press Alt+P, B, I to insert a page break: press the keys in sequence, not all at once. First select the cell where the new page should begin; Excel places a horizontal break above its row and a vertical break to its left when applicable.

The Windows shortcut and what it does

The shortcut uses Excel ribbon KeyTips. Press and release Alt to show the KeyTips, press P for the Page Layout tab, press B for Breaks, then press I for Insert Page Break. This opens the same command as the ribbon path Page Layout > Breaks > Insert Page Break. If the letters displayed on your ribbon differ, follow the on-screen KeyTips; they can vary with interface language or customization.

Excel does not have a single Ctrl-based shortcut dedicated to inserting a page break. In particular, Ctrl+Enter is not the page-break command: it enters the current value or formula into all cells in a selected range. The Alt sequence is useful because it invokes the actual print-layout command without requiring a mouse, but you can always use the ribbon if you prefer.

Before inserting a break, think about where the printed page should start. For example, if row 26 should be the first row on page two, select a cell in row 26 and insert the break. If column D should begin on a new page when printing across several pages, select a cell in column D. Selecting a cell at the intersection can set both a horizontal and a vertical break.

How Excel places a manual page break

A manual page break divides a worksheet’s printed output; it does not insert a blank worksheet row or column, move cell contents, or change the on-screen grid. A horizontal break is placed above the selected cell’s row, so the selected row starts on the next printed page. A vertical break is placed to the left of its column, so that column starts on a page to the right.

That distinction matters when selecting a cell. To make a particular row start a new printed page, select a cell in that row, not the row above it. To split a wide report before column F, select a cell in column F. Excel’s print preview can show whether the resulting division is useful before you print or save the sheet as a PDF.

Manual breaks work alongside Excel’s automatic page breaks. Excel estimates where to divide pages based on paper size, margins, orientation, scaling, and the amount of printable content. A manual break gives you a way to request a specific division, such as keeping each department’s summary on a new page. The final layout can still change if you later alter those print settings.

Insert a break and check it in Page Break Preview

Select the cell at the row and/or column where the next printed page should begin.
Press Alt+P, B, I, or choose Page Layout > Breaks > Insert Page Break.
Choose View > Page Break Preview to inspect the page divisions. In this view, manual breaks appear as solid lines and automatic breaks as dashed lines.
Drag a break line if you need to adjust its position, then check the worksheet in print preview before printing.

Page Break Preview is especially helpful for a worksheet that spans several pages. It displays page boundaries and page numbers over the sheet, letting you see whether a table is split awkwardly or a small group of columns has been pushed onto a separate page. Return to View > Normal when you want the standard worksheet view again.

For a quick check of the actual output, use File > Print. The preview reflects the current print settings, including the selected printer or paper size, orientation, margins, and scaling. A break that looks well placed in the worksheet may not produce the intended result if the print area or scaling option changes the page dimensions.

Remove one break or reset all breaks

To remove a manual break, select the cell directly below a horizontal break or directly to the right of a vertical break, then use Alt+P, B, R or choose Page Layout > Breaks > Remove Page Break. Excel removes the relevant manual division at that location. If the cell is at an intersection, inspect both directions in Page Break Preview so you remove the intended break.

To clear manual page breaks from the worksheet, choose Page Layout > Breaks > Reset All Page Breaks. The corresponding Windows KeyTip sequence is commonly Alt+P, B, A; if the displayed KeyTips differ, use the letters shown on screen. Resetting removes the manual breaks and lets Excel calculate page divisions again. It does not clear cell contents or delete rows and columns.

Removing a manual break does not guarantee that the printed pages will join into one page. Excel may put an automatic break in the same general area based on the current print settings. If a division remains, look for a dashed automatic-break line, review scaling and paper size, and check the print preview rather than repeatedly trying to remove a break that is no longer manual.

Manual breaks versus automatic page breaks

Automatic breaks are Excel’s calculated page boundaries. They respond to the printable area and the worksheet’s layout, so changing portrait to landscape, widening a margin, changing paper size, or scaling the sheet can move them. They are useful when a worksheet can flow naturally across pages and you do not need to control every boundary.

Manual breaks are deliberate boundaries that you insert, remove, or reposition. They are useful for reports with meaningful sections: for example, starting each region’s detail on a fresh page, separating a cover summary from its supporting rows, or preventing a short total section from appearing at the bottom of a page. They are less helpful if the data changes often, because added rows or altered print settings can make a carefully placed break produce an untidy result.

Use automatic breaks for flexible sheets whose content changes frequently.
Use manual breaks when a particular section must start on a new page.
Use print preview to confirm the result; a visible boundary alone does not show every printer or scaling effect.

Fit page breaks to print settings

Page breaks are only one part of worksheet printing. Before adding many manual divisions, check Page Layout > Orientation and Page Layout > Size. A wide table may fit more naturally in landscape orientation or on a larger paper size, while a narrow report may be clearer in portrait. Adjusting margins can also provide room for columns without splitting them across pages.

Excel’s Scale to Fit controls can shrink a sheet to fit a chosen number of pages. On the Page Layout tab, review the Width and Height settings in Scale to Fit. Setting a sheet to one page wide can keep columns together, though it may reduce text to an uncomfortable size. Forcing both width and height to one page can make a long worksheet extremely small. Check readability in File > Print, not just whether the page count has decreased.

Also check whether a print area is limiting what appears. Select the intended cells and choose Page Layout > Print Area > Set Print Area if you want only that range printed. A page break outside the print area may not affect the output you are viewing. If the result is confusing, clear or redefine the print area, verify the selected print option in File > Print, and then reassess the page divisions.

Excel on Mac and Excel for the web

The Alt-based KeyTip sequence in this guide is for Excel on Windows. On a Mac, use the ribbon command Page Layout > Breaks > Insert Page Break when that command is available in your Excel version. Mac keyboard navigation and ribbon shortcuts differ from Windows, so do not assume that Alt+P, B, I or a Windows Ctrl shortcut will work there. The menu command is the dependable way to identify the same operation.

Excel for the web has a more limited set of print-layout controls than the desktop application, and its interface may not provide the same Page Break Preview or manual-break commands. If you need to insert, move, or carefully inspect manual page breaks, open the workbook in the desktop version of Excel. You can then save the workbook and use the web version for ordinary editing, while checking the final print layout in the desktop app.

Common page-break problems

The shortcut seems to type letters or do nothing: press and release Alt first, then follow the KeyTips shown on the ribbon. Do not hold the whole sequence as if it were one chord.
The break is in the wrong place: remember that a horizontal break goes above the selected row and a vertical break goes left of the selected column. Select a cell in the row or column that should begin the next page.
The page still splits after removing a break: the visible division may be automatic. Check whether it is dashed in Page Break Preview and review paper size, margins, print area, and scaling.
The text becomes too small: avoid fitting both dimensions onto one page for a long sheet. Try fitting the width only, changing orientation, or allowing additional pages.
The printed layout changes later: a different printer, paper size, margin, or scaling setting can alter automatic boundaries and the space available for manual breaks. Recheck File > Print after making layout changes.

Frequently Asked Questions

What is the shortcut key to insert a page break in Excel?

In Excel for Microsoft 365 on Windows, press Alt+P, B, I in sequence. Select the cell where the next printed page should begin first. You can also choose Page Layout > Breaks > Insert Page Break.

Does Ctrl+Enter insert a page break in Excel?

No. Ctrl+Enter enters the current value or formula into every cell in a selected range. Use the Page Layout Breaks command or its Windows KeyTip sequence to insert a print page break.

How do I remove a page break in Excel?

Select the cell below a horizontal break or to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. To remove all manual breaks in the worksheet, choose Reset All Page Breaks from the same menu.

Why can I still see a page break after removing it?

Excel may have placed an automatic break at that location. In Page Break Preview, manual breaks are solid and automatic breaks are dashed. Automatic breaks are recalculated from print settings and cannot be removed as though they were manual breaks.

Can I insert a page break in Excel for Mac?

Use the Page Layout tab’s Breaks menu and choose Insert Page Break when available. Windows KeyTips are not the Mac shortcut; the exact keyboard navigation differs, so the ribbon command is the clearest route.

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.