Faq/Calc/004

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

Other languages:

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:

Open the spreadsheet.
Go to Format ▸ Print Ranges ▸ Edit.
Click on the box to the right of Rows to repeat or Columns to repeat.
Select the row(s)/column(s) to be repeated.
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.