Page 3 of 28PREVNEXT

Audio course: So that's how! Great Excel features

Freeze titles in their own pane

Callout 1 Click Freeze Panes on the Window menu.
Callout 2 Column titles are divided from the rest of the worksheet by a horizontal line.

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.

Page 3 of 28PREVNEXT