GreatManuals.com
Huge Collections of Software Manuals and Knowledgebase

Buy Excel Compare Online!

Compare All Workbook Sheets

The third way of comparison allows for comparing all the sheets that have the same names in two workbooks.

1. Enter the full name of the 1.xls file into the First File field;
2. Enter the full name of the 2.xls file into the Second File field;
3. Choose the "Compare all the sheets" option;

The main window will appear as follows:

4. Specify project options in the 'Project Option' dialog box:

The Project Options dialog box will appear as follows:

5. Check the "Create all reports of the project in the same workbook" option in Project Options on the 'Report' tab;

6. Run the "Compare" command

The Difference Report looks as follows:

Buy Excel Compare Online!