Re: [libreoffice-users] same calc sheet in 2 windows?

On Thu, Mar 6, 2014 at 4:20 PM, John R. Sowden
<jsowden@americansentry.net>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?

Brian has already offered one solution. That solution locks rows in the top
portion of the sreadsheet so they cannot be scrolled.

If however you want to be able to scroll both the top rows and the bottom
rows there is another possibility...

- Open your spreadsheet
- place your mouse at the right edge of the spreadsheet just above the
vertical scroll bar, over a small horizontal black line just to the right
of the column letters. The pointer will change to a two headed arrow
pointing up and down
- while the two headed arrow is displayed click the mouse and drag down,
the spreadsheet will be separated into a top and bottom half and both can
be scrolled independently

LibreOffice's instructions for this can be found by opening Help and using
"split window" as the search term in Help's Find tab. Select "Split" or
"Window" from the list of found topics. "Split" describes doing this with
the mouse. "Window" describes doing it using the Window menu's "Split"
command.

-Alan

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