How to print a big table in Calc, repeating the header on page break

I use Windows 10, LibreOffice (X64) on a Dell Notebook.

I have a long list of rows in Calc sheet.
As I update it often, it is impractical to specify different print areas for each print page break. Row heights differ unforeseen.

The obvious remedy is to highlight (select) and mark the “heading” rows to be repeated on subsequent pages when page overflow occurs.

Columns A B C D E F
Rows 1 - 3 serve as column headings after automatic page breaks on printed pages.
Automatic page break row numbers cannot be predicted.
Some tables also need to repeat certain selected columns (e.g. Column 1-2) to be marked for automatic repetition if width exceeds page width. The appropriately selected relevant column headings then also need to be repeated as mentioned above.


1 Table of friends
2 A Surname B Name C Address D Cellphone E Email F Kid’s

3 D Number E address F names )
4 to 1000 rows of entries
Rows 1-3 to be automatically inserted when page overflow occurs during printing the big table. Row heights differ due to entry size. Impossible to estimate page overflow.

Menu/Format/Define print ranges

Help ‘Printing Rows or Columns on Every Page’