The Free and Open Productivity Suite
Apache OpenOffice 4.1.6 released

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 and the Apache feather logo are trademarks of The Apache Software Foundation. OpenOffice, and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.