Hi, I'm Bolo!
What would you like to know?
ASK BOLOPreview
Please to access Bolo.

User and Developer Guide

User and Developer Guide

Unaligned Selections

Unaligned Selections

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 figure shows an Excel sheet and corresponding Use Service window configuration. Three cells are highlighted in the Excel sheet. Each cell is in a different row and in a different column of the spreadsheet. The Use Service window shows the name of each field and the cell location of the field.
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.