Ask Your Question
1

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

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

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
1

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

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

Comments

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 +0100 )edit
0

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

CPNewUser gravatar image

Thank you!! Found it!!

edit flag offensive delete link more

Question Tools

1 follower

Stats

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

Seen: 7,355 times

Last updated: Aug 16 '13