Getting Started Guide

For example, if the top two rows of the sheet as well as column A need to be printed
on all pages, do the following:
1) Choose Format > Print Ranges > Edit. On the Edit Print Ranges dialog, type
the rows in the text entry box under Rows to repeat. For example, to repeat
rows 1 and 2, type $1:$2. This automatically changes Rows to repeat from,
- none - to - user defined -.
Figure 124: Specifying repeating rows
2) To repeat, type the columns in the text entry box under Columns to repeat. For
example, to repeat column A, type $A. In the Columns to repeat list, - none -
changes to - user defined -.
3) Click OK.
Note
You do not need to select the entire range of the rows to be repeated;
selecting one cell in each row works.
Page breaks
While defining a print range can be a powerful tool, it may sometimes be necessary to
manually adjust 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:
1) Navigate to the cell where the page break will begin.
2) Select Insert > Manual Break.
3) 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.
140 Getting Started with OpenOffice.org 3.3