How to have frozen panes print on every printed page
 

I have a sheet that has a title and header cells as 2 rows frozen at the
top.
I would like those two rows to appear on every printed page.
Is this possible?

How to have frozen panes print on every printed page
 

One way:

File/Page Setup/Sheet, Rows to repeat at top: $1:$2

In article ,
"Edward" wrote:

I have a sheet that has a title and header cells as 2 rows frozen at the
top.
I would like those two rows to appear on every printed page.
Is this possible?

How to have frozen panes print on every printed page
 

"Edward" wrote in message
...
I have a sheet that has a title and header cells as 2 rows frozen at the
top.
I would like those two rows to appear on every printed page.
Is this possible?



What version of Excel?

How to have frozen panes print on every printed page
 

"JE McGimpsey" wrote in message
...
One way:

File/Page Setup/Sheet, Rows to repeat at top: $1:$2


That's why I asked what version of Excel - it's in a different place in
2007....

How to have frozen panes print on every printed page
 

Thanks!

It's '97 by the way but I have it now



"Gordon" wrote in message
...
"JE McGimpsey" wrote in message
...
One way:

File/Page Setup/Sheet, Rows to repeat at top: $1:$2


That's why I asked what version of Excel - it's in a different place in
2007....