Microsoft Excel Question:
Download Job Interview Questions and Answers PDF
How do I lock in my Title Row and keep it visible while I scroll down to see the rest of my data?
Answer:
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
Lock the title row in Excel 2003, and earlier versions:
Assuming title row is 1, select cell A2, then choose Window > Freeze Panes
Download MS Excel Interview Questions And Answers
PDF