Sometimes if you’re building a spreadsheet in Excel you want to be able to freeze the top row and the first column simultaneously…
However, with Microsoft Office 365 it’s not clear how to do this.
The “Freeze” option only allows you to “Freeze” column A or Row 1 from the menu bar.
If you select Freeze Column 1, you can’t also choose to Freeze Row A…
However, you can select cell B2 and click “Freeze Panes” this will freeze Row 1 and Column A simultaneously.
Selecting “Freeze Panes” in Excel freezes the rows above your selected cell and the columns to the left of your selected cell.