Freeze the Top Row
- Click on the View tab.
- Click on Freeze Panes from the ribbon to open the features drop down list.
- Click on Freeze Top Row option in the list. .
- A black border should appear beneath row 1 in the worksheet indicating that the area above the line has been "frozen".
- Scroll down through the worksheet. If you scroll far enough, the rows below row 1 will begin disappearing while row 1 will stay on the screen.