Download - Synkronizer Excel Compare

Transcript
62
Synkronizer 10
or not there are still differences. If all worksheets are to be compared, the left icon must be
locked. If this symbol is not locked, however, only the selected worksheet will be compared.
With the right icon, a new comparison is started
Highlight / remove differences
With the left symbol differences are highlighted. With the right icon, the Synkronizer highlighting's are removed, with the original background colors restored
Show/hide differences
With these two symbols the differences can be shown or hidden. To view specific
differences, proceed as follows:
1. Press the arrow of the left icon and select the differences you want to be shown/hidden
2. Click the plus sign of the left of the symbol; the differences will be shown/hidden
3. When all differences are to be shown again, click the right button again
Arrange windows
With these two button you can change between a horizontal and a vertical view
Dock Navigator form
Normally, the navigator form is shown above the Excel worksheets. With these buttons you
can dock the Navigator form at the left or right of the Excel worksheets
4.3.2
Detail Information
In the lower part of the form, the details are displayed, which were selected in the upper part:
With that list-box you can transfer, update or delete unwanted differences. The following buttons are
available
Transfer missing rows from 1st to 2nd worksheet
With these buttons you can transfer the missing rows from the 1st to the 2nd worksheet (from
left to right). Either all or only the selected row will be transferred. Once the row has been
transferred, it is shown in red
These commands are also available in different columns
Transfer missing rows from 2nd to 1st worksheet
©2000-2014 XL Consulting GmbH, Switzerland