If you have long rows or columns of data that require scrolling,
you can lock a row or column as a heading to display as you scroll
through the rest of the data.
- Select the row below or the column to the right of the
row or column that you want to freeze.
- To freeze horizontally, select the row below the row that
you want to freeze.
- To freeze vertically, select the column to the right of the
column that you want to freeze.
- To freeze both horizontally and vertically, select the cell
that is below the row and to the right of the column that you want
to freeze.
- Click . To deactivate, click again.
Tip: To select a whole row or column, click its
number or letter.