If you have a large number of rows or columns in your Microsoft Excel Sheet, often when you scroll down or right to access the data, the headings can get hidden. MS Excel offers a perfect solution to overcome this problem with an option of freezing panes. Freezing panes let you select the headings that as locked as you scroll down or left in your worksheet.
Using Freeze Panes
You can use this option to free panes by following the steps below:
Freeze First Column: This option automatically freezes the first column from the left.
If you wish to unfreeze the frozen Panes, just select the row or column and click on “Unfreeze Panes” listed under View Tab.