Unmerge Cells in MS Excel 2013

How to unmerge cells in Microsoft Excel 2013?


To split the merged cells in the excel file do the following.
Step 1: Select the merged cell and follow any of the two options given below.
Option 1:
Step 1: Right click on the selected cell and click Format Cells.unmerge format cells ms excel 2013
Step 2: In the Format Cells dialog box opens, under Alignment tab uncheck the Merge Cells check box and click OK.
unmerge cells1 ms excel 2013
Option 2:
Step 1:
Click Alignment under HOME tab. Select Unmerge Cell option by clicking the drop down near the Merge and Center.
unmerge cells ms excel 2013
Merged cells will get unmerged as shown in the below image.
unmerge cells output ms excel 2013

Related Topics