Excel can hunt these down for you. On desktop, open Find, choose Format, then Alignment, tick Merge cells and run Find All to see the full list. The web app has no equivalent dialog, so look for a lit-up Merge and Center button. A sort that refuses to run is the classic giveaway.
It usually starts with an error. You try to sort a column and Excel refuses, or an edit won't behave, and the cause turns out to be a merged cell hiding somewhere in the data. Microsoft's page on how to find merged cells gives a quick way to list every one, and the steps are below.
The quick route on desktop Excel
- Go to Home, then Find & Select, then Find.
- In the Find dialog, select Format.
- Choose Alignment, then Merge cells.
- Confirm with OK, or Close in some versions.
- Select Find All.
Excel now shows a list of all merged cells on the worksheet. Click an entry and Excel selects that merged cell in the sheet, ready for you to unmerge it. Work down the list and you'll have found every one, which is far quicker than scanning a big worksheet by eye and hoping you've spotted them all. It's also more reliable, because a merged cell can hide in a corner you'd never think to check.
The web version works differently
The web app lacks that dialog, so you inspect cells one at a time. Click a cell and look along the Alignment group, where a highlighted Merge and Center button gives it away.
It's slower, but it's the route Microsoft describes for the web, and for a short list it does the job.
How to unmerge once you've found them
Pick the merged cell, use the dropdown beside Merge & Center and choose Unmerge Cells. Microsoft's guide to merging and unmerging cells covers the detail, including what gets lost.
The two catches to know about
- Excel doesn't sort data in a column that contains merged cells. That's why a failing sort is such a reliable clue that one is hiding.
- Merging wipes out text: only one entry survives, and unmerging can't restore the rest.
So before you merge anything, copy out whatever you can't afford to lose. And before you blame something else for a stubborn sort, run Find All and see what turns up. It takes seconds, and it either finds the culprit or rules it out.
Why merged cells cause so much trouble
Merging looks tidy, which is why it's tempting for headings and labels. The drawback is that the grid stops behaving like a grid. A sort needs every row and column to line up, and a merged cell breaks that, which is exactly why Excel declines to sort a column that contains one.
The other downside is permanent. Merging keeps only one cell's contents and deletes the contents of the others, so a merge done carelessly can wipe out data you meant to keep. Both problems are easier to spot early than to repair late.
- Run Find All whenever a sort or edit fails for no obvious reason.
- Unmerge anything that doesn't need to be joined.
- Copy out your entries before joining cells that hold different text.
A worked example: a sort that won't run
Say you've got a table of orders and a heading cell spans several columns. You select the column and try to sort, and Excel declines. Open Find, choose Format, pick Merge cells under Alignment, and click Find All. The list shows the culprit.
Want AI doing the heavy lifting in your marketing?
I build the systems that handle the boring 80 percent, so you get your week back. Done properly, with the human kept in.
Click it, unmerge it, and try the sort again. If the merged cell held text you needed, remember that only the first cell's contents survived the original merge, so you'd retype the rest. It's a small job once the cell is found, and the hunt is the hard part, which is what Find All is for.
If you're cleaning a sheet generally, the guides to splitting cells in Excel and merging cells cover the reverse jobs, and Find and Replace is a useful next tool.
Frequently asked questions
Why won't Excel sort my column?
A column with merged cells won't sort until they're unmerged.
Can I jump to each merged cell from the results?
Yes. Picking an item in the list selects that cell in the worksheet, so you can unmerge it straight away.
How do I check in Excel for the web?
Click a cell and look for a lit Merge and Center.
Will unmerging restore my text?
No. Merging removed the contents of every cell except one, and unmerging can't undo that.
Where's the unmerge command?
On the Merge & Center down arrow, labelled Unmerge Cells.
What if my dialog says Close instead of OK?
Some versions label that button Close. Use whichever yours shows to confirm the Merge cells choice.
