/

How to Freeze and Unfreeze Rows columns and ranges in Calc

5390 views
13

This tutorial would explain 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 the rest of the section of the spreadsheet can move using scroll bars. Here’s how you can do it in LibreOffice Calc:

Freeze

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 the rest of the sheet’s content can move.

Freeze Row and Columns - After

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

Unfreeze

To unfreeze, use the option Unfreeze from the menu.

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

  • Select/click any of the cells 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.


Looking for something else?

Read our complete tutorial index of Calc, Writer, Impress and Draw.


Join our Telegram channel and stay informed on the move.

Related


arindam

Creator of libreofficehelp.com. The aim is to help as many people with easy-to-understand tutorials and no BS. Follow us using social channels or send us an email.

Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

13 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
John

Doesn’t work.
Version: 5.1.6.2
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial2

Spaz

Yes, this command doesn’t seem to work like I need it too.I selected the entire “D” column of my embedded images, and applied the “Freeze” command. Each image I try, to embed; that image to “stay put” in the cell that I assigned to it. But the image(s) will move out of the cell(s) prematurely after preforming such tasks (not just this task itself) as increasing the height of a row. Which may or may not be the cell that I would be working in, at the moment I notice the unwanted changes.

The point being, this behavior is undesirable. I plain and simply want each image to STOP MOVING OUT OF THE ORIGINAL PLACE I GAVE TOO IT IN THE FIRST PLACE.

Also the “Anchor” command doesn’t seem to be making any difference either.

Is there something that I’m doing incorrectly? Another command and/or setting I need to know?
I really also didn’t find any solutions at:

https://ask.libreoffice.org/en/question/45444/rows-height-automatic-adjustment-above-images-anchored-images-do-not-scroll-down/

or

https://bugs.documentfoundation.org/buglist.cgi?quicksearch=rows+height+automatic+adjustment+above+images

Any helping my ignorance would be appreciated, because I was trained to use much older software like Lotus 1-2-3 many years ago ….
Thanks

Chuck Holt

I was successfully able to freeze columns and rows, but I’m not finding the ‘Unfreeze’ option in any menu. I’ve tried in Excel 2007 and ODS formats.

Version: 6.1.1.2 (x64)
Windows 7
Locale: en-US

Chuck Holt

As stated in my initial post, I’m using LibreOffice Calc version: 6.1.1.2 I considered that the problem I was having might be related to the file format in which I was trying to save the spreadsheets, so I tried the two different options mentioned as file formats — using LibreOffice Calc. I do not have Excel installed on my computer.

What I’m trying to find is “Where Is The UNFREEZE Item In The Menus”

Please read the post before replying.

Thank you,

Chuck Holt

I found an answer on http://ask.libreoffice.org. Selecting the frozen row or column and then clicking ‘Freeze’ again will un-freeze the selection. There is no ‘UnFreeze’ in the version that I have

See: https://ask.libreoffice.org/en/question/151953/how-do-i-unfreeze-row-and-column/

Faqir Hussain

Pressing Freeze again does not unfreeze first row

elviejito

I clicked on “freeze rows and columns” and that got rid of all freezing. Then I clicked on “Freeze First Row”, which is what I actually wanted

Leibnitz Germanio

The freeze command is not working in my installation. I tried it many times with no luck. Someone can help?

Version: 7.0.3.1 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: pt-BR (pt_BR); Interface: pt-BR
Calc: CL

13
0
Would love your thoughts, please comment.x