Hi :) Errr, if you click on cell c6 and try freeze-window then Columns A and B would be frozen as well as the first 5 rows.
However it is good to hear that you found the best way to suit your needs :) Regards from Tom :) On 7 March 2014 19:08, John R. Sowden <jsow...@americansentry.net> wrote: > On 03/07/2014 04:09 AM, Cley Faye wrote: >> >> 2014-03-06 22:49 GMT+01:00 John R. Sowden <jsow...@americansentry.net>: >> >>> On 03/06/2014 01:34 PM, Brian Barker wrote: >>> >>>> At 13:20 06/03/2014 -0800, John R. Sowden wrote: >>>> >>>>> I have a calc sheet about 600 lines long with data at the top that I >>>>> would like to see while I an using the data at, say line 400. Is it >>>>> possible to open a second window showing the data at the top while >>>>> editing >>>>> the data at lower lines? >>>>> >>>> It's easier than that. >>>> >>>> o Click in the row header at the left to select the first row of the >>>> general data - the uppermost one that you do *not* want to keep visible. >>>> o Go to Window | Freeze. >>>> >>>> The material at the top will now remain visible whilst you scroll down >>>> the rest. >>>> >>>> I trust this helps. >>>> >>>> Brian Barker >>>> >>>> >>>> you trust well, I should have thought of that >>> >>> >> To be exhaustive, it IS possible to open a second window on the same calc >> sheet. In the same Window menu, you have a "New window" option. It will >> open a second view that move/scroll independantly. You can then see >> multiple page of the same document, for example if you have a page with >> all >> the graphics, and a page with all the data. >> > THAT is what I was attempting to do. The problem with freezing the upper > text, in my case, is the upper text was way off to the right, and the text > to be edited in the lower lines was way off to the left. > > Thank you all, > > John > > > -- > To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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
