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.
@Hans Vogelaar So...I unfreeze panes and those are still the only options that I get...and none of them will freeze both the rows and columns at the same time...am I just not fully awake yet? lol
Let's say you want to freeze the top 2 rows and the first 3 columns (A to C).
Select the cell below row 2 and to the right of column C, that is cell D3.
Then select View > Freeze Panes > Freeze at selection.
- HansVogelaar
Hahahaha I just tried again and it worked! I knew if I posted that, it would work! SMH Thanks so much for your help! - HansVogelaar
I did that but it only freezes the top 2 rows...