How to Insert a Page Break in Excel

Make your spreadsheets print flawlessly

A Microsoft Surface 2 tablet

Joe Raedle/Getty Images

When you need to print spreadsheets, you can insert a page break in Excel to determine exactly how many pages will print or to maintain a certain style of printing. While Excel spreadsheets have standard page breaks dictated by various schematics like paper size, margin settings, and scale, users can also manually set page breaks.

This method works for Microsoft Excel for Office 365, as well as for Excel 2019, Excel 2016, Excel 2013, Excel 2010, and Excel 2007.

How to Insert a Page Break in Microsoft Excel

While you can create manual page breaks in the Normal view of Microsoft Excel, Page Break Preview allows you to see added edit details, such as the difference between an automatic page break and a manual page break.

An automatic page break is noted with a dashed line, while a manual page break is noted with a solid line.

Automatic vs. Manual page break
Automatic vs. Manual page break.
  1. Open the Microsoft Excel worksheet you want to edit and print.

  2. Select View > Workbook Views > Page Break Preview. You can also select the Page Break Preview icon in the status bar at the bottom of Microsoft Excel.

    Page break preview
    Page break preview.
  3. Be certain about what kind of page break you need to make. For a vertical page break, you will need to select the row below where you want the break. For a horizontal page break, you will need to select the column to the right of where you want the break.

    Microsoft Excel page break orientation
    Microsoft Excel page break orientation.
  4. Select the Page Layout tab > Page Setup group > Breaks.

    Page break
    Page break.
  5. Select Insert 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 select Insert Page Break from the drop-down menu.

How to Edit Page Breaks in Microsoft Excel

You can edits page breaks in Excel in various ways, including moving newly made page breaks to different locations in the spreadsheet.

  • Move a page break: Select the break, then drag and drop it to your desired location.

You can also move automatic page breaks in Page Break Preview, but this action changes it to a manual page break.

  • Delete a page break: Select the row below or the column to the right of the break you want to delete. Select the Page Layout tab > Page Setup group > Breaks > Remove Page Break.

You cannot delete an automatic page break.

  • Remove all manual page breaks: Select Page Layout tab > Page Setup group > Breaks > Reset All Page Breaks. Alternatively, with a mouse, right-click any cell on the worksheet, then select Reset All Page Breaks from the drop-down menu.