Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

Normal:

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

1 Answer

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! –  Don Salva Aug 31 '09 at 13:13
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.