Excel Guides

Comparing Workbooks in Excel

There are a few different ways to compare workbooks in Excel. One way is to use the Compare Files feature. To do this, open both the workbooks you want to compare side by side in Excel. Then, go to the File tab, and click Compare Files. In the Compare Files dialog box, select the workbooks you want to compare, and click OK. Excel will then open a new workbook with a report that shows any differences between the two workbooks.

Another way to compare workbooks is to use the Audit Tool. To do this, open both workbooks in Excel. Then, go to the Formulas tab, and click Name Manager. In the Name Manager, select the names you want to audit, and click Audit Selected Names. Excel will then open a new workbook with a report that shows any differences between the two workbooks.

Note: The Compare Files feature only works if both workbooks are saved in the same file format (e.g., .xlsx). If they are not saved in the same file format, you will need to use the Audit Tool.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.