Merging and Unmerging Cells

Merging Cells

To merge cells into a single large cell, please follow the steps below:

  • Access any desired Worksheet
  • Create a Range of Cells to be merged
  • Merge the range of cells into a large cell

You can use Merge method of Worksheet to merge cells. However, a range of cells can be defined using CellRange object.

Unmerging Cells

To unmerge a large cell into many cells, please follow the steps below:

  • Access any desired Worksheet
  • Access the merged cell that needs to be unmerged
  • Unmerge the large cell into many cells using the location of merged cell

You can use Unmerge method of Worksheet to unmerge a cell using its location.