Man illustrationFlower illustration

Merge/unmerge cells

Estimated reading: 2 minutes 196 views

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


*Excel nameThe reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet nameThe name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet indexIndex of the sheet to work in Excel. If not added, it takes the first sheet by default.
RangeThe Excel sheet range for the merge or unmerge is written.
Merge cells?If it is desired to merge, this checkbox is selected. If it is desired to unmerge, this checkbox is not selected.
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 Sheet index as shown in the example.

5

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.

Share this Doc

Merge/unmerge cells

Or copy link

CONTENTS
Chat Icon Close Icon