
Figure 133: Specifying repeating rows
2) Columns can also 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 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:
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.
Chapter 5 Getting Started with Calc 177
Comentarios a estos manuales