How to Freeze and Unfreeze Rows columns and ranges in Calc

By | December 8, 2018

This tutorial would explain on how to Freeze, Unfreeze rows and columns and ranges in LibreOffice calc.

There are different display devices, monitors available with various sizes and resolutions. When you are working with a spreadsheet and doing data analysis, it is often needed to freeze certain rows and columns while rest of the section of the spreadsheet can move using scroll bars. Here’s how you can do it in LibreOffice Calc:


Select a cell. (In this example C6).

Freeze Row and Columns - Before

Go to menu and select “Freeze cells -> Freeze rows and columns”

Freeze Cells - Options in Calc Menu
Calc would freeze all the sections left and top of the selection which is C6 in this example. So, if you scroll vertically or horizontally the range A1:B5 would remain fixed while rest of the sheet’s content can move.

SEE ALSO:  SUMPRODUCT Function with Examples in LibreOffice Calc

Freeze Row and Columns - After

Tip: You can also quickly use option Freeze first row and first column to freeze first row and column respectively.


To unfreeze, use the option Unfreeze from menu.

There is no unfreeze option in the menu of LibreOffice Calc. To unfreeze follow below steps:

  • Select/click any of the cell inside the frozen row/column range.
  • Go to Menu and click on View > Freeze Rows and Columns again.

This will remove all ‘freeze’ from the Calc sheet.

For the latest tutorials, news and how-to guides, follow on Twitter, Facebook, and subscribe to our YouTube channel and email updates via below form.

Join 568 other subscribers.