Thread: How to have frozen panes print on every printed page
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default 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?
Reply With QuoteReply With Quote