Split a Worksheet View in LibreOffice Calc

17456 views
9

Here’s how you can split the worksheet view vertically and horizontally in LibreOffice Calc.

LibreOffice Calc provides a way to view a Calc spreadsheet in a split manner.

Scrolling is sometimes difficult for your productivity if you are working on a large worksheet. This is where the split is useful.

Split Rows

To create a split view, click on the small icon (see below image) at the right-top section of Calc.

LibreOffice Calc Split rows handle and cursor
LibreOffice Calc Split rows handle and cursor

You should see the mouse pointer changes with a vertical two-way arrow.

Click and hold, then drag it down.

Then you have the same sheet with two views. Now, If you type something or change any of the views, the same is reflected in the other view.

Split Columns

Similarly, you can split the columns as well. Click the below icon near the bottom-right section in the Calc.

LibreOffice Calc Split columns handle and cursor
LibreOffice Calc Split columns handle and cursor

You should see the mouse pointer changes with a horizontal two-way arrow.

Click and hold, then drag it down.

Row and Column Split Together

Here’s a demo where both rows and columns split work together.

calc-split-animation

Next Topic  Zoom In and Out in Calc.

Next Chapter  Formatting Cells

Join our Telegram channel and stay informed on the move.

Creator of libreofficehelp.com. The aim is to help as many people as possible with easy-to-understand tutorials. Connect with me via Telegram, Twitter, LinkedIn, or send us an email.

Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

9 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Physics Paul

What keyboard shortcut allows you to switch between windows? Having to click is a pain!

Paul

No, this is not the answer I am looking for. In the SPLIT WINDOW view of Excel, how do you switch between split windows?

Arindam

Unfortunately, this feature is not available in LibreOffice Calc. You have to use mouse.

Paul

Thank you. Do you think one could write a VBA script to accomplish this task, or is it too cumbersome?

Thank you!
Paul

Franck

Awesome, thanks a lot for your tutorials !

Akshith

can you pls tell the above picture reefers to which version

libro oofic e.png
Akshith

OK BRO..