We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

how to do a horizontal screen split

asked 2018-11-04 02:31:44 +0200

mtburkle gravatar image

Hi, I've been a happy Open Office user til recently. Works fine if I am mostly inactive - looking up stuff. Keeps crashing when I get active with data input, color formats, etc. I just installed LibreOffice and was thrilled to see the dates converted just fine - major problem with Excel. Mostly looks great.
Question: How do I do a horizontal screen split on a spreadsheet? It obviously isn't under the 'Window' tab where I used to find it. Using Libre version Thanks, Marilyn

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-11-04 12:11:39 +0200

Lupp gravatar image

updated 2018-11-04 12:35:54 +0200

At the right end of the horizontal scrollbar you find a tiny element shown as a short vertical line. You can drag it with the mouse (initially only to the left, later right/left). That's the splitter.

There is a respective splitter for horizontal splitting at the top end of the vertical scrollbar.

A sheet for which already a 'Freeze' is set has the conflicting splitter(s) disabled. First splitting and subsequently trying to set a freeze may result in inconsistencies.

See also my comment concerning "Split + Freeze" on the answer by @Mark McLean .

(Having created a split I do not know a way in the UI to cross the border line for selections without using the mouse. Somebody knows?)

edit flag offensive delete link more


Thanks! I wouldn't have found that for a long time. Marilyn

mtburkle gravatar imagemtburkle ( 2018-11-05 08:18:38 +0200 )edit

You may consider to mark the answer as accepted clicking the checkmark. It may help other users to quickly find useful answers.

Lupp gravatar imageLupp ( 2018-11-05 11:17:25 +0200 )edit

I was not aware of the horizontal / vertical splitters but now I am! Thanks! :)

MykeC gravatar imageMykeC ( 2019-02-10 20:43:32 +0200 )edit

answered 2018-11-04 02:53:42 +0200

Select Cell...View/Freeze Rows Columns.

edit flag offensive delete link more



That's not exaxtly a split in the traditional meaning of the term.
By the way: Splitting and freezing cannot be used at the same time. Starting with the splitters and trying a frreeze subsequently results in inconsistencies in the view.

Lupp gravatar imageLupp ( 2018-11-04 12:09:28 +0200 )edit

Ah, new tool or option to me, didn't know of split, thought they meant freeze. Thanks again Lupp.

Mark McLean gravatar imageMark McLean ( 2018-11-04 14:40:46 +0200 )edit

No matter.
The horizontal split was already a feature in StarOffice 5.2 of 2000 (at latest).
Horizontal and vertcal split are "legacy". They were already done the same way in LibreOffice 3.3 (the very first version under the new brand).
But I didn't use it much and had actually forgotten about it when a question in this forum some time ago brought back faint memories. AOO and LibO still even have the same bug concerning the "split first, then freeze" inconsistency.

Lupp gravatar imageLupp ( 2018-11-04 18:13:11 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-11-04 02:31:44 +0200

Seen: 2,501 times

Last updated: Nov 04 '18