Worksheet views

Splitted views can display different areas/ranges of the same worksheet or different worksheets in one main worksheet window. This feature enables users to monitor/track changes in different cells and edit them without inconvenient scrolling. It can also be an equivalent to the "Freeze Rows/Columns" commands implemented in other spreadsheets.

Each worksheet can contain up to 100 splitted views and the number of those configuration in a workbook is unlimited. The splitted view configuration is saved to the workbook file. Additionally, users can protect the current splitted view configuration with a password using the Tools > Protect Structure command.

The View > Proportional Splitter option enables you to control how the splitted views behave when the main frame window is resized. If this option is "on", the splitted views will be resized proportionally. If it's "off", the size of the splitted views remain the same.

Users who need to quickly apply different splitting configurations or to "copy" a given splitting configuration to another worksheet(s) can use the View > Pane Layout Templates commands. These splitting configuration templates are stored as global settings.

Use the View > Split View Horizontally and ...Split View Horizontally commands or drag either the vertical or the horizontal splitter bar to the desirable position:

If the View > Automatic Splitting Mode is active, splitting always concerns the whole column of views (for vertical splitting) or the whole row of views (for horizontal splitting). Thus the splitted views always form a regular grid (e.g. 1x2, 2x1, 2x2, 3x2,...).

In this splitting mode the newly created views are synchronized by default. Scrolling columns in one view causes scrolling columns in all views within the same column of views and scrolling rows is always synchronized for views within a given row of views. Synchronization concerns both the very process of scrolling and the first visible column (for column synchronization) or the first visible row (for row synchronization).
By default, in this splitting mode the row headings are displayed only for the "left-most" views and column headings - only for the "top-most" views. To change this for a given view, click it and use the View > Headings And Scrollbars > Column Headings or ...Column Headings commands.

If the View > Manual Splitting Mode is active, splitting always concerns only a given single view.

In this splitting mode views are not synchronized automatically. One can use the View > Column Synchronization and View > Row Synchronization commands to synchronize them in any desirable way.
Also, the left-most column (or the top row) can be different in synchronized views. For details, please see: Synchronizing views.

By default, in this splitting mode the row and column headings are displayed for all views. To change this for a given view, click it and use the View > Headings And Scrollbars > Column Headings or ...Column Headings commands.

By default, in both splitting modes views display one and the same worksheet. To choose a different one for a given view, use the View > Choose Worksheet command.