When you create a list in excel that ends up being quite large scrolling up and down can result in you not being able to see your headings. This means that the information you see might not make a lot of sense.
To correct this you can use freeze panes. Select the cell below the section you want to freeze and:
In Excel 2007 click View -> Window -> Freeze Panes
In Excel 2000 – 2003 click Window -> Freeze Panes
This function toggles on and off so to unfreeze panes use the same menu option and instead of freeze panes the option will be called unfreeze panes.
VIDEO TIP BELOW