Link Data 1 on 1

<< Click to Display Table of Contents >>

Navigation:  Select > Worksheets >

Link Data 1 on 1

Previous pageReturn to chapter overviewNext page

 

If you are sure that your worksheets do not contain new or deleted rows/columns, then you can compare your files with the "1 on 1 method". In this case, the rows and columns are compared "1 on 1" and only cell differences will be detected.

 

Proceed as follows to compare the rows and/or columns by the "1 on 1 linking method":

 

1. Select the worksheet pair, which should be compared 1 on 1.

 

2. Click "Compare as worksheet". The tab "Linking Options" appears.

select_worksheets_link_1on1

 

4. The tab "Linking Options" appears. Click "Link columns 1 on 1" or "Link rows 1 on 1"

worksheets_link_1on1_2

 

5. After confirming the 1 on 1 linking method, the linking icon appears next to the worksheet pair.
worksheets_link_1on1_icon