+ Reply to Thread
Results 1 to 3 of 3

Excel frozen panes stuck?

  1. #1
    Registered User
    Join Date
    10-22-2014
    Location
    Hyde, Manchester
    MS-Off Ver
    2010
    Posts
    79

    Excel frozen panes stuck?

    Hi All,

    I have got an excel sheet (2016) which appears to have the columns A-D frozen so that I can't scroll to them. However, unfreezing the cells seems to make no difference? I can also scroll to them with the scroll bar (so that it says it will be over column A) but it immediately jumps back. The cells are not hidden (as far as I can tell) but each time I try and hide a column and then unhide it it also gets included in the columns that I can't scroll to?

    All help gratefully received!!

    Tom

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Excel frozen panes stuck?

    Good afternoon tom.mat.walker

    Would you be able to remove all the data from the worksheet, remove any other sheets and just the leave the one with the structure issue, resave the file under a different name and post it on here so someone can take a look at it?

    Thanks

    DominicB

  3. #3
    Registered User
    Join Date
    10-22-2014
    Location
    Hyde, Manchester
    MS-Off Ver
    2010
    Posts
    79

    Re: Excel frozen panes stuck?

    Hi Dominic,

    Approximately 10 minutes ago they spontaneously made themselves reappear so problem solved?

    If it comes back I will send it out for viewing.

    Thanks

    Tom

+ 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. overlapping frozen panes?
    By dropanddrive03 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2013, 12:08 AM
  2. overlapping frozen panes?
    By dropanddrive03 in forum Excel General
    Replies: 1
    Last Post: 11-28-2013, 12:08 AM
  3. Freezing Panes within panes already frozen...
    By jpcsolutions in forum Excel General
    Replies: 1
    Last Post: 12-12-2011, 03:24 PM
  4. Printing with Frozen Panes
    By jared.tesche in forum Excel General
    Replies: 1
    Last Post: 11-17-2011, 09:41 PM
  5. Replies: 0
    Last Post: 09-20-2011, 08:15 PM
  6. Frozen panes won't stay frozen
    By Irshlas in forum Excel General
    Replies: 0
    Last Post: 03-12-2009, 03:15 PM
  7. [SOLVED] Subform in excel or Frozen Panes (Top & Bottom)
    By Santa-D in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2006, 07:59 AM
  8. [SOLVED] Frozen panes in Excel should stay put when using autofilter.
    By stuckfly in forum Excel General
    Replies: 8
    Last Post: 03-10-2006, 02:20 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