We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

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

asked 2018-09-09 23:06:47 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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.

e.g. 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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-09-09 23:23:07 +0200

m.a.riosv gravatar image

Menu/Format/Define print ranges

Help 'Printing Rows or Columns on Every Page'

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-09-09 23:06:47 +0200

Seen: 448 times

Last updated: Sep 09 '18