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: AdministratorSelect 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
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
Read Online Microsoft Excel Job Interview Questions And Answers
Top Microsoft Excel Questions
☺ | What are Excel Spreadsheet Number Formats? |
☺ | Using Excel is there a way to close all open Excel files at once instead of closing them one at a time? |
☺ | How do I combine different chart types into my Excel spreadsheet? |
☺ | In MS Access, the long and short date option does not show 4 digit years. How do I achieve the mm/dd/yyyy format? |
☺ | How to Change the Sheet Tab Color of Excel Spreadsheets? |
Top Application Program Categories
☺ | AutoCAD Interview Questions. |
☺ | Microsoft Office Interview Questions. |
☺ | Microsoft Outlook Interview Questions. |
☺ | Microsoft Excel Interview Questions. |
☺ | WPF Interview Questions. |