Worksheet views: Row and column synchronization options

Splitted views can be synchronized: scrolling columns (or rows) in one view can result in scrolling columns in all other views synchronized with it.
Synchronization commands are available via the View menu.

Views splitted in the Automatic Splitting Mode are all synchronized by default. The splitted views form a regular grid of views which are synchronized in columns and rows (of views). The default synchronization can't be turned off in this mode.

Views splitted in the Manual Splitting Mode are not synchronized initially and users have to toggle the synchronization "on" or "off" using the Column Synchronization and Row Synchronization commands.
Additionally, in this mode synchronized views don't have to use the same first column (or row), which means that the synchronization can concern any distant worksheet ranges showing both different ranges of columns and different ranges of rows.

To toggle the view synchronization on/off in the manual splitting mode

Click the first view to synchronize and use the Column Synchronization or the Row Synchronization command. It'll cause displaying the "Click a view to toggle the column (row) synchronization on or off" message within that view. Then click another view that should be synchronized with the current one (or to remove it from a given view synchronization chain).

If the Synchronization Tags option is selected, synchronized views display the "R" (rows) or "C" (columns) markers in their top-right corners. Views belonging to the same synchronization chains display their respective markers using the same colors.


In the example above the views are synchronized as follows:

To synchronize cell range selections in views

Select the Keep Selection Synchronized option. Selecting cells within a given view will cause selecting the same number of columns and/or rows in views synchronized with it.

To perform a one-time synchronization of selections in synchronized views, use the Make Same Selection command.

Note: To quickly go back to the selection origin, on worksheet/table window toolbar click the address of that selection.