Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

By instead of "A,B,C,..." I mean the column letters you see in this screenshot:enter image description here

I am using LibreOffice 4.0.2 that I installed from the tarball of debian packages that I downloaded from the libreoffice website. If it is relevant I am running 32 bit 12.10.

share|improve this question
up vote 5 down vote accepted
  • You can split the header.

Drag the little black horizontal segment that is above the scroll bar, while dragging you will see an horizontal line moving. Or: Window->Split (as seen in the 2nd image). The split will happen above the cursor. This is the end result:

enter image description here

  • You can also use freeze. Window -> Freeze.

enter image description here

And this is the end result (3 rows this time):

enter image description here

The main difference between the 2 is that split adds a second scroll bar so you have 2 windows. Freeze also works on 1 or more columns.

share|improve this answer

You have to see the column names A,B,c... , it cannot be otherwise (I think) but you can add titles in a new line that you'll fix when scrolling down.

Add a new line and fill in your titles.
Then, in your example select cell B2 (the one just under your title line; B1 if you do not wish to keep the first column when you scroll) and select Window->Freeze. Done.

You can also split it (Window->Split) if you want to specify the exact place you want to keep rather than the first lines/columns.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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