View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.