Freeze Pane in Calc Spreadsheet

Using Freezing Panes in Calc-

Whenever you’re working with a lot of data, it can be difficult to compare information in your spreadsheet. The Calc Freeze Panes tool allows you to lock your column or row headings so that, when you scroll down or over to view the rest of your sheet, the first column or top row remain on the screen.

Freeze First column or Row: To Freeze the first column or Row executes the following steps.

Step 1: Go to View Menu-->Select Freeze Cells-->Freeze First column or Freeze First Row.

Step 2: Right click above the row or column and choose Freeze Rows and Columns.

Unfreeze Panes: To unlock all rows and column, execute the following steps.

Go to View Menu-->select Freeze Rows and column.