Freeze two panes
Freeze two panes
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Freeze two panes

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Is it possible to freeze both the top row and the left-most column at the same time with "freeze panes"?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sure, select B2, then go to Window, Freeze Panes
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    New Member niteshahir's Avatar
    Join Date
    May 2011
    Location
    Ahmedabad, India
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Is it possible to freeze panes for two times?

    Quote Originally Posted by Juan Pablo González View Post
    Sure, select B2, then go to Window, Freeze Panes
    I am working with Microsoft Excel 2010. If I freeze first column so Is it possible to freeze second column any where in excel spread sheet?

    If yes so please let me know.

  4. #4
    New Member
    Join Date
    May 2011
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Freeze two panes

    I dont think that it is possible to have two independent freeze panes in excel 2007.

    If you are looking to free a combination of rows and columns use freeze panes. But having two independent panes is not yet possible

  5. #5
    New Member niteshahir's Avatar
    Join Date
    May 2011
    Location
    Ahmedabad, India
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Freeze two panes

    Quote Originally Posted by msofficianado View Post
    I dont think that it is possible to have two independent freeze panes in excel 2007.

    If you are looking to free a combination of rows and columns use freeze panes. But having two independent panes is not yet possible
    But, I am working with 2010.

  6. #6
    New Member
    Join Date
    Mar 2010
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Freeze two panes

    sure unfreeze first column then select any cell in second column (if u want to freeze both column and row) else just repeat what u did for first column.

  7. #7
    New Member
    Join Date
    May 2011
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Freeze two panes

    Nitesh,
    2010 does not have any changes when it comes to freeze panes feature. So I guess what I told for 2007 still holds..
    Quote Originally Posted by niteshahir View Post
    But, I am working with 2010.

  8. #8
    New Member
    Join Date
    Nov 2011
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Freeze two panes

    Quote Originally Posted by niteshahir View Post
    But, I am working with 2010.
    That is impossible by logic, because if you will freeze two independent cell or panes, how can the first one be able to scroll if the 2nd one is frozen, so something will stop the first one from moving...

    what i am thinking if i were microsoft is to put a split so you can freeze two panes, what will happen looks like there will be two sheets in one sheet.

  9. #9
    Board Regular Expiry's Avatar
    Join Date
    Jun 2007
    Location
    Dunbar
    Posts
    860
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Freeze two panes

    Why would you ever want to do that? The reason for freeze panes is so that you can see the relevance of a column or row. Once you've frozen two areas independantly, that relevance is lost, surely?

  10. #10
    New Member
    Join Date
    Nov 2011
    Posts
    30
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Freeze two panes

      
    I am actually curios about the same thing (I think)....

    I have a cloumn of data on the left (columns A-D) that I want to always be visible on the left as I scroll down the data in columns E-T. I also want the heading in E-T to stay in place.

    So I can freeze the top headings easily, hoever is it possible to freeze the data on the left in place so it cannot scroll horizontally or vertical while the rest of the sheet can?

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com