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
Jump to: navigation, search


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 .
Documentation note.png
  • 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.


Personal tools