From The Document Foundation Wiki
    < Faq‎ | Calc

    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:

    1. Open the spreadsheet.
    2. Go to Format ▸ Print Ranges ▸ Edit.
    3. Click on the box to the right of Rows to repeat or Columns to repeat.
    4. Select the row(s)/column(s) to be repeated.
    5. 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 File ▸ Print Preview to see what the pages will look like before printing.