Excel 2007 - How do I print my two row header on each page?

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Similar to "freezing panes" except I want the frozen panes to print on each
page.
 
[Page Layout] tab, {Page Setup} group, click the "Print Titles" item. A
classic page setup dialog will open. In its [Sheets] tab, enter $1:$2 in the
area labeled "Rows to repeat at top" (or click in that area and choose rows 1
& 2 - same result).

Hope this helps.
 
Excel 2003 and earlier.

File>Page Setup>Sheet>Rows to repeat at top. enter 1:2

Excel 2007

Page Layout>Print Titles enter 1:2


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

Unable to freeze panes 16
printing freeze pane 1
How do I freeze/ unfreeze a window pane in Excel 2007? 2
Freeze multiple rows/columns in Excel 2007 11
Print Frozen Panes? 2
Printing labels at the top of multiple pages 4
frozen panes 2
Freeze Pane Saving 10

Back
Top