How to maintain (top) row visible while scrolling?

Question

I did it once, but cannot find out how any more:

how to keep the top row of my LibreOffice Calc sheet visible when scrolling?

(Intuitively it should be either in view or format, at best in right-click menu, but I can't see anything related ... )

I've not understood the point of "SuperUser" so far. I wish there would me more thrust with opening a LibreOffice SE ... — neydroydrec, Aug 10 '11 at 13:51
Questions about software that runs on \*nix are [on-topic here](http://unix.stackexchange.com/faq#questions) — Michael Mrozek, Aug 10 '11 at 14:04
@Benjamin, there is now http://ask.libreoffice.org but it has nothing to do with Stack Exchange. — Cristian Ciupitu, Jun 05 '14 at 23:13
While I agree that this question is on-topic here, it might reach more people on Super User given the fact LibreOffice also runs on other operating systems. — Cristian Ciupitu, Jun 05 '14 at 23:15
While the answer has been given, it may be worth noting that there is an enhancement request at https://bugs.documentfoundation.org/show_bug.cgi?id=90961 to make this easier to find and more intuitive. — mivk, Apr 30 '15 at 13:13

score 66 · Accepted Answer · edited Aug 10 '11 at 14:03

66

You can achieve this by either splitting or freezing the spreadsheet. These two options are slightly different, the main difference being that splitting adds a second scrollbar, viewing the same sheet from two contiguous windows as it were.

How to split the spreadsheet

Using the mouse pointer:

Drag the little black horizontal segment that is above the scroll bar, while dragging you will see an horizontal line moving;
Drop the line just under the selection you want to maintain fixed.

Drag:

drag

and drop:

drop

Using menus:

Select the row below the line where you want the split to appear;
Select Window > Split

How to freeze the spreadsheet

Select the row below the row you want to freeze;
Select Window > Freeze

edited Aug 10 '11 at 14:03

neydroydrec

3,777
8
32
42

answered Aug 10 '11 at 11:26

enzotib

50,671
14
120
105

1

Thanks. I'm adding some pics to make it more visual. Do you know how to do that from menus? – neydroydrec Aug 10 '11 at 11:50
@Benjamin: Position the cursor on first free row and select the menu item Windows->Freeze – enzotib Aug 10 '11 at 12:44
2

Hey actually I found out that dragging the line is splitting the sheet, while the other option is freezing it. I'm going to edit the answer to give the different options if you don't have any objections. – neydroydrec Aug 10 '11 at 13:50
@Benjamin: make your editing freely, if this improves the answer. I suggest to take your credit by starting with "Added by Benjamin:" or similar. – enzotib Aug 10 '11 at 13:52
I don't worry about credits :) thanks. – neydroydrec Aug 10 '11 at 13:59
@Benjamin You could also just add your own answer, but if the OP is ok with you merging your answer into this one I guess that works – Michael Mrozek Aug 10 '11 at 14:03
Thanks Michael, i'll keep it simple. The point is that it can help people. – neydroydrec Aug 10 '11 at 14:30
For `gnumeric` users, the freezing feature is available through [View > Freeze Panes](http://www.hep.by/gnu/gnumeric/View-Menu.shtml). – Skippy le Grand Gourou Nov 10 '15 at 13:30
3

If you're using LibreOffice 5 (or at least 5.1.5.2 on OS X), the freezing options are now under `View > Freeze Rows and Columns` and `View > Split Window` – Ionoclast Brigham Sep 29 '16 at 19:32
Also View > Freeze Cells > Freeze First Row – qwr Aug 10 '22 at 00:26

How to maintain (top) row visible while scrolling?

1 Answers1

How to split the spreadsheet

Using the mouse pointer:

Using menus:

How to freeze the spreadsheet