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

Notes:

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


Personal tools