Frequently asked questions - Calc

From The Document Foundation Wiki
< Faq‎ | Calc
Jump to: navigation, search

How do I select a row/column (or more) in my spreadsheet so that it is repeated on each page when printed?

Follow these steps:

  1. Open the spreadsheet.
  2. Go to Format ▸ Print Ranges ▸ Edit.
  3. Click on the box to the right of Rows to repeat or Columns to repeat.
  4. Select the row(s)/column(s) to be repeated.
  5. Click OK.

When you print, the selected area will now be printed on each page. You will not see any visible change in your spreadsheet. Use File ▸ Page Preview to see what the pages will look like before printing.