Freeze the Top Row in Excel to Keep it in View While Scrolling
You’ve probably seen that when working with large Excel spreadsheets headings located at the top row disappear if you scroll down beyond the rows shown onscreen, and making it a little inconvenient to track where you are on a spreadsheet.
Thankfully, Excel has a little nifty feature (officially known as “Freeze Panes”) to help you lock the top row to keep headings visible. Locking the top row is fairly simple:
To carry out this task in Excel 2007 and later, go to the View tab, Windows Group, and then click Freeze panes. Select “Freeze Top Row” from the submenu. And now if you scroll down through the worksheet, the first row will stay on the screen.
And now if you scroll down through the worksheet, the first row will stay on the screen.
*Freeze Panes feature is available in Excel 2007, 2010 and 2013 under the view tab.