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.
If the first item in the Freeze Panes drop down is Unfreeze Panes, select that.
Select the cell below the last row that you want to keep visible, and to the right of the last column that you want to keep visible.
So for example, if you want to freeze the first row and first column, select cell B2.
And if you want to freeze the first two rows and the first three columns, select cell D3.
Then select Freeze Panes > Freeze Panes.
Wonderful explanation!! Thank you so much!
- Wow! I finally got it. If I only had a brain!
Thank you very much!
Fred
