Docs tower · floor
How to merge cells in Excel, and why you may not want to
The button for how to merge cells in excel is easy to find: select the cells, then Merge & Center → Merge Cells. That is the whole instruction, and it is not the reason this page exists.
Microsoft’s own warning, marked Important on its page Read 22 August 2026. And unmerging does not bring them back — Microsoft is equally direct about that:
“You cannot split an unmerged cell.” Merging is a formatting command that quietly performs a
deletion, which is unusual and worth knowing before you use it on real data.“When you merge multiple cells, the contents of only one cell (the upper-left cell for
left-to-right languages, or the upper-right cell for right-to-left languages) appear in the merged
cell. The contents of the other cells that you merge are deleted.”
The search results themselves show what this costs people. Two of the pages ranking for this question are about combining data from several cells and about merging “without losing data” — both are attempts to solve a problem that the merge button creates.
What the button does Joins the cells into one box for appearance. Keeps one value and deletes the rest. What most people actually want Puts the values of two cells together into a third — a first name and a surname, a street and a
town. Nothing is deleted. Done with a formula rather than a button, and it updates itself when the originals change.Merging cells
Merge & Center → Merge Cells. Useful for a title across the top of a report, and
for very little else.Combining the contents
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.
What merged cells break afterwards
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 — 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.
Where to start
Four ways in.
- “I want a heading across several columns.”
- Use Center Across Selection — then the spreadsheet itself
- “I want both cells’ contents together.”
- Different operation — see combining data
- “I inherited a sheet that will not sort.”
- Find the merged cells — when a sheet misbehaves
- “I already merged and lost something.”
- Go to when a sheet misbehaves
Combining data
Putting two values into one place without destroying either is a formula rather than a formatting command.
When a sheet misbehaves
Sorting that refuses, filters that miss rows, tools that error without explaining. Merged cells are the usual cause.
The spreadsheet itself
A sheet that is a document and a sheet that is a dataset want opposite things, and most problems come from confusing them.
The rest of Office
The same shape recurs: a command that looks cosmetic and changes the file underneath.
What this tower will not do
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.
Where this page got its facts
- Microsoft Support — Merge and unmerge cells in Excel, including the warning that the contents of the other cells are deleted, that an unmerged cell cannot be split, and the Find tip for locating merged cells — support.microsoft.com, read 22 August 2026.
Written by Alberto Gulotta
Founder and editor of AI Tools Primer, writing from Palermo, Italy. Thirty-five years of taking computers apart, starting with a Commodore 64 — the long version is on the about page.
Something wrong on this page? Write to aitoolsprimer@gmail.com and it gets fixed.
Written on 22 August 2026.
Independence and limits
No affiliate links and no paid placements anywhere on this site. Nobody pays to appear here, and no company has seen this page before you did.
This is general information, not professional advice. Where a page touches money, health, safety or the law, it names its source and the date it was read — and your situation may still differ. See the privacy page and the cookie policy.