If you’re like most people, you probably use Excel to track and analyze data. But if you want to make it easier for yourself to read data, you can use row labels. Row labels are a great way to group data together and make it easier for yourself to read. They work just like other column labels, but they have a row number instead of a column number. So when you group data by row label, the data is organized in a specific order. To create row labels in Excel 2007, open the Data tab and click on the Row Labels button. Then select the type of label you want to create: text or image. You can also choose whether you want the label to be permanent or temporary. Once you’ve chosen the type of label, click on the OK button to create the label. The label will appear in your spreadsheet as a text field with a blue border. To remove the label from your spreadsheet, click on its icon and then select Delete from the menu that appears.
Click on View on the Ribbon and select Freeze Panes.
Now click Freeze Top Row. If you want to Freeze other rows as well just highlight them before choosing Freeze Panes.
That’s it! Now as you can see by the example, you will be able to scroll throughout the document while keeping the column or rows in place.
