View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default 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.