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

Microsoft Excel users
Open Office Calc users

Microsoft ExcelMicrosoft Excel users

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

Microsoft Excel 2007 and later users
Earlier versions of Microsoft Excel

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 setup 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.

Open Office Calc users

To insert a page break while in Open Office 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.