Ask Your Question

Fixed Head Row [closed]

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

Huskey 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 +0100

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 +0100 )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 +0100 )edit

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

libreofficeASK gravatar image

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

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 +0100 )edit

ok , thanks

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

Question Tools

1 follower


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

Seen: 8,931 times

Last updated: Oct 02 '15