+ Reply to Thread
Results 1 to 2 of 2

Freeze Pane (Horizontal and Vertical) at different locations

  1. #1
    Registered User
    Join Date
    06-11-2009
    Location
    asd
    MS-Off Ver
    Excel 2003
    Posts
    27

    Freeze Pane (Horizontal and Vertical) at different locations

    Hi All,

    I have data in the form of headers in Row 3, but need to compare this to date found in Column C(rows 970-975) . Thus, I would like to be able to freeze panes twice, so that I could have the data in Row C as a header and that in Column C (between rows 970-975). Is this possible? It seems as if I can only freeze the horizontal and vertical planes if they are located TOGETHER.

    Thanks!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Freeze Pane (Horizontal and Vertical) at different locations

    Only 1 set of freeze or split panes allowed.

    Try using the New window command.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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