Instructions
How to Merge Cells in Excel
May
Merging cells in Excel is useful when you want one label or heading to span across multiple columns. Microsoft says merging combines two or more cells to create a new, larger cell, which is a common way to create a label over several columns.
This is often used for titles, section headings, and simple worksheet formatting. But Microsoft also gives an important warning: when you merge multiple cells, only the content of one cell is kept, and the contents of the other merged cells are deleted.
How to Merge Cells in Excel
This is the standard method most people use.
Microsoft says to:
- select the cells to merge
- choose Merge & Center
- then select Merge Cells
This combines the selected adjacent cells into one larger cell.
What Happens When You Merge Cells
This is the part people often miss.
Microsoft says that when you merge multiple cells, only one cell’s contents remain visible in the merged result. For left-to-right languages, that is the upper-left cell. The contents of the other merged cells are deleted.
So before merging, make sure the text or number you want to keep is in the correct cell.
Best Use Cases for Merging Cells
Merging cells is most useful for layout and presentation.
Good examples include:
- worksheet titles
- section headings
- labels across several columns
- simple report headers
Microsoft gives the example of merging cells A1, B1, and C1 to create the label Monthly Sales above the related data.
How to Unmerge Cells in Excel
If you want to reverse the merge, Excel can do that too.
Microsoft says to:
- select the Merge & Center drop-down arrow
- choose Unmerge Cells
This splits the merged cell back into separate cells.
Important Warning About Unmerging
Unmerging does not restore deleted content from the cells that were merged.
Microsoft says that after merging, you can split a merged cell into separate cells again, but the merge process itself deletes the contents of the other cells that were merged.
That means if you merged several cells and only one value remains, unmerging will not bring the lost values back.
Can You Split One Normal Cell into Smaller Cells?
No, not in the way many people expect.
Microsoft says you cannot split an individual cell. It also notes that you can make it appear as if a cell has been split by merging the cells above it.
So:
- you can merge several cells into one
- you can unmerge them later
- but you cannot divide one regular cell into two smaller real cells
FAQ
How do I merge cells in Excel?
Microsoft says to select the cells, then use Merge & Center and choose Merge Cells.
How do I unmerge cells in Excel?
Microsoft says to open the Merge & Center drop-down and choose Unmerge Cells.
What happens to the data when I merge cells?
Microsoft says only the content of the upper-left cell remains, and the contents of the other merged cells are deleted.
Can I split one normal cell into two smaller cells in Excel?
No. Microsoft says you cannot split an individual cell.
Get genuine Office keys with instant delivery and easy activation, so your Excel tools are ready whenever you need to build cleaner spreadsheets.