Merge and Unmerge Cells

Merging Cells

Merge multiple cells in a worksheet into a single cell by calling the Cells collection’s Merge method. Specify the range of cells that to be merged when calling the Merge method.

Four cells merged into one


Unmerging Cells

To unmerge cells, use the Cells collection’s UnMerge method that takes same parameters as of the Merge method and performs the unmerging of cells.