print the "Feeze Panes" to each page

G

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
 

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

printing freeze pane 1
Multiple "Freeze Panes" one one worksheet 2
Excel 2007 - How do I print my two row header on each page? 2
How to freeze a range in excel 2003and 2007 1
In Excel can you select freeze pane and split screen on same page 2
Excel Freeze panes in Excel 3
Change the width of the Header panes so text will fit 1
Freeze Panes loss 3

Top