Click on the row number directly below the row you want to freeze. For example, if you want to freeze the first row, click on the number 2 to select the entire second row.

Navigate to the view tab in the ribbon at the top of the excel window.

In the window group, click on freeze panes then dropdown menu will appear.

From the dropdown menu, select freeze at selection this will freeze the rows above the selected row. alternatively, if you only want to freeze the top row, you can choose freeze top row from the dropdown menu.

You’ll see a thin line indicating that the row is frozen. now, as you scroll through your worksheet, the frozen row will remain visible.