The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

This page is outdated. You will be redirected to /wiki/Documentation/FAQ shortly.

Documentation / User FAQ / Calc / Previous-Next

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

Follow these steps:

  1. Open Calc.
  2. Select the row(s) to repeat.
  3. Select Format > Print Ranges > Edit from the pull-down menus.
  4. Change Rows to repeat from - none - to - user defined - via the drop-down menu.
  5. The row numbers can be set a couple of ways:
    • Enter the row number (e.g. $4 for row 4).
    • Click on the icon to the right of the input bar, then select a cell on the desired row from the spreadsheet. Multiple rows can be specified dragging your mouse across a range of cells.
    • Type the range into the Rows to repeat input bar. Place a colon between the starting cell and the ending cell to show a range.
  6. 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 > Print Preview to preview pages before printing.

For more information:

Go to Help > Contents > Index and type print ranges. Double-click on list items there to bring up the corresponding help pages.

Documentation / User FAQ / Calc / Previous-Next

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.