In case you want to arrange the files vertically, click on the Arrange All option (in the View tab).
EXCEL FILE COMPARISON TOOL FREE
Both of the files will be visible, and you’re free to edit/compare these files while they are arranged side by side. This becomes available only when you have two or more Excel files open.Īs soon as you click on the View side by side option, Excel will arrange the workbook horizontally.
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.
EXCEL FILE COMPARISON TOOL HOW TO
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.
0 kommentar(er)
