Ranges

<< Click to Display Table of Contents >>

Navigation:  Select Tab > Worksheets >

Ranges

Previous pageReturn to chapter overviewNext page

 

select_worksheet_ranges

 

If you do not want to compare the entire worksheet, you can define the desired range.  Proceed as follows:

 

1.

Select the worksheet which contains the range you want to compare

2.

Under the worksheet pair the options area appears (3 options). Now you can specify the desired range by using of the range buttons.

3.

The range address is also listed next to the worksheet name.

 

 

Note:
You can also enter named ranges. Multiple ranges are not allowed.