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?
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.
File is attached. (Thanks for explaining how to do it.)
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hmm... still seeing it on my end. Must be a local setting that's making this happen
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
Can you try copying the contents to a new workbook and seeing if it still happens?
That worked thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks