This video explains how to lock or freeze columns and rows on a worksheet so that they always appear on screen when you scroll vertically or horizontally.

This tutorial will be useful if are asking the following questions:
How do I freeze rows and columns at the same time?
How do I freeze multiple rows or multiple columns?
How do I lock a row when scrolling?
How do I lock a column when scrolling?
How do I lock headers in Excel?
------------------------