Freezing rows and Columns in OpenOffice Calc/LibreOffice Calc

For large spreadsheets that do not fit completely in the window, it is useful to be able to freeze the row and/or column headers to better view the data.

Suppose you want to freeze first row and first column.

Initial Sheet

Initial Sheet

Select cell (B,2)

Select Cell for Freeze boundary

Select Cell for Freeze boundary

From main-menu select Window->Freeze option

Window -> Freeze option

Window -> Freeze option

that’s it…first row and first column will be frozen until you remove the check mark from the Window->Freeze option

Freezed Row and Columns

Freezed Row and Columns

Rate this post

Leave a Reply