How to merge cells in Excel (and when not to)

Merging cells is one of the most common formatting tasks in Excel—and one of the most misunderstood. People often confuse merging (joining cells visually) with combining (joining the text inside them). This guide covers both: how to merge cells in Excel for layout purposes, and how to combine cell content without losing data.

 

No time for reading a blog tutorial? Guidy is an AI for Excel that sees your screen and walks you through this in real time in less than one minute, in any language. Try now.

How to merge cells in Excel (the button method)

Select the cells you want to merge. Go to Home → Merge & Center. Excel joins the selected cells into one and centers the content. You'll also see a dropdown arrow next to the button with more options:

• Merge & Center: merges and centers the text.
• Merge Across: merges cells in each row separately (useful for multiple rows at once).
• Merge Cells: merges without centering.
• Unmerge Cells: splits them back.

 

Warning: When you merge cells, Excel keeps only the value in the upper-left cell. Everything else gets deleted. If your cells contain data you need, read the "without losing data" section below first.

 

How to merge cells in Excel without losing data

This is the most common frustration: you merge two cells and one value disappears. Excel only keeps the top-left cell's content.

To merge cells in Excel without losing data, you need to combine the content first, then merge. Here's how:

1. In a helper cell, type: =A1 & " " & B1 (this joins the text with a space between them).
2. Copy the result and paste it as a value (Ctrl + Shift + V).
3. Delete the original cells' content.
4. Now merge — nothing is lost because the combined text is already in one cell.

Or use TEXTJOIN for more than two cells: =TEXTJOIN(" ", TRUE, A1:D1)

Shortcut to merge cells in Excel

There's no built-in keyboard shortcut for merging, but you can use the Alt key sequence:

Alt → H → M → C (press them one after the other, not together)

This triggers Home → Merge & Center from the ribbon. Once you've done it once, you can also repeat it instantly with Ctrl + Y on the next selection.

Cool fact: Skipping tutorials is now possible! Get real-time help, right on your PC - in any language, for all software and browsers. Download Guidy now.

 

How to combine cells in Excel

Combining is different from merging.

When you combine cells in Excel, you're joining the text content into one cell, not formatting them into a single block. The formula to combine two cells in Excel is simple:

=A1 & " " & B1

This joins whatever is in A1 and B1 with a space. You can swap the space for a comma, dash, or anything else.

 

For combining two cells in Excel when you have first name and last name, for example:

=A2 & " " & B2 → "John Smith"

 

If you have more than two cells, use TEXTJOIN:

=TEXTJOIN(“, “, TRUE, A1:E1)

This joins everything from A1 to E1 with commas, skipping any empty cells.

Why can't I merge cells in Excel?

If the Merge button is greyed out, it's usually one of these:

• You're inside a Table: Excel Tables don't allow merged cells. Convert it to a normal range first (Table Design → Convert to Range).
• The sheet is protected: Unprotect the sheet under Review → Unprotect Sheet.
• You're editing a cell: Press Enter or Escape first to exit edit mode, then try merging.

Key takeaways

Use Merge & Center for visual formatting, and the & operator or TEXTJOIN for combining text content. If you need to merge without losing data, combine the content first using a formula, then merge the cells.

 

Need instant help with this? Try Guidy.

It sits right on your screen and walks you through it—step by step, in real time, pointing at exactly what to click. Done in a few minutes, no plug-ins needed.