How to insert or add manual page break in OpenOffice Calc?
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.
Step 2: Click Insert ? Manual Break ? Column Break.
You will get a dark blue line before the selected column as shown in the image below.
Step 3: Now, click File ? Page Preview to view the page break.
In the below image, Column A is in separate page
Column B, C and D are in separate page.
Add Manual Row Break:
Step 1: Click on the required row header in the sheet.
Here row 9 is selected.
Step 2: Click Insert ? Manual Break ? Row Break.
Selected row will be marked with the blue line as shown in the image below.
Step 3: Use print preview option to view the Page break. In the below image, row 1 to 8 is in separate page.
From row 9, the sheet is splitted into separate page.