Man illustrationFlower illustration

Docy

Merge/unmerge cells

Estimated reading: 1 minute 32 views

Merge/unmerge cells activity is used for merging and unmerging cells in Excel.


*Excel nameReference name of Excel which will be opened.
Sheet nameName of the sheet to work in Excel. If not added, it takes the first sheet by default.
RangeExcel sheet range from which to fetch data.
Merge cells?Select the checkbox to merge cells and don’t select the checkbox to unmerge cells.
Note: * Fields selected with are required, others are optional.

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name as shown in the example.

Sheet1

You can use the Range as shown in the example.

A1:D7

Sheet name field can be left blank if it is desired to operate on the first page of the Excel file. Otherwise, it has to be filled.
If the Range field is not filled, all of the data in the excel file constitutes the dataset range.

CONTENTS