The following figure shows the correlation between selected columns in a worksheet and output fields in the

Use Service

window:

The highlighted blue area in the Excel worksheet indicates columns that you select. The numbers in the Excel worksheet indicate the order that you select the columns. The numbers in the

Use Service

window indicate the order in which the Data Quality for Excel plug-in populates the input fields.

If you click the

Autofill

button in the Input section of the

Use Service

window, the plug-in populates the input fields with the column ranges from your selection. The

Autofill

button is indicated by the red circle in the figure.

When you select a column or row header, Data Quality for Excel uses the full column range. For example, if you select the header for Column C and click

Autofill

, Data Quality for Excel writes

C:C

into the currently selected service field. However, when the Data Quality for Excel plug-in runs a service, the plug-in recalculates the range in service fields that use full columns or rows. The plug-in locates the last populated cell in the row or column and updates the field so that the range uses the last populated cell as an endpoint. For example, if the last populated cell is C28, then the plug-in updates the field to read

C1:C28

.