How to Merge Cells in Excel (and When Not To)
Merge & Center sits on Excel's Home tab, but it deletes data and breaks sorting. Learn the three ways to merge, how to unmerge, and the safer way to center a title.
To merge cells in Excel, select the cells you want to combine, open the Home tab, and click Merge & Center in the Alignment group. The catch: merging keeps only the value in the upper-left cell and deletes the rest, so merge empty cells or ranges where only the top-left cell holds data. To center a heading across columns without the trouble merged cells cause later, use Center Across Selection instead. If Merge & Center is grayed out and won’t click at all, the selection is almost always inside a formatted Excel Table, which blocks merging until you convert the table back to a range.
Where the merge buttons live
Every merge option sits under one button. On the Home tab, find the Alignment group between Font and Number, and click the small arrow beside Merge & Center to open the dropdown.
| Option | What it does |
|---|---|
| Merge & Center | Combines the selected cells into one and centers the content |
| Merge Across | Merges cells row by row, keeping each row a separate merged cell |
| Merge Cells | Combines the cells into one without centering |
| Unmerge Cells | Splits a merged cell back into individual cells |
There’s no default shortcut, but the ribbon accelerator keys Alt, H, M, C run Merge & Center from the keyboard.
The warning you should not ignore
If more than one selected cell contains data, Excel warns that merging only keeps the upper-left value and discards the others. Click OK and those extra values are gone for good. Move or copy that data somewhere safe first, or make sure the range is empty except for the top-left cell.
Center a title without merging
Merging a title across columns looks tidy but breaks the grid beneath it. To center text across several columns without combining them, select the cells, press Ctrl+1 to open Format Cells, open the Alignment tab, and set Horizontal to Center Across Selection. The text sits centered over the group while each cell stays independent, so sorting and filtering keep working.
Unmerge and why merged cells cause trouble
To undo a merge, select the merged cell and click Merge & Center again, or choose Unmerge Cells from the dropdown. It’s worth the effort, because merged cells quietly break common tasks: sorting can return the error “This operation requires the merged cells to be identically sized,” filters can’t select rows cleanly, and copy-paste over a merged range often fails. If a sheet full of merges keeps freezing, our guide on fixing Excel when it stops responding can help, and it’s usually easier to remove duplicate rows while the columns are still unmerged.
When in doubt, keep the data grid intact and reach for Center Across Selection on headings. Merge only cells you know are empty or hold a single value, and unmerge before you sort, filter, or turn the range into a table.
Common questions
Why is Merge & Center grayed out in Excel?
The usual cause is that the selected cells sit inside a formatted Excel Table, which does not allow merged cells. Open the Table Design tab and choose Convert to Range first, then the button becomes available. A protected worksheet will also disable it until the sheet is unprotected.
How do I merge cells in Excel without losing data?
Merging keeps only the upper-left cell’s value and discards the rest, so move the other data out first, or combine it into one cell with a formula like =A1&" "&B1 before merging. To keep a heading centered across columns without deleting anything, use Center Across Selection instead.
How do I fix “This operation requires the merged cells to be identically sized”?
This error appears when you sort or filter a range that contains merged cells, because Excel cannot reorder rows while a merged block spans them. Select the range, click Merge & Center to unmerge everything, then run the sort or filter again.
How do I merge cells across columns but not rows?
Select the range and choose Merge Across from the Merge & Center dropdown. It combines each row’s cells horizontally into one while keeping every row separate, unlike Merge Cells, which fuses the whole selection into a single cell.