Uniting cells in Excel proves helpful once you intend to condense knowledge, however typically you could want to separate the mixed cells again into their particular person components. This text will information you thru the simple steps to unmerge cells in Excel, empowering you to revert mixed cells to their unique state effortlessly.
To provoke the unmerging course of, choose the merged cell you want to separate. Subsequently, navigate to the ‘House’ tab on the Excel ribbon, the place you’ll encounter the ‘Merge & Middle’ choice positioned inside the ‘Alignment’ group. When you click on on the arrow subsequent to this feature, you’ll discover a drop-down menu seem. From this menu, go for the ‘Unmerge Cells’ command. Alternatively, you’ll be able to make use of a keyboard shortcut by urgent ‘Alt’ + ‘H’ + ‘U’ + ‘U’ (or ‘Cmd’ + ‘Choice’ + ‘U’ + ‘U’ for Mac customers) to attain the identical end result.
Upon executing both of the aforementioned strategies, the merged cell will promptly revert to its pre-merged state, permitting you to govern and edit the person cells independently as soon as extra. Keep in mind, unmerging cells solely impacts the formatting of the cells, preserving the info inside them. So, you’ll be able to relaxation assured that your knowledge stays intact all through the unmerging course of.
Find out how to Unmerge a Cell in Excel
To unmerge cells in Microsoft Excel, comply with these steps:
1. Choose the merged cell you wish to unmerge.
2. Go to the House tab within the ribbon.
3. Within the Modifying group, click on the Merge & Middle button and choose Unmerge Cells.
Word: Unmerging cells will restore the unique cell boundaries and knowledge that was beforehand hidden within the merged cell might be seen.
Individuals Additionally Ask:
How do I unmerge cells with a keyboard shortcut?
Sadly, there isn’t a keyboard shortcut to unmerge cells in Excel.
Can I unmerge cells which have knowledge in them?
Sure, you’ll be able to unmerge cells that comprise knowledge. The information might be distributed throughout the person cells after unmerging.
What occurs if I unmerge cells with formulation in them?
Unmerging cells with formulation in them will trigger the formulation to regulate and replace in line with the brand new cell boundaries.
