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 by dragging your mouse across a range of cells.
- Click OK .