Freeze panes not working properly

Occasional Visitor

I'm having an issue with freeze panes. I'm trying to freeze the first 2 columns and the top row of a large worksheet, so I'm using "Freeze top row" for the top row, and selecting the 3rd column and selecting "Freeze panes." The row and columns stay frozen for a while, but the freeze panes command "wears off", and sometimes doesn't work at all. I'm using Excel 2016, and I've never had this problem before. TIA.

5 Replies

@ACDeBellis 

Make sure the active cell is C2 then select Freeze Panes.

 

Freeze top row = Free top visible row

Freeze first column = Freeze first visible column

Hello,
Usually in this case, you will probably have headings in i.e row 3. If your headings is in row 3 and you want to Freeze row 3 and the first 2 columns (A and B), you need to select cell C4. Then, apply Freeze Panes.

This will Freeze the first two columns and the first 3 rows. When you scroll to the right and down, you will notice the freezing
I have had the same situation happen frequently and as yet haven't read a satisfactory explanation...
Whilst using the full downloaded client version of Excel 365 and particularly since ribbons came to fruition I have created customised ribbons, then this particular issue started occurring along with others...
My customised ribbon was made in a version a few years ago...is has been exported to later versions...then I found icons or functionality changed in some way or form. For example the Wrap Text and Group command buttons...
But whilst simply swapping out the old for the new solves those issues permanently, Freeze Pains remains unreliable, becoming disabled seemingly in random spreadsheet sessions...!
Currently the only way I have found is to remove the function from the ribbon and immediately add it back. This refreshes the ribbon and it is working again.
Whether this is a bug of the ribbon or of the code behind the function I do not know, but it remains a mystery...
So I do not tell you about instances where it is designed to be greyed out, purely my situation using Excel in everyday normal view mode.
It's a pain and I think an unresolved bug Microsoft has still to address.
Tink.

@ACDeBellis 

Yeah it's a little strange at first, but basically it freezes everything above and to the left of your current selection. So the other post is correct, use cell C2 to freeze the top row and the left two columns. Don't bother setting "Freeze Top Row", just use "Freeze Panes".

Experiment with a blank document, you'll see the pane lines clearly when you set the freeze.

I am facing an very annoying bug. I need to have frozen column and rows on a cell D9 in order to always display information in upper rows and left columns while being able to scroll the rest of the worksheet.

 

When I scroll the online worksheet on mobile devices (android with chrome and other browsers or apple with safari and other browsers) the parts of frozen panes in the worksheet are completely disappearing especially if you use a bit the zoom function. The only solution is to reload the url, than you start to scroll the data again and the parts of frozen panes disappears again.

The devices have a steady and very fast internet connection so the issue doesn’t seems to be on the user side.