Split a Worksheet View – LibreOffice Calc

4492 views
6

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

If you are working in a large worksheet, scrolling is sometimes difficult for your productivity. This is where 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.

calc-sp-1

Click and hold, then drag it down.

Then you have the same sheet with two views. If whatever changes you do in any of the view, is reflected in the other view.

Split Columns

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

calc-column-split

 

Row and Column Split Together

 

calc-split-animation

Next Topic  Zoom In and Out in Calc.

Next Chapter  Formatting Cells


Looking for something else?

Read our complete tutorial index of Calc, Writer, Impress and Draw.


Join our Telegram channel and stay informed on the move.

Related


arindam

Creator of libreofficehelp.com. The aim is to help as many people with easy-to-understand tutorials and no BS. Follow us using social channels or send us an email.

Subscribe
Notify of
guest

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

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

6
0
Would love your thoughts, please comment.x