Lock header rows and ID columns while scrolling: Freeze Top Row, Freeze First Column, and Freeze Panes (Alt+W+F+F).
“Freeze Panes, Split Windows & Managing 10,000+ Row Views” is part of Level 1: Excel Fundamentals — Basic to Intermediate. Free preview lessons are open to everyone; the remaining lessons are for enrolled learners.