Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    May 2002
    Location
    Loveland, Ohio, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Titles (Office 2003)

    Hello,

    I would like to create a spreadsheet that has the following data:

    Area1 Heading1 Heading2 Heading3
    data data data
    data data data

    Area3
    data data data
    data data data
    data data data

    Area3
    data data data
    data data data
    data data data

    I would like to create a freeze pane under Area 1 so that my headings stay put when the viewer scrolls, but I would like the other "Area"'s to come up and take the place of Area 1 (i.e., Area2 would replace Area1 until a new entry in that column was scrolled up).

    I have no clue as to how to do that, or if it is even possible. Does anyone know how I might do that? I know that if I moved the Area1 down a line I would have something close.

    Thanks,

    Andy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Titles (Office 2003)

    See the thread starting at <post:=540,887>post 540,887</post:> for several suggestions.

  3. #3
    Star Lounger
    Join Date
    May 2002
    Location
    Loveland, Ohio, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Titles (Office 2003)

    Thanks Hans! A lifesaver as always. This was one I did not even know what to search for... Andy

Posting Permissions

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