+ Reply to Thread
Results 1 to 2 of 2

overlapping frozen panes?

  1. #1
    Registered User
    Join Date
    01-27-2013
    Location
    New Mexico
    MS-Off Ver
    Excel 2010
    Posts
    38

    overlapping frozen panes?

    Hi there, I have seen a worksheet that seemed to have frozen panes that overlap. What I mean by this is that the top row is frozen to start. Then as you scroll down to another major category header, it takes the place of the original frozen header. It stays there until you get to the next major header and so on. I don't have the file anymore but it would be really useful in one I am putting together. anyone know how to do this?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: overlapping frozen panes?

    If this can be done, it would be through VBA, so I will move this to the VBA forum for you
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Freezing Panes within panes already frozen...
    By jpcsolutions in forum Excel General
    Replies: 1
    Last Post: 12-12-2011, 03:24 PM
  2. Printing with Frozen Panes
    By jared.tesche in forum Excel General
    Replies: 1
    Last Post: 11-17-2011, 09:41 PM
  3. Frozen panes won't stay frozen
    By Irshlas in forum Excel General
    Replies: 0
    Last Post: 03-12-2009, 03:15 PM
  4. Frozen panes do not save
    By hyper71 in forum Excel General
    Replies: 1
    Last Post: 05-30-2008, 11:21 AM
  5. How do I Hide frozen panes when printing?
    By Stargiddy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-20-2005, 02:15 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1