Ask Your Question

In Calc, how do I get row #1 to print on multiple pages as a header? [closed]

asked 2013-08-14 22:46:31 +0200

CPNewUser gravatar image

In Excel, there is the option to have selected rows or columns be printed in each page of the document. Have not been able to find this option in Libre nor could I find it in Calc Help.

Any suggestions?
Thanks!!! cp

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 2015-11-06 23:24:36.454435

2 Answers

Sort by » oldest newest most voted

answered 2013-08-14 22:58:36 +0200

stephan66 gravatar image

In the main menu look under Format -> Print Ranges -> Edit;

Enter the rows to be printed on each page under "Rows to repeat"

edit flag offensive delete link more


But if you are using an older version of LO, there is bug... don't know which version, but if you saved those headers and then open it, header will not be repeated, so you need to set up it again. The solution is to hide row #1, and use #2 as the first row.

Ljiljan gravatar imageLjiljan ( 2013-08-14 23:17:05 +0200 )edit

answered 2013-08-16 21:40:19 +0200

CPNewUser gravatar image

Thank you!! Found it!!

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-08-14 22:46:31 +0200

Seen: 7,634 times

Last updated: Aug 16 '13