Freezing the Panes in Excel
Now for the easy part:
- Click on cell D4
- Choose Window > Freeze Panes from the menu
A vertical black line will appear between columns C and D and a horizontal line between rows 3 and 4.
Rows 1 to 3 and columns A to C are the frozen areas of the screen.