How to Freeze a Row in Microsoft Excel

1. Open the Excel worksheet.
2. Click the top row heading. The row heading displays a number just left of the first column of cells. The selected row appears shaded.
3. Click the 'View' tab on the command ribbon.
4. Click the 'Freeze Panes' button in the 'Window' group. A list of options appears.
5. Click the 'Freeze Top Row' option. A black horizontal line appears on the worksheet. This line indicates the locked row that stays on the screen as you scroll down the worksheet.