How to use page breaks in Excel or OpenOffice Calc

Updated: 09/03/2019 by Computer Hope
Microsoft Excel

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

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.