How to Use the Freeze Pane Command in Excel to Create Static Headings

1. Open a spreadsheet file.
2. To freeze the top horizontal pane, select the row below where you want the split to appear.
3. To freeze the left vertical pane, select the column to the right of where you want the split to appear.
4. To freeze both the upper and left panes, click the cell below and to the right of where you want the split to appear.
5. Open the Window menu and select Freeze Panes. When you scroll through the worksheet, the area you selected remains on the screen.