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.
Step 1: Right click on the selected cell and click Format Cells.
Step 2: In the Format Cells dialog box opens, under Alignment tab uncheck the Merge Cells check box and click OK.
Step 1: Click Alignment under HOME tab. Select Unmerge Cell option by clicking the drop down near the Merge and Center.
Merged cells will get unmerged as shown in the below image.