Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing Freeze Pane headers - every page (2k7)

    I have a frozen pane and I'd like to have the top pane printed on each page. Is this possible? Or do I need to copy and paste it to each page break?
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Printing Freeze Pane headers - every page (2k7)

    File - Page setup
    Sheet(tab)
    Set the desired rows to repeat at top
    [ok]

    Steve

  3. #3
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Freeze Pane headers - every page (2k7)

    ah, that was easy... just not so obvious in '07. Thanks!
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •