To keep titles in sight, divide or split the worksheet by freezing the titles in their own pane. The title pane is then locked in place as you scroll through the rest of the worksheet.
You freeze panes by making a selection in the worksheet, which you'll learn how to do in the next section, and then clicking Freeze Panes on the Window menu.
You can see the result in the picture. The titles, separated from the worksheet data by a horizontal line, are still visible over the top of row 10.