Page Break in Excel Shortcut: Insert and Adjust Breaks

In Excel for Microsoft 365 on Windows, select the row, column, or cell where the printed page should divide, then press Alt, P, B, I in sequence to insert a page break. This is a series of key-tip presses, not one simultaneous shortcut. A manual break controls where printed pages begin; it does not split or rearrange the worksheet itself. Before you start, decide whether you need a horizontal break, a vertical break, or both, and check that the worksheet is not in cell-edit mode.

What You’ll Need

Excel for Microsoft 365 on Windows: The shortcut sequence below uses the Windows ribbon key tips. Excel 2021 and other recent desktop versions generally offer the same Page Layout command, though displayed key tips can vary by version or language.
A worksheet with content to print: You can add a break to a blank sheet, but it is easier to judge placement when the sheet contains the rows and columns you intend to print.
A print layout in mind: Identify the row that should start a new page, the column that should start a new page, or the cell at the corner where both should start. You do not need to select or configure a printer just to insert a break.

Step-by-Step

Choose the worksheet and check its print layout. Click the sheet tab you want to change. If the worksheet is wide or long, first open View > Page Break Preview to see how Excel currently divides it into printed pages. You can also open File > Print to inspect the preview, then return to the worksheet without printing. These checks help you choose a useful break location instead of adding one blindly.
Decide which kind of break you need. A horizontal break starts a new printed page below a particular row. A vertical break starts a new printed page to the right of a particular column. If you select a cell inside the sheet and insert a break, Excel inserts breaks above that cell’s row and to the left of its column. That can divide the sheet in both directions, so choose a row or column header instead if you want only one direction.
Select the location for a horizontal break. Click the row number immediately below where the next printed page should begin. For example, if rows 1 through 30 should be on the first page and row 31 should begin the next page, select the row 31 header. Selecting the whole row makes your intent clear and creates a horizontal break above it. Do not select the row that you want to keep at the bottom of the previous page.
Select the location for a vertical break, if needed. Click the column letter immediately to the right of the last column you want on the first page. If columns A through D should print together and column E should start on a new page, select the E header. Excel places a vertical break to the left of the selected column. To make a break in both directions at one intersection, select the cell at the start of the new page instead of selecting just a row or column.
Use the Windows shortcut sequence. With the intended row, column, or cell selected, press and release Alt, then press P, B, and I in order. In current English-language Excel for Windows, these key tips open the Page Layout tab, open the Breaks menu, and choose Insert Page Break. Do not hold all four keys down together. If your version displays different letters on screen, follow the visible key tips rather than guessing.
Use the ribbon if the key tips are different or inconvenient. Choose Page Layout > Breaks > Insert Page Break. This is the same command as the shortcut sequence. If Excel is editing text inside a cell, press Esc or Enter to leave edit mode, select the intended location again, and retry the command. The break applies to the active worksheet and its current selection.
Check the result in Page Break Preview. Choose View > Page Break Preview. A solid boundary generally indicates a manual page break, while dashed boundaries indicate automatic breaks created by Excel. Confirm that the new page starts at the intended row or column and that the printed pages remain a sensible size. Page boundaries shown here are print-layout guides, not borders added to cells.
Preview the printed pages and adjust if necessary. Press Ctrl+P on Windows or choose File > Print to inspect the print preview. If the break creates a page with only a few unwanted rows or columns, return to the sheet and move or remove it. You can drag a boundary in Page Break Preview or select a suitable row or column and insert a different break. Check the preview again after each meaningful change.
Remove a break you no longer want. Select the row below a horizontal break, the column to the right of a vertical break, or the relevant cell at their intersection, then choose Page Layout > Breaks > Remove Page Break. To discard all manual breaks on the current sheet, choose Page Layout > Breaks > Reset All Page Breaks. Resetting removes the manual layout choices; Excel will still calculate automatic page boundaries.

Common Mistakes

Treating the sequence as a single shortcut. Alt, P, B, I is a set of key-tip presses, not a chord such as Ctrl+C. Press each key after releasing the previous one. If a key-tip menu appears, continue with the next letter shown. If the letters on your screen differ, use the ribbon command directly.

Selecting the wrong row or column. Excel puts a horizontal break above the selected row and a vertical break to the left of the selected column. Selecting the last row you want on a page therefore places the break before that row, not after it. Select the first row or column that should begin the following page.

Expecting a break to change the worksheet view or add a line to the data. A page break affects printed pagination only. It does not insert a worksheet row, split a cell, add a border, or force content to display on a new screen page. Use cell formatting or worksheet structure for those tasks.

Inserting a break while a cell is being edited. If the cursor is inside a cell or the formula bar, ribbon actions may be unavailable or may not do what you expect. Finish or cancel the edit first, then select the row, column, or cell on the grid before using the command.

