This topic describes how you can work with results of the comparison.

Commands used to merge workbooks are described in the Merge Workbooks topic.

Quick Merge Toolbar topic describes how to use the Quick Merge Toolbar.

Comparison results are shown in separate window:

This windows contains 3 parts:

• Toolbar with commands on the top
• Worksheet with older data on the left side.
• Worksheet with newer data on the right side

List with differences is shown separately, in the Difference Browser window. Browser window contains list of compared worksheets, Quick Merge Toolbar and list of differences.

Worksheets can be tiled horisontally or vertically. If your spreadsheet has many columns - horizontal layout is more suitable.

If you compare several pairs of the worksheets, you can switch between them using Difference Browser. Only one pair of sheets at a time can be shown in this dialog.

Using Zoom button you can change zoom on difference report and see more data by making cells smaller:

Other toolbar commands are described in the Toolbar Commands topic..

In both sheet views modified data is marked with colors:

• Green - added data (may appear only in right sheet)
• Red - deleted data (may appear only in left sheet)
• Blue - changed data

List with differences contains Sheet and address of the modification - which rows\columns have been added or deleted. For changed cells xlCompare shows old and new value in this list.

This screenshot shows deleted row:

On the left side row is marked as deleted with red color. On the right view (newer data) this row is missed.

Modified cell:

On the right side formula produced 8500 and on left side 0. Both cells are marked with blue color in views.

Difference report may contain the following items:

You can use right click menu in the Difference Browser and on both worksheets.

Right click menu in Difference Browser:

Right click menu in the worksheet view:

Cut, Copy, Paste commands performs clipboard operations. In list control you can only copy selected difference to clipboard. In worksheet window you can cut, copy and paste cells in same way as in Excel.

Delete command in list just deletes selected differences. In worksheet view it deletes selection - if range is selected - it is cleared. If rows are selected - they are deleted, if columns are selected - they are deleted.

Other commands duplicates commands from toolbar, and described in the Toolbar Commands topic.

To activate cell in Excel's workbook, double-click on this cell in the top view.