Freezing panes is a way of making one or more rows or columns stay at the top or left of your worksheet as you scroll through the worksheet. A common use of freezing panes is to keep a header row in view as you scroll through a large worksheet.
In the following example, notice that the top row includes labels for each column:
After scrolling down in the worksheet, however, the top row is not visible:
In the following image, the top row is frozen, so the labels are visible even after scrolling down in the worksheet:
To freeze panes in a Microsoft Excel worksheet: