Consulting

Results 1 to 3 of 3

Thread: Freezing two top rows

  1. #1

    Freezing two top rows

    Good morning guys. I am using Excel 2007. I want to freeze the two top
    rows of the ss. Excel 2007 is not giving me that option. I think that Excel
    2007 will allow me to freeze the top row only. I think I am missing something. Any help with this?
    Thanks
    Max

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    I agree that there is a Freeze First row in 2007, but there is still Freeze Panes, so select A3 and do Freeze Panes.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    Thanks that will work. I forgot about that trick
    Max

Posting Permissions

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