Press "Enter" to skip to content

Split a Worksheet View – LibreOffice Calc

Last updated on May 4, 2020

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:  Data Validation Using Double Dependent Dropdown List - 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.


Related


6 Comments

  1. Physics Paul Physics Paul September 10, 2018

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

    • arindam arindam Post author | September 22, 2018

      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+~.

      • Paul Paul September 22, 2018

        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 Arindam September 22, 2018

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

          • Paul Paul September 22, 2018

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

            Thank you!
            Paul

  2. Franck Franck March 4, 2020

    Awesome, thanks a lot for your tutorials !

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.