Mar 09 2020 09:25 AM
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.
Mar 09 2020 09:36 AM
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
Mar 09 2020 10:01 AM
Oct 28 2020 08:42 AM
Jul 07 2022 09:06 AM
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.
Sep 20 2022 09:20 AM
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.