With the view side-by-side option, you can open two files and then arrange these horizontally or vertically.

Even if you reduce the size, you always see one Excel file at the top. Suppose you have two files for two different months and you want to check what values are different in these two files.īy default, when you open a file, it’s likely to take up your entire screen.

Let’s see how to use this when you have to compare two separate files or two sheets in the same file. If you have a large dataset, I recommend using the conditional method or the formula method covered later in this tutorial. This is recommended only when you have a small dataset and manually comparing these files is likely to be less time-consuming and error-prone. If you want to compare two separate Excel files side by side (or two sheets in the same workbook), there is an in-built feature in Excel to do this. Using a Third-Party Tool – XL ComparatorĬompare Two Excel Sheets in Separate Excel Files (Side-by-Side).Compare Two Excel Files/Sheets And Get The Differences Using VBA.Compare Two Excel Files/Sheets And Get The Differences Using Formula.Compare Two Sheets and Highlight Differences (Using Conditional Formatting).Compare Two Sheets (Side-by-Side) in the Same Excel Workbook.Compare Two Excel Sheets in Separate Excel Files (Side-by-Side).

Notepad++ diff two tabs