Page breaks
While defining a print range can be a powerful tool, it may sometimes be necessary to manually tweak Calc’s printout. To do this, you can use a manual break. A manual break helps to ensure that your data prints properly. You can insert a horizontal page break above, or a vertical page break to the left of, the active cell.
Inserting a page break
To insert a page break:
- Navigate to the cell where the page break will begin.
- Select Insert > Manual Break.
- Select Row Break or Column Break depending on your need.
The break is now set.
Row break
Selecting Row Break creates a page break above the selected cell. For example, if the active cell is H15, then the break is created between rows 14 and 15.
Column break
Selecting Column Break creates a page break to the left of the selected cell. For example, if the active cell is H15, then the break is created between columns G and H.
 | To see page break lines more easily on screen, you can change their color. Choose Tools > Options > OpenOffice.org > Appearance and scroll down to the Spreadsheet section.
|
Deleting a page break
To remove a page break:
- Navigate to a cell that is next to the break you want to remove.
- Select Edit > Delete Manual Break.
- Select Row Break or Column Break depending on your need.
The break is now removed.
 | Multiple manual row and column breaks can exist on the same page. When you want to remove them, you have to remove each one individually. This may be confusing at times, because although there may be a column break set on the page, when you go to Edit > Manual Break, Column break may be grayed out.
In order to remove the break, you have to be in the cell next to the break. So, for example, if you set the column break while you are in H15, you can not remove it if you are in cell D15. However, you can remove it from any cell in column H.
|
