How I do select a row (or rows) in my spreadsheet to repeat on every page when printed?

How I do select a row (or rows) in my spreadsheet to repeat on every page when printed?

1. Select Format → Print Ranges → Edit from the main menu
2. 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.
3. Click  OK .

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 if they are consecutive.