Docs · guide

How to merge cells in Excel, and why you may not want to

By Alberto Gulotta · Updated 3 September 2026 · 12 min read

To merge cells in Excel: select them, then Home › Merge & Center › Merge Cells. That is the whole instruction, and it is not the reason this page exists — because the command deletes everything except the upper-left cell, and says so only in a note.

1. Move anything you want to keep into the upper-left cell first. Microsoft says it as a warning rather than a step: “make sure that the data you want to retain is in the upper-left cell, and keep in mind that all data in the other merged cells will be deleted.”
2. Select two or more adjacent cells. Merging is only for neighbours; a selection with a gap in it is not a merge.
3. On the Home tab, select Merge & Center, then Merge Cells. Or use Merge Across to do each row of the selection on its own.
4. If the button is greyed out, check two things. Microsoft: “make sure that you’re not editing a cell — and the cells you want to merge aren’t formatted as an Excel table.”
5. To undo it later, use Unmerge Cells in the same menu. The grid comes back; the deleted contents do not.

Two whole families of guide exist to undo this. Combining the text of several cells, and merging “without losing data”, are both attempts to solve a problem the merge button creates — and both are the other command, the one that joins values instead of joining boxes.

Which one do you want? A quick test: after the operation, do you need the information from both cells? If yes, you want the right-hand column and you should not touch the merge button. If you only want one heading to sit across several columns, merging does that — and so does something safer.

The safer alternative for a heading. Open Format Cells, go to Alignment, and set Horizontal to Center Across Selection. The text appears centred across the whole range exactly as a merge would look, but the cells stay separate — so nothing is deleted and nothing downstream breaks. This is our recommendation rather than something on the Microsoft page quoted above, and it is the single most useful habit in this subject.

The last one is worth dwelling on because it is where the cost actually lands. A merged cell is a decision about how a sheet looks, saved inside the data. Weeks later somebody sorts the sheet, or imports it, or runs a de-duplication over it, and the file fights back — and the person who merged the cells is usually not the person who has to work out why.

Finding merged cells you did not make. Inheriting a spreadsheet that misbehaves is common, and Microsoft gives the shortcut on the same page: “If you don’t remember where you have merged cells, you can use the Find command to locate merged cells quickly.” In the Find dialog, open the format options and search for the merged-cells format. It is quicker than scrolling and it usually explains the fault immediately.

The one case where merging is right. A title across the top of a printed report or an invoice with its required fields — a sheet that is a document rather than a dataset, that nobody will sort or filter, and where the only cell with content was going to be the first one anyway. That is a real use, and it is narrower than the button’s prominence suggests.

The quoted warnings and the Find tip are from Microsoft’s own Excel documentation, read on 22 August 2026. The list of what merging breaks, and the Center Across Selection recommendation, are ours.

Not covered here. It will not present merging as harmless formatting. Microsoft marks the data loss as Important on its own page, and unmerging does not undo it.

It will not confuse merging with combining. They are different operations and the search results for this question are full of people who found out the hard way.

And it will not recommend an add-in. Center Across Selection is in the Format Cells dialog and costs nothing. What holds instead is simple: the warnings about deleted contents and the Find tip are quoted from Microsoft’s own Excel documentation, with the date it was read.