How I do select a row (or rows) in my spreadsheet to repeat on every page when printed?
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Printing
How I do select a row (or rows) in my spreadsheet to repeat on every page when printed?
- Select Format - Print Ranges - Edit from the main menu
- Place the cursor in the input field on the Rows to repeat line
- Enter the row number manually (e.g. $4 for row 4, $4:$6 for rows 4 to 6), or
- Click on the icon to the right of the input field, then select a cell on the desired row from the spreadsheet.
Multiple rows can be specified dragging your mouse across a range of cells.
- Click OK.
Notes:
- The row(s) specified here will be repeated on each print.
- You will not see a visual change in the spreadsheet, only in the printed copies.
- Use File - Page Preview to preview pages before printing.
- You an only select multiple rows id they are consecutive.