Open your Excel worksheet
Click the row below the header you want to lock
Go to the View tab
Click Freeze Panes
Select Freeze Panes
If your header is in the first row, you can also choose Freeze Top Row
Scroll down to confirm the header stays visible