Forum Discussion
Latest Microsoft365 Excel will not freeze panes properly
BCR8TV I believe you still haven't understood the issue here. It's not a glitch. It's the active cell that is the key factor for determining where to freeze the panes.
Select rows 10 to 15 and observe that A10 is the active cell. Rows 1 to 9 will be frozen. Select rows 15 to 10 (so by dragging upwards), A15 will be the active cell and rows 1 to 14 will be frozen.
Note that when you start selecting rows from the top of the grid, the active cell will be A1. Freeze panes now. Excel can't freeze rows above row 1 as there aren't any. Same thing if you would select the entire column A through D, starting at the left. The active cell will also be in A1 and Excel can't freeze any columns to the left if it.. In stead, it inserts a frozen panes in the center of the visible grid, just as you showed in the screenshot when you answered NikolinoDE . Now, if that is an undesired result, perhaps you can send feedback to MS and suggest that they display warning "Can not freeze panes", rather that insert frozen panes in the center of the grid. But I would take it as a signal that I did something wrong here, as one can't freeze panes at A1. Ctrl-Z and try again.
So, ensure that A1 is NOT the active cell when you freeze panes. Select the cell that should be the top left-hand cell of the moving portion (i.e. not frozen) of the spreadsheet.
Freeze the first two rows? Select A3 and freeze panes.
Freeze the first two columns? Select C1 and freeze panes.
Freeze the first two rows AND the first two columns? Select C3 and freeze panes.
Understand this principle and you will never make the mistake again. Simple as that!
• To freeze row 1&2 put cursor in first cell of row 3 with nothing selected anywhere on page
• Hit freeze panes
• Now row 1&2 are frozen
Apparently, I was over-thinking it. Thank you all for sharing with me & I hope you have a great year ahead!