As you fill more and more rows of a spreadsheet, the top rows move up and out of view. Therefore, if you've put titles in a row, they move up out of view too. Similarly if you've put titles in a column, they move out of view as you fill more and more columns to the right.
You can use the Freeze command to freeze particular rows, columns and ranges. When you freeze a spreadsheet, the frozen part remains visible on the screen as the rest of the spreadsheet moves out of view.
To freeze a row or several rows:
Select the rows using the row bars to the left of the row.
Select the Freeze command from the Window menu.
The frozen rows will move to the top of the screen and stay visible no matter where you are in the spreadsheet. You can freeze columns in the same way by first selecting the columns you want to freeze.
To freeze rows and columns in one go, first select the intersection of the rows and columns to be frozen. For example, suppose you want to freeze the first three rows and columns A and B, follow these steps:
Select the range A1..B3.
Select the Freeze command from the Window menu.
Note that you can exclude rows and/or columns from those that are displayed by excluding them from the selection. In the above example, if the range A2..B3 were selected instead, row 1 would not be visible.
Also note that the effects of freeze will go through to print time as well - you can use it to make sure each page has the same row and/or column repeated at the top or left side.
To turn off the freeze, select the Unfreeze command from the Window menu.
See also: