Let’s break down everything “Excel merge” — from the dangerous Merge & Center to the safe and powerful alternatives. What it does: Combines selected cells into one large cell and centers the content.

But here’s the secret: You just need the right technique for the right job.

We’ve all been there. You want to create a clean header row or combine a first name and last name column, so you click that tempting “Merge & Center” button. And then... disaster. Only the upper-left cell’s data remains. Everything else vanishes.

If you have more than one cell with data, Excel keeps only the top-left value and deletes the rest. No warning. No undo (after save). Just gone.

Happy Excelling — and safe merging.

✅ Only for blank cells or a single value (e.g., creating a title row over empty columns). ❌ Never for combining multiple data-filled cells (like names, addresses, or numbers). 2. The Safe Merge: Merge Across (No Data Loss) If you need to merge cells row by row without losing information, Merge Across is your friend.