Unmerge cells
How to unmerge cells using Excel and VBA methods
Select merged range > Home tab > Alignment group > Merge & Center
| 1. Select the merged range. Note: in this example the cells A2 to D2 have been merged. |
 |
| 2. Select the Home tab. |  |
| 3. Click on Merge & Center. |  |
Select merged range > Right-click on selected range > Format Cells > Alignment tab > Uncheck Merge cells checkbox > Click OK
| 1. Select the merged range. Note: in this example the cells A2 to D2 have been merged. |
|
| 2. Right-click anywhere on the selected area. 3. Select Format Cells. |
 |
| 4. Select the Alignment tab. 5. Uncheck the Merge cells checkbox. 6. Click OK. |
 |
METHOD 1. Unmerge cells using VBA
VBA
Sub Unmerge_Cells()
'unmerge range A2:D2 in a worksheet named Sheet1
Worksheets("Sheet1").Range("A2:D2").UnMerge
Worksheets("Sheet1").Range("A2:D2").UnMerge
End Sub
PREREQUISITES
Worksheet Names: Have a worksheet named Sheet1.
Worksheet Names: Have a worksheet named Sheet1.
ADJUSTABLE PARAMETERS
Sheet Selection: Select the worksheet in which you want to unmerge cells by changing the Sheet1 worksheet name in the VBA code.
Unmerge Cell Selection: Select the range of cells you want to unmerge by changing range ("A2:D2") in the VBA code.
Sheet Selection: Select the worksheet in which you want to unmerge cells by changing the Sheet1 worksheet name in the VBA code.
Unmerge Cell Selection: Select the range of cells you want to unmerge by changing range ("A2:D2") in the VBA code.
METHOD 2. Unmerge selected cells using VBA
VBA
EXPLANATION
This tutorial explains and provides step by step instructions on how to unmerge cells.
This tutorial explains and provides step by step instructions on how to unmerge cells.
Excel Methods: This tutorial provides two Excel methods that can be applied to unmerge cells. Both of the methods are very similar to each other, with one using the Home tab and the other using the Format cells option. The first method can be accomplished in three steps, whilst the second in six steps.
VBA Methods: This tutorial provides two VBA methods that can be applied to unmerge cells. The first method unmerges the cells specified in the VBA code. The second method unmerges the selected cells.
RELATED TOPICS
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Merge cells | How to merge cells using Excel and VBA methods | |
| Wrap text | How to fit content in a cell without adjusting column width using Excel and VBA methods | |
| Unwrap text | How to unwrap content in a cell using Excel and VBA methods |