+ Reply to Thread
Results 1 to 5 of 5

Is it Possible to have Multiple Separate Freeze Panes on same sheet?

Hybrid View

  1. #1
    Registered User
    Join Date
    02-19-2021
    Location
    Peoria, IL
    MS-Off Ver
    365
    Posts
    28

    Question Is it Possible to have Multiple Separate Freeze Panes on same sheet?

    Hey All,

    I am curious as to whether or not there is a way to have different frozen panes on the same sheet? For example; I have my first column of data as the frozen pane to cover data all the way though column AO - however after column AO I have a separate chart with different values to which I would like to have it's starting column be the frozen pane as you scroll horizontally past column column AO. Is this even possible to have multiple separate freeze panes on the same sheet?

    Your help is much appreciated!
    Last edited by i3 Data Hound; 11-15-2021 at 03:10 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,802

    Re: Is it Possible to have Multiple Separate Freeze Panes on same sheet?

    Short answer: no. You could open a new Window onto the Workbook, align them and then view different parts of the worksheet.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,138

    Re: Is it Possible to have Multiple Separate Freeze Panes on same sheet?

    Fraid not.

  4. #4
    Registered User
    Join Date
    02-19-2021
    Location
    Peoria, IL
    MS-Off Ver
    365
    Posts
    28

    Re: Is it Possible to have Multiple Separate Freeze Panes on same sheet?

    Dang! Well thank you for the info

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,802

    Re: Is it Possible to have Multiple Separate Freeze Panes on same sheet?

    You're welcome.

+ 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. [SOLVED] Freeze Multiple Panes
    By nkitchen31 in forum Excel General
    Replies: 2
    Last Post: 12-27-2019, 11:18 PM
  2. macro w/ Freeze panes keeps shifting where panes freeze on worksheet
    By sschwant in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2015, 02:30 AM
  3. can multiple Freeze Panes work on the 1 sheet
    By IAKNJDI in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-28-2014, 12:35 PM
  4. Dis-allow Delete sheet and allow Freeze Panes
    By ajaykgarg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-25-2011, 08:19 PM
  5. VBA - Freeze Panes on a NON Active Sheet
    By TreasureCat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-23-2007, 12:36 PM
  6. Freeze Panes-When freeze panes is employed it leave a black line
    By peter.thompson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2006, 01:40 AM

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