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

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?

In the main menu look under Format → Print Ranges → Edit;

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

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.

Thank you!! Found it!!