Let’s say you have a number of rows of data, and you need to be able to scroll or search up and down them, but whenever you do, you lose sight of the headings.
These instructions work for Calc in both OpenOffice.org AND NeoOffice.
In order to freeze the header rows so that they don’t move and you can scroll up and down, simply click on the first cell in the row immediately below the row(s) you want to freeze. In this example, I would click on cell A2 in row 2, as I want to freeze the header row – row 1.
From the menu, select Window >> Freeze
You will then see that you can scroll up and down, but the header row will remain where it is.
In the example below, I have scrolled down to show Row 40. Rows 2-39 are hidden, but you can still see the header row (row 1).
Unfreeze / Unlock
To unfreeze, just select Window >> Freeze (you will notice that there is a tick next to Freeze – clicking on this will remove it).
Freeze / Lock Columns and Cells
You can use this method to freeze both columns and rows.
For example, let’s say you want Row 1, and Column A to be frozen.
Click on cell B2 (one row immediately below the rows to be frozen, and one column immediately to the right of the column to be frozen).
Again, from the menu select Window >> Freeze
And you will notice that the first column (A) and the first Row (1) do not move, allowing you to scroll up and down, left and right.
To unfreeze, simple select Window >> Freeze
The tick will be removed, and your spreadsheet will return to normal.