1. Go to the View tab
From the Excel Home
tab, navigate to the View
tab in the ribbon menu.
2. Freeze the top row
If you only need to freeze the first row, click Freeze Top Row
.
3. Select a specific row to freeze
To freeze multiple rows, click to highlight the row below the last one you want to freeze.
4. Use Freeze Panes
With your row selected and still in the View
tab, click Freeze Panes
to freeze the rows above.