Are you struggling to find the “Compare Files” feature in Excel? This essential tool, allowing you to identify differences between two spreadsheets, may not be immediately visible. This guide will walk you through locating and utilizing Excel’s comparison functionality, specifically addressing the common issue of users unable to find it.
Locating the Compare Files Feature
The “Compare Files” feature isn’t a standard button on the Excel ribbon. It’s part of the Spreadsheet Compare application, a separate program included with specific Microsoft Office suites.
Spreadsheet Compare Availability:
Crucially, Spreadsheet Compare is only available with:
- Office Professional Plus 2013
- Office Professional Plus 2016
- Office Professional Plus 2019
- Microsoft 365 Apps for enterprise
If you’re using a different Office edition, like Home or Student, you won’t have access to this application.
Launching Spreadsheet Compare:
- Windows Search: Type “Spreadsheet Compare” in the Windows search bar and select the application.
Using Spreadsheet Compare
Once you’ve launched Spreadsheet Compare:
-
Select Files: Click “Home” > “Compare Files.” Browse and select the two Excel workbooks you want to compare. You can compare files saved locally, on a network, or even from a web address.
-
Comparison Options: Choose which elements to compare: formulas, macros, cell formatting, or select all. This refines the comparison to focus on specific aspects.
-
Run Comparison: Click “OK” to start the analysis. You might be prompted for a password if either workbook is protected.
Understanding the Results
Spreadsheet Compare presents results in a two-pane grid:
-
Side-by-Side View: The left pane displays the “Compare” file (typically the older version), and the right pane shows the “To” file (typically the newer version). Each worksheet is compared individually, even hidden ones.
-
Highlighting Differences: Changes are color-coded, making it easy to spot variations:
- Green: Entered values (non-formula cells) that have changed.
- Blue-Green: Calculated values that have changed.
- Other colors highlight other differences as explained in the application’s legend.
- Detailed Results: A pane below the grids provides specific details about each difference.
Alternative: Excel’s Inquire Add-in
While not as comprehensive as Spreadsheet Compare, Excel 2013 and later versions have an “Inquire” add-in offering some analysis capabilities. This add-in lets you examine workbook relationships and clean excess formatting. Enable the Inquire add-in through Excel’s Options if you don’t see the “Inquire” tab.
Conclusion
Finding the “Compare Files” functionality in Excel hinges on having the correct Office suite and understanding that it resides within the Spreadsheet Compare application. By following these steps, you can effectively utilize this powerful tool to analyze and compare your spreadsheets. If you lack Spreadsheet Compare, consider the Inquire add-in for limited analysis options. Remember to check your Office version to determine the available tools.
