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 ... )

  • 2
    Seems like this should be migrated to SuperUser. – wfaulk Aug 10 '11 at 13:29
  • I've not understood the point of "SuperUser" so far. I wish there would me more thrust with opening a LibreOffice SE ... – Benjamin Aug 10 '11 at 13:51
  • 4
    Questions about software that runs on *nix are on-topic here – Michael Mrozek Aug 10 '11 at 14:04
  • @Benjamin, there is now ask.libreoffice.org but it has nothing to do with Stack Exchange. – Cristian Ciupitu Jun 5 '14 at 23:13
  • 1
    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 5 '14 at 23:15

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:

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



and drop:


Using menus:

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

How to freeze the spreadsheet

  1. Select the row below the row you want to freeze;
  2. Select Window > Freeze
  • 1
    Thanks. I'm adding some pics to make it more visual. Do you know how to do that from menus? – Benjamin 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. – Benjamin 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
  • 1
    If you're using LibreOffice 5 (or at least 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

protected by Community Jun 17 '13 at 14:18

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.