Merge Cells
Description
The Merge Cells activity combines multiple adjacent cells into a single merged cell within a worksheet.
This activity is commonly used to create headings, labels, and other worksheet layouts that span multiple rows or columns.
Common Capabilities
Process Data Support
This activity supports dynamic configuration using variables from the Process Data drawer.
You can bind values from Model Data, Form Data, System Data, Enterprise Variables, and Activity Outputs.
Learn more → Using Process Data
Design-Time Configuration
Workbook Configuration
This activity requires an Excel workbook.
Learn more → Excel Workbook Configuration
Worksheet Selection
This activity operates on a worksheet within the workbook.
Learn more → Excel Worksheet Selection
Worksheet Data Selection
This activity targets a range of cells within a worksheet.
Learn more → Worksheet Data Selection
Cells
Range of cells to merge.
Examples:
A1:D1A1:A5B2:E4
The specified range must contain adjacent cells.
Behavior
When cells are merged:
- The selected cells are combined into a single merged cell.
- The value of the upper-left cell is preserved.
- Values contained in the other cells within the range may be removed.
- Formatting is preserved according to Excel's merge behavior.
Outputs
This activity does not produce any activity-specific outputs.
Wait All Incoming
Controls how this activity behaves when multiple incoming execution paths converge.
Determines whether the activity executes when any incoming path completes, or only after all relevant paths have completed.
Learn more → Execution Control
On Error
Defines how the workflow behaves if this activity encounters a runtime error.
Supported strategies include Fault, Continue, Suspend, and Retry.