print the "Feeze Panes" to each page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I get Excel to print the "freeze panes" to more than the first page
 
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
 
You must log in or register to reply here.

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

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

Back
Top