Microsoft Excel Interview Question:

How do I lock in my Title Row and keep it visible while I scroll down to see the rest of my data?

Submitted by: Administrator

Select the row below the section that you want to freeze. Then, on the Ribbon's View tab, click Freeze Panes, and click the Freeze Panes option.
Lock the title row in Excel 2003, and earlier versions:

Assuming title row is 1, select cell A2, then choose Window > Freeze Panes
Submitted by: Administrator