Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2002
    Location
    NJ
    Posts
    139

    Unanswered: Freeze Panes In Excel

    HI:

    Win2k, xp
    excel 2k

    Is there a way to have tow freeze panes in excel, one at the top and one at the bottom so that all the rows in between can be scrolled back and forth without affecting the top part of the pane and the bottom part?


    ____________
    ____top_____
    rows
    rows
    rows
    rows________
    ____bottom__

  2. #2
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628
    The command you're looking for is under the Windows menu in Excel. what you'll need to do first is select split and put the dividers where you want them. then go back to the windows menu and select Freeze Panes.

  3. #3
    Join Date
    Sep 2002
    Location
    NJ
    Posts
    139

    Freeze Panes

    hi

    I have done that already for to top part of the sheet. The question is how do you do this for the bottom part of that same sheet so that my sheet has two freeze panes: one top and one bottom on the same sheet?

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    I haven't ever seen a solution for that.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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