From The Document Foundation Wiki
How do I select a row/column (or more) in my spreadsheet so that it is repeated on each page when printed?
Follow these steps:
- Open the spreadsheet.
- Go to ▸ ▸ .
- Click on the box to the right of Rows to repeat or Columns to repeat.
- Select the row(s)/column(s) to be repeated.
- Click OK.
When you print, the selected area will now be printed on each page. You will not see any visible change in your spreadsheet. Use▸ to see what the pages will look like before printing.