Split a Worksheet View – LibreOffice Calc

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.

SEE ALSO:  Create, Save, Open and Close a Workbook in LibreOffice 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

IT professional by profession and founder of libreofficehelp.com. Loving Linux and other technologies since 2002. I believe in open source and its philosophy. Follow me on Twitter or email me.

6 thoughts to “Split a Worksheet View – LibreOffice Calc”

    1. You can use ALT+TAB to switch between windows. If you are using Linux/Ubuntu and if same app are grouped in ALT+TAB: Then you can use ALT+TAB then ALT+~.

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

            Thank you!
            Paul

Leave a Reply

Your email address will not be published. Required fields are marked *

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