Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

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
add comment

2 Answers 2

up vote 4 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
add comment

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.
Best,

share|improve this answer
add comment

Your Answer

 
discard

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.