How to freeze columns, rows in Openoffice spreadsheet?
Freeze option is used to keep the selected set of rows/columns in static position. Follow the steps below to use the freeze option.
Step 1: Click on the cell to freeze the rows/columns above the selected cell which will be in static position, when you scroll up/down the spreadsheet.
Step 2: Select Window → Freeze
>Step 3: After you click freeze, the column / row which you have selected will remain static when you scroll up or down in the spreadsheet.
Unfreeze Rows/Columns: To unfreeze the selected row / column, select Window → Freeze. The frozen cell row/column will get unfrozen.