RE: [libreoffice-users] Can I lock a row so it doesn't move when scrolling?

It works similarly to Excel.

Select the cell that is just below the rows you want repeated as row headings and just to the right 
of the columns you want repeated as column headings.

On the toolbar select Window | Freeze

To change it or remove it, just select Window | Freeze (it will show as checked, this unchecks it).

You can now scroll  around and any frozen columns and rows stay in the display.

This is independent of the printing of column and row headings.  For that, you need to use the 
Format | Print Ranges | Edit dialog.


 - Dennis


-----Original Message-----
From: Steven Dayton [mailto:daytonmeister@gmail.com] 
Sent: Friday, November 23, 2012 09:19
To: users@global.libreoffice.org
Subject: [libreoffice-users] Can I lock a row so it doesn't move when scrolling?

Can I lock a row in spread sheet so it doesn't move out of view when I
scroll down in long documents. I can do this in Excel but I haven't been
able to find a way to do this in LibreOffice Calc.

I have set up the first row in the spread sheet as a column titles row and
I have over a 150 lines in the spread sheet. I would like that first row to
remain in view as I scroll down the rows. Hope that makes sense.

If there is a better way to set up column headers I welcome tips and tricks.

-- 
StevenD

So you want it fast, good, and cheap. Choose any two.

A bad day at the beach is better than a good day at work.

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted