How to Unmerge Cells in Excel
Written by co-founder Kasper Langmann, Microsoft Office Specialist.
Being able to merge and unmerge cells greatly improves reporting and presentation.
By definition, merging cells in Excel is a process where you join two or more adjacent cells into one larger cell.
But sometimes, mistakes happen and you would like to unmerge cells. That is, separate the large cells and break them into their original pieces.