You can select unaligned cell ranges to populate multiple input and output fields. Selections are unaligned if the cell ranges do not use the same rows or columns for the start or end of the range.
The following figure shows the correlation between unaligned selections in a worksheet and output fields in the
Use Service
window:
The highlighted blue areas in the Excel worksheet indicate the cell ranges that you select. The numbers in the Excel worksheet indicate the order that you select the ranges. 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 cell ranges indicated by the corresponding numbers. The
Autofill
button is indicated by the red circle in the figure.