Ask Your Question

Repeat row header on every page (print) [closed]

asked 2015-12-02 16:15:18 +0200

Yanick gravatar image

updated 2020-08-27 19:01:10 +0200

Alex Kemp gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-27 19:01:36.061841

1 Answer

Sort by » oldest newest most voted

answered 2015-12-02 19:25:07 +0200

pierre-yves samyn gravatar image


  • 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.


edit flag offensive delete link more


This worked for me.

Thiagarajan gravatar imageThiagarajan ( 2017-07-29 12:16:10 +0200 )edit

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

getright gravatar imagegetright ( 2018-09-20 08:14:49 +0200 )edit

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.

getright gravatar imagegetright ( 2018-09-20 10:48:53 +0200 )edit

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.

pierre-yves samyn gravatar imagepierre-yves samyn ( 2018-09-20 11:57:08 +0200 )edit

@pierre-yves samyn , 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,

getright gravatar imagegetright ( 2018-10-03 11:49:13 +0200 )edit

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: This was done in LO 4, but it worked for me using LO 6.

Michael Szczepaniak gravatar imageMichael Szczepaniak ( 2019-12-23 00:28:40 +0200 )edit

Question Tools

1 follower


Asked: 2015-12-02 16:15:18 +0200

Seen: 24,709 times

Last updated: Dec 02 '15