To clearly see the difference between two Excel files, let the Compare Two Workbooks tool find worksheets with the same name there, analyze the ranges they contain, and show the content that varies using the colors of your choice.
Consider the requirements and limitations the add-in has.
The Compare Two Workbooks icon is in the Compare drop-down menu in the Merge group on the Ablebits Data tab:
After you click it, the add-in will show the list of requirements and limitations it has:
If you do not mind them and want to proceed, click Agree.
Let the add-in know which two of your open Excel files to compare by picking them in the list:
To add a file to the list, click the Open Workbook button.
On selecting the necessary workbooks (and worksheets), click Next.
Decide how the tool should demonstrate the differences it will find:
Pick the colors the tool should use for differentiating Rows that exist only in Book1, Rows that exist only in Book2, and Cells different in Book1 and Book2.
After selecting the options that suit your task, click Compare.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!