When you unmerge cells, the data is retained in the top-left/uppermost cell while the cells split. This wikiHow will show you three easy ways to change a merged cell back into two or more standard cells in Microsoft Excel using your Windows or Mac computer.
This step-by-step tutorial shows how to unmerge cells in Excel, how to find all merged cells from a worksheet, and how to fill unmerged cells with the original content of the merged cells.