How to freeze panes in Microsoft Excel 2013?
Freeze option is used to keep the selected rows/columns in static position. To use freeze option follow the steps given below.
Step 1: Select the cell you want to freeze.
Step 2: Click Freeze Panes under VIEW tab.
Step 3: Select Freeze Panes from the drop down list.
Rows and columns above the selected cell will be static when you scroll the workbook.