Compare Multiple Sheets will help you find and highlight differences in two or more Excel lists or sheets.
You can ignore empty or hidden rows and columns, consider or not leading and trailing spaces, and choose the way and hue to mark the found differences.
Before running the add-in, here are the key points to take note of:
Open all the files you are going to compare and go to the main sheet - it is the sheet the other worksheets will be compared to. To run the add-in, on the Ablebits Data tab, in the Merge group, click Compare > Compare Multiple Sheets:
In the first window, you will see limitations and requirements, please read them carefully.
Click the Agree button to continue.
The tool automatically selects the current sheet as the main one.
Select the area to take for comparison:
In the list of open books, check the worksheets you are going to compare to the main sheet.
You can use the Select range icon and choose the areas of interest for each sheet. Or you can pick a cell in the table and click the Expand selection icon to get the whole table selected.
Click the Next button.
On step 2, first tick off the options that are suitable for your data:
Now you can select the way to mark the found differences in the compare sheets:
Click the down arrow icon to select the color for the differences and click Compare.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!