Freeze Columns, Rows in Spreadsheet

How to freeze columns, rows in Openoffice spreadsheet?

Explanation

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.

Related Topics