To keep a row or a column visible while scrolling down to another area of the worksheet, freeze panes feature in Excel is used. Following are necessary steps to get the results:
Freeze top row
1. In the View tab, Click Freeze Panes in the Windows section.
2. Select Freeze Top Row option.
3. A dark grey line under the first row will appear which means that top row has been frozen.
You can see row number 2, 3 and 4 have been moved up while scrolling down and row number 1 with dark grey underline has been frozen.
Freeze the first column
To freeze the first column same steps will be done except Freeze First Column option will be selected in above-mentioned step 2.
To unfreeze the frozen row or column, follow these steps:
1. In View tab, click Freeze Panes.
2. Select the Unfreeze Panes option.
Freeze panes of your own choice
To freeze a row or a column of your own choice, following steps will be performed:
1. Select row 3.
3. Select Freeze Panes option.
4. As you can see first 2 rows have been frozen.
Note: for a column to freeze, same steps will be followed except column will be selected rather than the row selected before in step 1.
Shortkeys for freezing panes
To freeze a first row, press one by one Alt, W, F, and R.
For a first column, press one by one Alt, W, F, and C.
To freeze panes of your own choice, press one by one Alt, W, F, and F. (Note: you will need to select a column or a row to freeze before pressing short keys)
For unfreeze, press one by one Alt, W, F, and F.