Insert Page Break in OpenOffice Spreadsheet

How to insert or add manual page break in OpenOffice Calc?

Explanation

While printing a large set of data, sometimes we need to give page breaks between the rows/columns to print them in separate page. To break the worksheet follow the steps below.
Add Manual Column Break:
Step 1: Click on the required column header. This will split the columns into two separate pages.
Here column B is selected.
page break in openoffice
Step 2: Click Insert ? Manual Break ? Column Break.
page break in openoffice1
You will get a dark blue line before the selected column as shown in the image below.
page break in openoffice2
Step 3: Now, click File ? Page Preview to view the page break.
In the below image, Column A is in separate page
page break in openoffice3
Column B, C and D are in separate page.
page break in openoffice4
Add Manual Row Break:

Step 1: Click on the required row header in the sheet.
Here row 9 is selected.
page break in rows openoffice
Step 2: Click Insert ? Manual Break ? Row Break.
page break in rows openoffice1
Selected row will be marked with the blue line as shown in the image below.
page break in rows openoffice2
Step 3: Use print preview option to view the Page break. In the below image, row 1 to 8 is in separate page.
page break in rows openoffice3
From row 9, the sheet is splitted into separate page.
page break in rows openoffice4

Related Topics