button to populate service inputs and outputs with contiguous or non-contiguous cell ranges. You use the
CTRL
key to select non-contiguous areas in Microsoft Excel worksheets.
After you select ranges, enter a keyboard shortcut or click an
Autofill
button in the Input section or Output section in the
Use Service
window.
If a service uses mutliple inputs or output fields, you must populate the fields with ranges that contain the same number of cells. For example, if you populate two input fields with the ranges A1:A100 and B1:B99 and click
Run
, Data Quality for Excel returns the error "The number of cells in all inputs must be the same."