English
Ask Your Question
0

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

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 close merge delete

2 answers

Sort by » oldest newest most voted
0

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

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 ( 2013-08-14 23:17:05 +0200 )edit
0

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

CPNewUser gravatar image

Thank you!! Found it!!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

Follow
1 follower

Stats

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

Seen: 2,365 times

Last updated: Aug 16 '13