Re: [libreoffice-users] Would somebody be able to help a newbe to LibreOffice.

** Reply to message from John Meyer <johnmeyer@pueblocomputing.com> 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: users+unsubscribe@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