How to compare Excel Files using Inquire

In this article I will guide you how to compare two Excel files using the Inquire add-in.

The inquire Add-in must have already been selected from the add-in options. Clicking the Inquire tab from Excel Tab will show these options:

  • Workbook Analysis
  • Workbook Relationship
  • Worksheet Relationship
  • Cell Relationship
  • Compare Files
  • Clean Excess Cell Formatting
  • Workbook Passwords

Inquire Ribbon tab

We will use the Compare Files to compare 2 files now. Lets click Compare Files button and select two files which you want to compare:

compare files

Clicking compare will give results like this:

compare results

So we can clearly see the differences highlighted in green.


You can download the Template here – Download
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell