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?



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.