How to have frozen panes print on every printed page

  • Thread starter Thread starter Edward
  • Start date Start date
E

Edward

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?
 
JE McGimpsey said:
One way:

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

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