Freezing a row and a column
-
Click into the cell that is immediately below the row you want frozen and immediately to the right of the column you want frozen.
-
Select Window > Freeze.
You will see two lines appear
on the screen, a horizontal line above this cell and a vertical
line to the left of this cell. Now as you scroll around the
screen everything above and to the left of these lines will
remain in view.