Repeat row header on every page (print)

For a fixed number of rows in a spreadsheet, how do I make these rows repeating and be the header on every printed pages?

I have selected the first rows as header, then Window → Freeze. Now, I’d like to have them printed as header on every page. Is it possible?

1 Like

HI

  • Go to FormatPrint RangesEdit.
  • Select the Print Range (data to print)
  • 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 FilePrint Preview to see what the pages will look like before printing.

Regards

3 Likes

This worked for me.

how to achieve this by command line mode ? my environment only allow me to start libreoffice by “libreoffice --headless”

How to save this setting(repeat heading) and apply this for all tables forever? because I found next time I open such tables, I need set them again.

Hi @getright - it is a sheet parameter that must be defined via a graphical interface. It can only be set by default in a template, possibly defined as the default template for newly created documents. Template management has already been discussed here and is documented in the documentation.

@PYS , Hello, is there any template which is close to Microsoft Word template? or can we just import a template file from MS Word?
In addition, I try to edit the default template, It seems in template there is no table inside, so we cannot update the table style , I also try to build a new table in the template, and I found by default the “repeat heading” is checked,

You could record a little macro, assign it to a button and then just click the button when you need the headers to repeat at the top of each page. This video does a nice job explaining the general procedure: https://www.youtube.com/watch?v=EAm7RgzWRhM. This was done in LO 4, but it worked for me using LO 6.