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



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

Answer / Ramesh Mishra

To freeze the first row (title) in Excel, follow these steps:
1. Click on the column letter at the top of the title row.
2. Click on the "View" tab in the ribbon.
3. In the "Window Group", click on the arrow next to "Freeze Panes".
4. Choose "Freeze Panes" or "Freeze Panes Above`1`" (replace `1` with the row number of your title row).

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How do I make a spreadsheet fit the page?

1 Answers  


What are the basic formulas in excel?

1 Answers  


How do you append a query?

1 Answers  


Where is data validation in excel?

1 Answers  


Can I download microsoft excel for free?

1 Answers  


What is if then statement in excel?

1 Answers  


How do I limit rows and columns in excel?

1 Answers  


What is the benefit of vlookup?

1 Answers  


What is ms excel explain?

1 Answers  


Is there an ifs function in excel?

1 Answers  


Specify the order of operations used for evaluating formulas in excel.

1 Answers  


What is an array formula?

1 Answers  


Categories