To freeze top row or column
- Go to View -> Freeze Panes -> Freeze first row or first column.
Freeze first row
Download and Try using this file:

Download and Try using this file:
To freeze first 10 rows,
- Select row 11, Go to View -> Freeze Panes -> Freeze panes.
On scrolling, the rows would be fixed.
Freeze first 10 rows
Download and Try using this file: