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.
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.
Row and Column Split Together
Next Topic Zoom In and Out in Calc.
Looking for something else?
Read our complete tutorial index of Calc, Writer, Impress and Draw.
What keyboard shortcut allows you to switch between windows? Having to click is a pain!
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+~.
No, this is not the answer I am looking for. In the SPLIT WINDOW view of Excel, how do you switch between split windows?
Unfortunately, this feature is not available in LibreOffice Calc. You have to use mouse.
Thank you. Do you think one could write a VBA script to accomplish this task, or is it too cumbersome?
Thank you!
Paul
Awesome, thanks a lot for your tutorials !