Here’s the thing. Unifying cells in Excel isn’t just clicking a button. It’s about making your sheet look nicer without wrecking your data. Yeah, that’s a bit trickier than it sounds.
In short, by the end of this guide you’ll know how to merge (or “unify”) cells like a pro in Excel 2026.
What Unify Cells Even Means
Unify cells = make two or more little boxes (cells) act like one big box. Folks do this to center a title, make a label bigger, or just calm the chaos on screen. But heads up Excel only keeps one cell’s real data when you merge.
Quick tip: merging is mostly formatting. If you need all the text in one cell (not just fancy display), that’s a different approach.
So How You Actually Do It
Here’s the normal way:
- Click and drag across the cells you want to unify.
- Head up to Home → Merge & Center.
- Pick what you want:
- Merge & Center – makes one big cell with centered text
- Merge Cells – merges but keeps alignment as you had it
- Merge Across – merges rows separately if you’ve got many highlighted
Feels like magic, right? Kind of.
But Wait There’s a Twist
Only the value in the top-left cell stays. Everything else vanishes. Yup, Excel zaps the rest. So if your buddy Raj had names in A2 and B2 and you merged without thinking boom, lost B2. That once happened to me. I swear I heard Excel whisper “oops”.
So here’s a quick cheat list if you need the text too:
- Use a formula first: =CONCAT(A2, ” “, B2) keeps data and joins text.
- Or use =TEXTJOIN(“, “, TRUE, A2:B2) neat if there’s many cells.
When You Unmerge Cells
Sometimes you simply changed your mind.
- Click on the merged cell.
- Go Home → Merge & Center arrow → Unmerge Cells.
That’s it. You’re back to separate boxes.
Heads up the text stays only in the first cell now. So check the others if you need them.
Bonus Quick Tips
Here’s a snappy set of actions you can use right now:
- Shortcut to merge & center: ALT + H + M + C (yep, old school but it works).
- Want to appear merged but keep sort/filter working? Try Center Across Selection via Format Cells it looks nice without wrecking your sheet. (Pro tip from power users.)
- If merge feels sloppy maybe Excel’s table features or text formulas fit your needs better.
One Mini Story
I was cleaning up a report for my team. Tons of tiny headers. So I hit Merge & Center it looked so clean. Then I tried sorting the data and everything went nuts. Yeah, a mess. So I switched to center-across-selection instead. Looked just as good and behaved better. Lesson learned.
FAQ’s
Do merged cells stop sorting?
Kinda usually, yeah. Merged cells tend to mess with sorting and filtering.
Can I merge without losing text?
Yep. Use CONCAT or TEXTJOIN first, then paste values where you want.