Merge And Unmerge Cells. You can only unmerge cells that were previously merged. To unmerge all cells on the sheet you do the following.
Sub unmergeCells WorksheetsMerge CellsRangeC6UnMerge End Sub. The Split Cells dialog box will appear. To unmerge cells use the Cells collections UnMerge method that takes same parameters as of the Merge method and performs the unmerging of cells.
In the Go To Special dialog box select Blanks option.
Unmerge cells Select the Merge Center down arrow. If you want to unmerge the cell back to its original contents you can simply click on the merged cell and click on the Merge and Center button again. For this either click the little triangle in the upper-left corner of the worksheet or. You can only unmerge cells that were previously merged.
