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

Similar to "freezing panes" except I want the frozen panes to print on each
page.

Excel 2007 - How do I print my two row header 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.

"Mike" wrote:

Similar to "freezing panes" except I want the frozen panes to print on each
page.

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

Excel 2003 and earlier.

FilePage SetupSheetRows to repeat at top. enter 1:2

Excel 2007

Page LayoutPrint Titles enter 1:2


Gord Dibben MS Excel MVP

On Tue, 16 Jun 2009 12:55:02 -0700, Mike
wrote:

Similar to "freezing panes" except I want the frozen panes to print on each
page.