Normally, when you are creating a spreadsheet in Microsoft Excel or OpenOffice Calc, page breaks will be inserted automatically, based on your document’s print settings. However, you can manually insert page breaks by following the steps below.

Microsoft Excel users

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

  • Microsoft Excel users
  • OpenOffice Calc users

Microsoft Excel 2007 and later users

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

Earlier versions of Microsoft Excel

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

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.

  • Microsoft Excel 2007 and later users.
  • Earlier versions of Microsoft Excel.

OpenOffice Calc users

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

  • Click Insert on the file menu.
  • Click Manual break.
  • Select either Row or Column break, depending on how you want to break your spreadsheet.
  • How to insert a page number in Microsoft Excel.
  • Additional information about spreadsheets.
  • See the page break page for further information and related links.
  • Software help and support.