1. Overview
Splitted views allow you to display different areas of the same worksheet — or even different worksheets — within a single main worksheet window. This makes it possible to monitor changes in multiple locations simultaneously, edit distant cells without scrolling, and emulate “Freeze Rows/Columns” functionality found in other spreadsheet applications.
Each worksheet can contain up to 100 splitted views, and a workbook may contain an unlimited number of such configurations. Splitting configurations are saved directly into the workbook file.
You can protect the current splitting configuration using Tools → Protect Structure.
2. Proportional Splitter
The View → Proportional Splitter option controls how views behave when the main window is resized:
- On — all views resize proportionally.
- Off — view sizes remain fixed.
3. Pane Layout Templates
To quickly apply different splitting configurations or copy a layout to other worksheets, use View → Pane Layout Templates. These templates are stored as global settings and can be reused across worksheets and workbooks.
4. Splitting a Worksheet View
4.1 Using Split Commands or Splitter Bars
You can split a worksheet view using:
- View → Split View Horizontally
- View → Split View Vertically
- Dragging the vertical or horizontal splitter bar to the desired position
4.2 Automatic Splitting Mode
If View → Automatic Splitting Mode is active:
- Vertical splitting affects the entire column of views.
- Horizontal splitting affects the entire row of views.
- Views always form a regular grid (e.g., 1×2, 2×1, 2×2, 3×2, …).
4.3 Synchronization in Automatic Mode
In automatic mode, newly created views are synchronized by default:
- Scrolling columns in one view scrolls columns in all views in the same column.
- Scrolling rows in one view scrolls rows in all views in the same row.
- Synchronization applies to both scrolling movement and the first visible row/column.
By default:
- Row headings are shown only in the left‑most views.
- Column headings are shown only in the top‑most views.
To change headings for a specific view, click the view and use:
- View → Headings And Scrollbars → Row Headings
- View → Headings And Scrollbars → Column Headings
4.4 Manual Splitting Mode
If View → Manual Splitting Mode is active:
- Splitting affects only the selected view.
- Views are not synchronized automatically.
4.5 Synchronization in Manual Mode
You can manually synchronize views using:
- View → Column Synchronization
- View → Row Synchronization
In manual mode:
- Synchronized views may have different left‑most columns.
- Synchronized views may have different top‑most rows.
For details, see: Synchronizing views.
4.6 Headings in Manual Mode
By default, row and column headings are displayed in all views. You can change this per view using:
- View → Headings And Scrollbars → Row Headings
- View → Headings And Scrollbars → Column Headings
4.7 Choosing a Worksheet for a View
By default, all views display the same worksheet. To assign a different worksheet to a specific view, use:
View → Choose Worksheet
5. Removing Splitted Views
To remove a split:
- Use View → Split View Horizontally or View → Split View Vertically again, or
- Drag the vertical or horizontal splitter bar to any window edge.