+ Reply to Thread
Results 1 to 8 of 8

Freeze Panes Glitch

  1. #1
    Registered User
    Join Date
    03-14-2019
    Location
    Atlanta, Georgia
    MS-Off Ver
    2016
    Posts
    5

    Freeze Panes Glitch

    When I try to freeze panes in excel an image of some of the cells that I'm freezing appears on top of some of the cells I want to see. I've attached a document with 2 screenshots. The first is a screenshot of my unfrozen workbook where I've selected the cell I want to use to freeze the rows and columns I'd like to freeze. The second image is the document after I click freeze panes. Any idea of how i can get rid of the image of frozen cells covering up my column headers?
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,705

    Re: Freeze Panes Glitch

    Welcome to the Forum AMBBJ_2019!

    This looks unusual. Can you attach your actual Excel file please, with Freeze Panes turned on?

    The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    03-14-2019
    Location
    Atlanta, Georgia
    MS-Off Ver
    2016
    Posts
    5

    Re: Freeze Panes Glitch

    File is attached. (Thanks for explaining how to do it.)
    Attached Files Attached Files

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,472

    Re: Freeze Panes Glitch

    Not seeing the issue here.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Registered User
    Join Date
    03-14-2019
    Location
    Atlanta, Georgia
    MS-Off Ver
    2016
    Posts
    5

    Re: Freeze Panes Glitch

    Hmm... still seeing it on my end. Must be a local setting that's making this happen

  6. #6
    Registered User
    Join Date
    03-14-2019
    Location
    Atlanta, Georgia
    MS-Off Ver
    2016
    Posts
    5

    Re: Freeze Panes Glitch

    Just tried to freeze panes on a different excel document to see if it was something about my computer and not this particular excel document. I didn't have any issues freezing panes in the other doc

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,472

    Re: Freeze Panes Glitch

    Can you try copying the contents to a new workbook and seeing if it still happens?

  8. #8
    Registered User
    Join Date
    03-14-2019
    Location
    Atlanta, Georgia
    MS-Off Ver
    2016
    Posts
    5

    Re: Freeze Panes Glitch

    That worked thank you!

+ 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. 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
  2. Freeze Panes - Can I freeze a specific set of cells?
    By Rosco88 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-15-2013, 09:17 AM
  3. Freeze Panes - Freeze Tabs
    By samprince in forum Excel General
    Replies: 1
    Last Post: 01-23-2007, 05:16 PM
  4. Replies: 3
    Last Post: 11-27-2006, 05:24 PM
  5. [SOLVED] Excel 2003 freeze panes won't freeze top row only
    By macbone2002 in forum Excel General
    Replies: 1
    Last Post: 05-31-2006, 11:10 AM
  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
  7. [SOLVED] Freeze Panes-can you freeze more than one column
    By rexmann in forum Excel General
    Replies: 4
    Last Post: 06-09-2005, 11:05 AM

Tags for this Thread

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