Compare and merge Microsoft® Excel® worksheets, names and VBA Projects
Toolbar Commands
Toolbar Commands
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 selected range.
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.
Synchronous scrolling. 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.
Synchronous selection. 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.
Zoom. 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.