Forum Discussion
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, Freeze Top Row and Freeze First Column.
(It used to be easy in Excel fro Mac 2016!)
THANKS EVERYBODY - and Happy New Year despite everything.
CN
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.
22 Replies
Excel online has a slightly different user interface in freezing rows.
In Excel desktop application, we can follow the guidance of Microsoft's webpage to freeze rows and columns as shown in the following link.
https://support.microsoft.com/en-au/office/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f
On the other hand, if we want to freeze rows and columns in Excel online, the interface is a tad different. But the steps are identical conceptually. Check out the following webpage for detailed instructions.
https://dashz.substack.com/p/excel-online-freeze-row-and-column
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.
- So simple, but not clear in the standard instructions! Thanks for solving a super annoying issue for me!
HansVogelaar thanks Hans. I didn't think about the need to unfreeze everything before applying the custom freezing option. Years later, just wanted to let everyone know that this fix is still valid. For the life of me, I couldn't figure out why Freeze Panes was not showing up as an option for me. Unfreezing and then placing the cursor in the first active cell outside the range I wanted frozen worked perfectly.
Good to hear that!
- Worked, thanks much. For some reason it worked for me in cell B2, guess it is a formatting thing.
