Freezing Panes in Large Excel Files
Working with long or wide Excel spreadsheets can cause problems when having to remember each row or column’s title. Using the Lock or Freeze Panes option, you can avoid having to scroll back to see what each section means.
For step-by-step instructions on how to freeze panes in Excel spreadsheets, visit http://helpdesk.etown.edu/help/freezing_panes.