Forum Discussion
Excel Freeze Panes
Why is MS Excel Freeze Panes so broken? I' trying to freeze lines 1 - 4 and columns A - N on a spreadsheet I have created. I found out that I need to go to the furthest cell and column to the right...
I have used Excel since its earliest versions, and it has always been necessary to select the cell below the last row that you want to freeze, and to the right of the last column you want to freeze.
So if you want to freeze rows 1 to 4 and columns A to N, you have to select cell O5 and then click Freeze Panes > Freeze Panes.
The window will have to be wide enough to display columns A to N plus at least one column more.