Howtogeek shows you how to freeze and unfreeze rows and columns in Microsoft Excel 2013    

If you are working on a large spreadsheet where all the rows and columns of data don’t fit on the screen, it would be helpful to be able to keep the heading rows and columns stationary so you can scroll through the data.

You can freeze rows and columns in your spreadsheet. To do so, select the cell above which and to the left of which you want to freeze the columns and rows.

  How to Freeze and Unfreeze Rows and Columns in Excel 2013