Assuming manual breaks override every print setting. Scaling the sheet to fit a set number of pages can take precedence over manual breaks. In particular, fit-to-page scaling may cause the printed result to ignore the page divisions you expected. Always examine the print preview after changing breaks or scaling.

Tips

Use Page Break Preview for placement, and Print Preview for the final check. Page Break Preview makes it easier to see the sheet’s row and column boundaries. Print Preview shows how the selected printer settings, paper size, margins, orientation, and scaling combine on actual pages. Both views answer different questions, so use them together when a report must be easy to read.

Keep related records together. Put a break before a new department, month, or section rather than splitting a heading from the rows it describes. If a page starts with data but no column headings, repeat the heading row for printing through Page Layout > Print Titles, where available in desktop Excel. A manual page break and repeated print titles solve different layout problems.

Prefer one deliberate break over many small adjustments. Too many manual breaks can make a worksheet difficult to maintain when rows are added or column widths change. Start with the main division, inspect the page count, and add another break only if the preview shows a real readability problem. Recheck the layout after changing the data or print settings.

Watch for fit-to-page settings. On the Page Layout tab, inspect the Scale to Fit controls. If Width or Height is set to a specific page count, Excel may scale the sheet to that count instead of honoring manual page boundaries as expected. Set the relevant control to Automatic when you want page breaks to determine the divisions, then confirm the result in Print Preview. Scaling is useful when fitting a compact sheet, but shrinking a large report can make text too small.

Use the matching desktop command on a Mac. The Windows Alt key-tip sequence is not the Mac equivalent. In Excel for Mac, select the intended row, column, or cell and use Page Layout > Breaks > Insert Page Break if that command is available in your ribbon. Excel for the web does not provide the same full set of desktop page-break editing controls; open the workbook in the desktop app when you need to create or manage manual breaks.

Troubleshooting

The shortcut does nothing. Confirm that you are using Excel desktop on Windows, that the worksheet grid is active, and that you are pressing the key tips one after another. Press Esc to close any open menu, exit cell-edit mode, and try Page Layout > Breaks > Insert Page Break. If your installation uses another display language or shows different key-tip letters, follow the letters Excel displays.

The Breaks command is unavailable. First make sure a normal worksheet is active rather than a chart sheet, and that Excel is not in cell-edit mode. A protected worksheet may restrict page-layout changes; if you have permission, use Review > Unprotect Sheet before changing the layout. If the sheet belongs to a shared or restricted workbook, ask its owner before changing protection or print setup.

The break appears in the wrong place. Check the selection and remember the placement rule: above the selected row, left of the selected column. Remove the misplaced break, select the first row or column that belongs on the next page, and insert it again. In Page Break Preview you may also drag a boundary to a more suitable position, then inspect Print Preview to verify the result.

The preview ignores your manual breaks. Review the Scale to Fit settings and change fixed Width or Height page counts to Automatic if you want the manual divisions to control pagination. Also check paper size, orientation, margins, and the print area; these affect how much fits on each page. If the print area excludes the selected rows or columns, a break outside that area will not appear in the printed output.

There are still dashed lines after you reset breaks. Dashed lines are usually automatic page breaks, not leftover manual breaks. Reset All Page Breaks clears manual breaks, but Excel continues to calculate automatic divisions from the print settings and sheet contents. To hide page-break lines in the normal worksheet view, open File > Options > Advanced, find Display options for this worksheet, and clear Show page breaks. This changes their display, not the print layout.

Frequently Asked Questions

What is the shortcut to insert a page break in Excel?
In current English-language Excel for Microsoft 365 on Windows, select the target row, column, or cell, then press Alt, P, B, I in sequence. If the displayed key tips differ, use the on-screen letters or choose Page Layout > Breaks > Insert Page Break.

Does Ctrl+Enter insert a page break?
No. Ctrl+Enter is not Excel’s page-break command. Use the Alt key-tip sequence on Windows or the Page Layout ribbon command. A page break changes print pagination, not where data is entered in the worksheet.

How do I add only a horizontal page break?
Select the row immediately below the intended division, then insert the break. Selecting the row header ensures Excel places the break above that row. For a vertical-only break, select the column immediately to the right of the intended division.

Can I insert a page break in Excel for Mac?
Yes, use the Page Layout ribbon’s Breaks menu and choose Insert Page Break if it is available in your version. The Windows Alt, P, B, I key-tip sequence is not a Mac shortcut, so use the visible Mac ribbon command instead.

Why does Excel show dashed page-break lines?
Dashed lines normally mark automatic page boundaries calculated from the sheet and print settings. Manual breaks generally appear as solid boundaries in Page Break Preview. Dashed lines can remain after resetting manual breaks because Excel still needs to show where automatic pages would divide.

Will a page break affect the worksheet when I edit data?
No, it does not insert or remove worksheet cells. It controls where printed pages divide, although changes to data, row heights, column widths, paper settings, or scaling can affect the final pagination. Recheck Print Preview after making those changes.

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.