| |
Differences Report
Excel Compare compares data straight from your worksheets, and presents the results on a new Excel sheet as a publication-quality report (Differences Report), that is ready to print or save. The report worksheet displays the added, deleted and changed data.
You can control a differences report view:
- You can customize report subtitles: subtitle text, font, color, sizing. For this purpose, select 'Tools|Environment Options...' from the main menu.
- You can place the information about the removed, added and changed data in separate sheets. For this purpose, check the "Divide the report into three sheets" option in the main window. The report will be created with three sheets: Deletions, Additions and Changes.
- You can replicate originals of the compared worksheets into a report workbook. For this purpose, check the "Replicate the compared sheets into a new report workbook" option. The differences report will be created with links to the new copied worksheets in the same workbook.
- You can create all reports sheets of the project in a single workbook. For this purpose, check the "Create all reports of the project in the same workbook" option in the 'Project Option' dialog box on the 'Report' tab.
- You can highlight cells that have changed. For this purpose, check the "Highlight individual cells that have changed or are different" option in the 'Project Option' dialog box on the 'Report' tab.
- You can specify a copying mode of an original information into report sheets: 'values only' or 'values and formats'. For this purpose, choose corresponding radiobutton in the 'Project Option' dialog box on the 'Report' tab.
- You can save created reports to files automatically. For this purpose, check the "Save report to file" option and enter the name into the right field in the 'Project Option' dialog box on the 'Report' tab.
- Also you will find other options in the 'Project Option' dialog box on the 'Report' tab.
|
