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.
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.