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.

calc-column-split

 

Row and Column Split Together

 

calc-split-animation

Next Topic  Zoom In and Out in Calc.

SEE ALSO:  Format Cells In LibreOffice Calc

Next Chapter  Formatting Cells


Looking for something else?

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


Related

Support Us


Be an expert on LibreOffice.

Small and quality tutorials. Delivered. Thrice a week.


6 thoughts on “Split a Worksheet View – LibreOffice Calc

          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.

Back to top