Faq/Calc/004

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

Template:TopMenu/en Template:Menu/en Template:Menu.Documentation/en Template:Menu.FAQ/en

Other languages:
dansk • ‎English • ‎français • ‎italiano • ‎русский


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 ▸ Print Preview to see what the pages will look like before printing.