Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't print a header with Excel 2007 beta | Excel Discussion (Misc queries) | |||
In excel print header on firt page only | Excel Discussion (Misc queries) | |||
print a certain row as the header on each page | Excel Discussion (Misc queries) | |||
How can I print a different header on each page of an Excel Sheet | Excel Discussion (Misc queries) | |||
In Excel 2000, can I print the header on the first page only? | Excel Worksheet Functions |