Fill a source cell's formula or value across a range, adjusting relative references like dragging the Excel fill handle. Absolute references (with $) stay pinned.
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | — | — |
Sheet Name sheetName | string | Optional | — | — |
Source Cell sourceCell | string | Required | — | The cell to fill from, e.g. B2. Its formula or value is copied across the fill range. |
Fill Range fillRange | string | Required | — | The range to fill, e.g. B2:B100. Include the source cell as the top-left of the range. |
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Close Excel Workbook
Save and close the Excel file
Convert Excel to PDF
Export the workbook (or a single sheet) to PDF, preserving layout, charts, and conditional formatting.
Create New Excel WorkSheet
Add a new blank sheet to the workbook
Create Pivot Table
Create a summary table to analyze data
Delete Excel WorkSheet
Remove a sheet from an Excel workbook
Delete WorkSheet Columns
Remove specific columns from a sheet