How to Insert a Page Break in Microsoft Excel

Make your spreadsheets print flawlessly

Microsoft Excel

You've created a spreadsheet (a workbook in Microsoft parlance) in Microsoft Excel and now want to print it. By default, Excel uses metrics such as paper size, margin settings, and scale to insert page breaks automatically. To get clean, discrete pages without cutting off rows or text, however, you can insert a page break in the Excel spreadsheet manually.

The instructions in this article apply to Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, and Excel 2007.

Insert a Page Break

You can create manual page breaks in Normal view in Excel, but the Page Break Preview view enables you to see details such as the difference between an automatic page break and a manual page break.

Excel denotes an automatic page break by a dashed line. It denotes a manual page break by a solid line.

Automatic vs. Manual page break
Automatic vs. Manual page break.

Now that you know what you're looking for, complete the following steps to insert a manual page break in your workbook:

  1. Open the Excel workbook you want to print.

  2. On the ribbon, select the View tab.

    In the Workbook Views group, select Page Break Preview.

    Page break preview
    Page break preview.

    You can also select Page Break Preview in the status bar at the bottom of the application.

  3. Excel has two types of page break:

    • Vertical page break: Select the row below where the break will be.
    • Horizontal page break: Select the column to the right of where the break will be.
    Microsoft Excel page break orientation
    Microsoft Excel page break orientation.
  4. On the ribbon, select the Page Layout tab.

In the Page Setup group, select Breaks > Insert Page Break.

Page break
Page break.

If you're using a mouse, you can right-click the row below or the column to the right of where you want the break, and then select Insert Page Break from the context menu.

Edit a Page Break

You can edit page breaks in Excel in three ways:

  • Move a specific page break.
  • Delete a specific page break.
  • Remove all manual page breaks.

Move a Specific Page Break

To move a specific page break in your workbook, select the page break you want to move, and then drag it to the new location.

You can also move automatic page breaks, but doing so changes them to manual page breaks.

Delete a Specific Page Break

To delete a specific page break in your workbook, complete these steps:

  1. Select the row below or the column to the right of the break you want to delete.
  2. On the ribbon, select the Page Layout tab.
  3. In the Page Setup group, select Breaks > Remove Page Break.

You cannot delete an automatic page break.

Remove All Manual Page Breaks

To delete a specific page break in your workbook, complete these steps:

  1. On the ribbon, select the Page Layout tab.
  2. In the Page Setup group, select Breaks > Reset All Page Breaks.

If you're using a mouse, right-click any cell in the workbook, and then select Reset All Page Breaks from the context menu.