Toolbar on the Comparison Report Dialog gives quick access to the following commands:
Tile worksheet views. Worksheet viewes can be tiled vertically or horizontally. Screenshots are
available on the Working with comparison results page. You can select layout
which is more suitable for the structure of your spreadsheet.
Remove differences. This command removes difference selected in the list and color formatting from
worksheet views. If difference is not important for you - you can remove it from list and work with other onces.
Cut, Copy and Paste. Clipboard commands which performs Cut, Copy and Paste operations on the currently
Delete. Remove selected row or column from worksheet. Or clear values in the selected range.
Mark selected differences in Excel.
Cells, which are used in selected differences will be marked with color in Excel. More ...
Mark all differences in Excel.
Cells, which are used in differences will be marked with color in Excel. More ...
Save left/right workbook. After making changes you can save the left/right pane by pressing this button.
Save differences on new worksheet. This command saves list of differences in the new workbook.
Save differences in text file. This command saves list of differences in the text file.
Select cells in top view when difference is selected in the list.
If this option is selected, when you select difference in list, cells relative to
this difference are selected in worksheet views automatically. By default this option is ON.
If this option is selected, both worksheet views are scrolled synchronously. If you scroll 5 rows in one view,
xlCompare scrolls other view for 5 rows too.
This is useful option for merging spreadsheets. If this option is checked and you select range (or rows or columns) in
one worksheet view, xlCompare selects corresponding range in other view. xlCompare calculates which range corresponds to selection
by skipping deleted and inserted rows/columns in spreasheets.
You can change zoom of both worksheet views to see more data on the screen. xlCompare remembers selected zoom, and on next
comparison it uses zoom which you've selected previous time.
Find. Find cell which contains specific text. More ...
Merge data to 3-rd worksheet. Opens 3-rd empty worksheet. You can move any data from compared worksheets to this new sheet. More ...
Compare Names. xlCompare compares names between left and right workbooks. More ...
Compare VBA modules. xlCompare compares VBA modules between left and right workbooks. More ...
Comparison Report Dialog has set of features to merge spreadsheets. They are described in the topic
How to merge workbooks.