Open Office Calc (Spreadsheet) Freeze column labels
(This blog was written for versions of OpenOffice up to Version 3.4.0)
If working in a spreadsheet with more rows of information than can be viewed on one sheet, it is possible to keep the headings in view as you scroll down the sheet to view or enter more rows of information.
Enter the headings of the columns in Row 1 Columns A, B, C etc. (EG – Date, Day, Event, etc) These are called labels.
Enter some detail in Row 2. Select Cell A2 > go to Window on the Menu Bar and from the Drop Down Menu > Click Freeze (this will place a tick beside the word Freeze)
From now on however many rows of the spreadsheet are used the 'labels' will remain visible at the top of the sheets to be a guide for reading or entering more information in the sheet irrespective of the number of rows used in the spreadsheet.