How to insert, change, and delete page breaks in Microsoft Excel and OO Calc

Updated: 05/05/2017 by Computer Hope

Microsoft ExcelMicrosoft Excel users

To insert a page break while in Microsoft Excel, follow the steps below.

Microsoft Excel 2007 and later users

  1. Open the View tab
  2. In the Workbook Views group, click Page Break Preview.
  3. Select the row or column you want to insert the page break on.
  4. In the Page Layout tab, under the Page Setup group, click Breaks.
  5. Finally, click Insert Page Break.

Earlier versions of Microsoft Excel

  1. Move the selected cell to where you want the page break.
  2. Click Insert on the file menu.
  3. Select Page Break from the drop down.

After you've inserted a page break, if you want to delete, modify, or change how your page breaks are set up, click View from the drop down menu and select Page Break Preview. In the Page Break Preview, you can drag each of the page breaks. If you want to delete page breaks, drag the page break to the edge of the preview.

OpenOffice Calc users

To insert a page break while in OpenOffice Calc, follow the steps below.

  1. Click Insert on the file menu.
  2. Click Manual break.
  3. Select either Row or Column break, depending on how you want to break your spreadsheet.

Additional information

  • See the page break definition for further information and related links.