How to Merge and Unmerge Cells in Excel
This guide provides a step-by-step process for merging and unmerging cells in Excel. It is useful for anyone who wants to combine multiple cells into one or separate a merged cell back into its original individual cells.
Lynette Amador
|
5 steps
|
21 seconds
1
To begin, open your workbook in Excel.
Merging Cells
2
Highlight the cells you want to merge.
3
Click "Home."\ Click the arrow on "Merge & Center" to show a drop down menu.\ Click "Merge Cells."
Unmerging Cells
4
Select the cells you want to unmerge.
5
From "Home," click the arrow on "Merge & Center" to show a drop down menu.\ Click "Unmerge Cells"