Unmerge Cells in MS Excel 2013

How to unmerge cells in Microsoft Excel 2013?

Explanation

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.
Step 2: In the Format Cells dialog box opens, under Alignment tab uncheck the Merge Cells check box and click OK.

Option 2:
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.

Related Topics