If you have a large amount of data in Excel worksheet and at the bottom of the data or data, you can not see the column heading, to see that you need to go to the top, MS office has solved this problem, it can be useful to freeze rows or columns.
This way you can keep rows or columns visible while scrolling through the rest of the worksheet.
Freeze Top Row
To freeze the top row, execute the following steps.
1. On the View tab, click Freeze Panes, Freeze Top Row.