How to have frozen panes print on every printed page

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?
 
G

Gordon

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....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
Publisher adding blank page when printing my booklet... 2
Blank Page After Envelope-Label Wizard 5
Page numbering with Merged Document and IF statements 1
frozen panes print top of each page 2
Section and Page numbering 0
Unable to freeze panes 15
How to print two a6 booklets (A5 unfolded) on A4 paper? 3

Top