Forum Discussion
How to freeze Rows & columns at the same time
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.
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