M Mike Jun 16, 2009 #1 Similar to "freezing panes" except I want the frozen panes to print on each page.
J JLatham Jun 16, 2009 #2 [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.
[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.
G Gord Dibben Jun 16, 2009 #3 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
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
