** Reply to message from John Meyer <[email protected]> on Thu, 07 Nov 2013 18:29:14 -0700
To be more specific: If you only want to keep the column labels visible, put the cursor in the far left column (before column A) on row 2 then go to the Window menu item and select freeze. All column headers in row 1 will stay visible as you scroll everything below them. If you don't go to the far left column it will still work, but make a darker line to the left of the column that you selected. I don't know any way to keep just one or several columns frozen and scroll the others. HTH, Cliff > _W_indow->_F_reeze > > Place cursor underneath row you want to stay still. > > HTH > > On 11/7/2013 6:21 PM, Bill Gassner wrote: > > Hi All, > > > > Thanks for responding to my call for help. Here is the situation: I > > have a LibreOffice Cal sheet with rows 1-34 with text. Rows 35-40 with > > titles above 7 colums. > > Rows 41-100 is entries. > > > > I would like to modify document so that rows 35-40 stay fixed when I > > scroll down to say column 100. > > > > This way the titles of the seven columns would always be visible. I > > know this can be done. > > > > What formula would I use and where would I put that? > > > > Many thanks in advance > > > > Bill -- To unsubscribe e-mail to: [email protected] 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
