same calc sheet in 2 windows?

users
#1

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?

John

#2

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

#3

you trust well, I should have thought of that

thanks, John

#4

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

#5

Hello John,
Selecting "Window->Fix" (translation attempt from German version! Menu item left of "Help")
You can select a cell at which you can fix the display. Anything above and to the left of
this cell keeps being displayed when scrolling. I use this feature usually for displaying
header-lines and (usually) the first few columns of a sheet.
Regards
H.S.

#6

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

#7

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

#8

Hi :slight_smile:
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 :slight_smile:
Regards from
Tom :slight_smile: