If you have large and long workbooks or Excel spreadsheets, being able to see the column or row labels is extremely important.  Here is a quick way to freeze the labels in place for fast and easy viewing of your data.

5

Click on View on the Ribbon and select Freeze Panes.

4

Now click Freeze Top Row.  If you want to Freeze other rows as well just highlight them before choosing Freeze Panes.

6

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.

7