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
Revision as of 13:38, 4 November 2008 by Ufi (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.


Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/FAQ/Calc/Printing/How_I_do_select_a_row_(or_rows)_in_my_spreadsheet_to_repeat_on_every_page_when_printed%3F&oldid=97752"
Personal tools