Updated September 15, 2017 Open the Excel document that has the cell you need to change. Click the “Home” tab in the Office ribbon at the top of the screen. Click on the merged cell you want to split. The button labeled “Merge & Center” in the alignment group is highlighted in orange by default, indicating that you’ve selected a merged cell. Click the “Merge & Center” button to split the cell into separate cells. Writer Bio
