Tools - Outline

<< Click to Display Table of Contents >>

Navigation:  Select Tab > Ribbon >

Tools - Outline

Previous pageReturn to chapter overviewNext page

 

In the Outline menu, you can choose whether you want to see only certain types of differences or not. In this way you can check and process the differences very efficiently. The following difference types can be selected:

 

Missing columns
These columns are only found in one worksheet.

 

Missing rows
These rows were either deleted or added.

 

Duplicate rows
Applies only to database mode: these rows include either duplicate (redundant) records or rows with duplicate keys.

 

Identical rows
These rows are completely identical and have no cell differences.

 

Different rows
These rows contain cell differences.

 

 

Proceed as follows if only certain differences need to be displayed:

 

1. Click Outline

 

2. Select "Enable outlining". (The outline symbol will change from gray to black)

 

3. Select the types of difference, which you want to view.

 

4. Close the dialogue "Outline".