Printing a spreadsheet with a frozen column headings frame.

Hi need a little help.
I have a spreadsheet and the top couple of rows are the column titles. On the screen I have split the window and frozen the top pane, and all works wonderfully.

When I come to print the document I only get the column headers on page 1.
What is the method of getting my frozen column headers to appear on each page?

TIA

Greetings,

You need to configure the print area/ranges. To do so, you need to:

Format > Print Ranges > Edit...

There, you can configure the rows to repeat in the second selection. To
select the first row or your worksheet, you can use the button on the
right or enter $1. Multiple rows can be selected if your have frozen
more than 1.

I hope this helps.
Rémy.