We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Fixed Head Row [closed]

asked 2013-03-18 22:30:30 +0200

Huskey gravatar image

updated 2021-06-11 08:15:31 +0200

Alex Kemp gravatar image


Ages ago I've created a Calc document with a fixed head row, i.e. when scrolling down the page, the first row is always there as title. But unfortunately I can't remember how I did it and I can't find any explanation in the manual. Maybe it's just not my day. Could somebody please give me a hint? Many thanks.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-19 17:02:16.196632

2 Answers

Sort by » oldest newest most voted

answered 2013-03-18 22:42:00 +0200

razon_22 gravatar image

Just click on the row header for row 2, then select Window > Freeze. The first row will always show.

edit flag offensive delete link more


Cool. Many thanks.

Huskey gravatar imageHuskey ( 2013-03-18 22:54:07 +0200 )edit

This is really bad UX, why under 'Window' and not 'Format' or 'Edit'? Why click on the 2nd row when it's the first row that is being frozen? It should be available in the context menu of the row, so that if you right click on a row you can freeze up to and including that row, and so you can unfreeze an already frozen section by right clicking on any of the rows.

EoghanM gravatar imageEoghanM ( 2013-07-09 08:40:03 +0200 )edit

answered 2015-10-02 15:22:38 +0200

libreofficeASK gravatar image

updated 2015-10-02 15:23:36 +0200

This has changed in LO 5.1. Not sure where the option can be found in the latest builds.

It's still under Window in LO though, just FYI.

I agree that window is the last place I expected to find this. So maybe the 5.1 change is a change for the better. Would be great if someone more knowledgable could elaborate where it went.

edit flag offensive delete link more


it is still available but you will have to manually add it to the menu by customising it. You will find the the item called "freeze rows and columns", in the view category And yes, It would be nice to know why it was removed.

timsoft gravatar imagetimsoft ( 2016-02-16 22:09:22 +0200 )edit

ok , thanks

lnt123 gravatar imagelnt123 ( 2019-06-25 02:10:06 +0200 )edit

Question Tools

1 follower


Asked: 2013-03-18 22:30:30 +0200

Seen: 9,161 times

Last updated: Oct 02 '15