Super User is a question and answer site for computer enthusiasts and power users. 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

How do I make a whole row follow wherever I am in the Calc document when I scroll down/up?

I'm looking for something that keeps a row from moving, or to make it stay put.

This is so that when I want to see other rows, this one locked row will stay in place and allow me to refer back to it on screen without having to scroll all the way back up to the top of the document.


enter image description here

Scrolled down:

enter image description here

Further scrolled down:

enter image description here

You can see the row with the yellow background, (CD-Nr.|Title|Genre|Lang|CD) is following me as I scroll down.

How is this done?

share|improve this question
up vote 4 down vote accepted

I think you're talking about "Freezing a Row"

alt text

more details in The Open Office Wiki

share|improve this answer
not working for me here. – StampedeXV Aug 31 '09 at 11:50
It's freeze in Excel and as the OpenOffice UI is based on Microsoft Office it should be the same. – ChrisF Aug 31 '09 at 11:55
@StampedeXV I also had trouble using 'Freeze' at first. Remember to select a cell, not a whole row, to the right of (in the case of column) or directly below (in the case of a row) the area you want to freeze. Look closely to how it's being done in the picture. – jweede Aug 31 '09 at 12:00
ah, problem was with "one below" and only selecting the cell. Always trying to fixate a whole line/column. Thank you - did not now that also. – StampedeXV Aug 31 '09 at 12:09
cheers! That did it! Much appreciated! – Grumpy ol' bear Aug 31 '09 at 13:13

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .