Uniting cells in Excel proves helpful while you intend to condense knowledge, however generally chances are you’ll want to separate the mixed cells again into their particular person elements. This text will information you thru the easy steps to unmerge cells in Excel, empowering you to revert mixed cells to their authentic 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’ + ‘Possibility’ + ‘U’ + ‘U’ for Mac customers) to realize the identical consequence.
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. Bear in mind, unmerging cells solely impacts the formatting of the cells, preserving the information inside them. So, you’ll be able to relaxation assured that your knowledge stays intact all through the unmerging course of.
Learn 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 Enhancing 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 can be seen.
Folks 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 info can 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 accordance with the brand new cell boundaries.
