Definition and Usage
Automatically fill data or formats from the source range according to predefined rules, expanding either down or to the right. This command enables you to quickly apply patterns, formulas, or formatting from a source range to a target range in an Excel worksheet.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Excel instance | Please select an Excel instance to identify the instance to operate on |
| Yes | Must be created via the "Launch Excel" or "Get active Excel worksheet" command |
Worksheet name | Specify the worksheet name |
| No | Leave blank for the active worksheet |
Reference range | Select the starting cell or range to use as the reference for filling | Cell, Range | Yes |
|
Source row | The row of the source cell where the filling will start |
| Yes | When Reference range is set to "Cell" |
Source column | The column of the source cell where the filling will start |
| Yes | When Reference range is set to "Cell" |
Source start row | The starting row of the source range from which data will be filled |
| Yes | When Reference range is set to "Range" |
Source end row | The ending row of the source range, marking the lower limit of the data to be filled |
| Yes | When Reference range is set to "Range" |
Source start column | The starting column of the source range from which data will be filled |
| Yes | When Reference range is set to "Range" |
Source end column | The ending column of the source range, marking the right limit of the data to be filled |
| Yes | When Reference range is set to "Range" |
Fill direction | Choose the direction in which to fill the data | Downward, Rightward | Yes |
|
Fill end row | Specify the row where the filling should end |
| Yes | When Fill direction is set to "Downward" |
Fill end column | Please enter the column number at the end of filling position |
| Yes | When Fill direction is set to "Rightward" |
Fill rule | Select how to fill the target range | Default, Copy values and formats, Fill series, Copy formats only, Copy values only | Yes |
|
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
This action doesn't produce any variables.
Using Variables in Conditions
Parameters with the {x} icon support the use of variables. You can insert previously created variables by clicking on this icon and selecting the desired variable from the dropdown menu. This is particularly useful when you need to dynamically specify worksheet names, cell references, or fill ranges based on values calculated earlier in your workflow.
Notes
Before using this command, ensure that a valid Excel instance has been created and the target file is open.
The "Fill rule" parameter determines how data is filled:
Default: Uses Excel's standard fill behavior
Fill series: Extends patterns (like dates, numbers in sequence)
Copy values and formats: Duplicates both content and formatting
Copy formats only: Applies only the formatting from the source range
Copy values only: Copies only the values without formatting
When specifying column references, you can use either letter notation (A, B, C) or numeric notation (1, 2, 3).
Negative row or column values (like -1) can be used to reference positions relative to the end of the data range.