Ask Your Question

Freezing Headings in Calc [closed]

asked 2013-07-28 18:36:22 +0100

briansmith gravatar image

Using Libre 4.0.2. Want to freeze headings. The help indicates there is a menu structure but I cannot find it.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-04 15:44:47.062106

2 Answers

Sort by » oldest newest most voted

answered 2013-07-29 03:15:39 +0100

ROSt52 gravatar image

updated 2013-07-29 16:28:16 +0100

@dogluvver - The way I understand your question, my two screen shots could give you the answer

image description

If you place the cursor in the red marked cell, select windows > freeze you will always see row 1 when you scroll down

image description

If you place the cursor in the red cell and and select windows > freeze - scroll down and you will always see the first row with all headings - scroll right and you will always see the first column and the headings

When you move the cursor insertion point down and select windows > freeze you will see more rows. The equivalent is possible when you move the insertion point to the right.

You might want to post an enhancement request for better explanations in the Help file and help wiki. For this go to

If you should place an enhancement request it would be nice if you post the link here.

edit flag offensive delete link more


Thanks for the info. I just removed Libre Office to download the latest version. Am having problems with the desktop integration (have posted on this separately). When that is resolved, I will return to this.

briansmith gravatar imagebriansmith ( 2013-07-29 18:08:48 +0100 )edit

answered 2013-07-28 19:00:53 +0100

razon_22 gravatar image

At the top of the main Calc window, click Window, then Freeze.

edit flag offensive delete link more


If the word Window was there, I would do exactly that but there are no words - just icons, and nothing that I can see relates to Window

briansmith gravatar imagebriansmith ( 2013-07-28 20:23:28 +0100 )edit

Is it possible to post a screenshot of the top of your screen? I don't think it's possible to turn off the menu bar, so maybe it's just off the screen a little. Do you see the Minimize, Maximize and Close buttons at the top right of the screen?

razon_22 gravatar imagerazon_22 ( 2013-07-29 02:39:57 +0100 )edit

Question Tools



Asked: 2013-07-28 18:36:22 +0100

Seen: 3,390 times

Last updated: Jul 29 '13