Copy a cell's formula down the column, like dragging the fill handle in Excel
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 | Optional | — | Optional. Leave empty to fill down to the last row that has data, which is what dragging the fill handle does. Give a range like B2:B100 only when you want to fill a fixed number of rows or across columns. |
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Add Row to Sheet
Add a row of values to the end of a sheet
Append Data to Sheet
Add many rows to the end of a sheet in one step. Use Add Row to Sheet for a single row
Write CSV
Write a sheet out as a .csv file. Formulas are written as their answers, since a CSV has nowhere to put a formula
Write Excel
Save data to cells or ranges in a spreadsheet
Write to Cell
Write a value, or an Excel formula, to a specific cell
Apply Conditional Formatting
Add a rule that keeps highlighting cells as the data changes, rather than colouring the ones that match today