Printing frozen rows on each page

[tphillips]

I have a spread sheet with the first three rows frozen so that they won't scroll with the rest of the sheet. However, when I print the spread sheet, I want these frozen rows to print at the top of each page. Is there an easy way to do this?

 

[Patrick Alexander]

yes you can
when you go to page setup
and then the page sheet
you will see
rows you repeat at the top
there you can select the number of rows you want to print on every page