Forum Discussion
Solved
How to freeze Rows & columns at the same time
I have Excel 365 for Mac. I need to freeze my Column A and Rows 1-3 at the same time. Excel Help says I can do this via View > Freeze Panes but in View I see no such option, only Unfreeze Panes, Free...
Apparently, Freeze Panes is already active.
So first select Unfreeze Panes from the Freeze Panes dropdown.
Then select cell B4, and select Freeze Panes from the Freeze Panes dropdown.
I had the same problem but I still can get only half of the solution to work. Clearly I am missing the point. Sometimes I get the top row to freeze but not the left most column to freeze. Or vice a versa. Help. I used to be able to freeze both with the beta version of excel years ago but as the product evolved I could no longer accomplish the task of getting both the top row and left column freeze at the same time. Help!
Hans Vogelaar's EXCELLENT advice of
Jan 18 2021 03:44 AM
continues to work perfectly for me but I'm on Excel for Mac 16.69.1
He said:-
He said:-
Apparently, Freeze Panes is already active.
So first select Unfreeze Panes from the Freeze Panes dropdown.
Then select cell B4, and select Freeze Panes from the Freeze Panes dropdown.