Source: Why Does Freeze Panes Not Work In Excel?
I’m using Excel 2016, and I’ve never had this problem before. 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. Users Query Regarding Freeze Panes Not Working