print the "Feeze Panes" to each page

[Guest]

How do I get Excel to print the "freeze panes" to more than the first page

 

[Gord Dibben]

File>Page SetUp>Sheet>Print Titles>Rows to repeat at top.

Enter $1:$1 for one row..........$2:$2 for two rows or just point to the rows
you want to repeat.


Gord Dibben MS Excel MVP