Excel Want to Merge? How to Combine Cells

How-to basics · Updated November 22, 2026

Yes, you can merge cells in Excel, but it is rarely the best way to combine data. The Merge & Center button (on the Home tab, in the Alignment group) merges selected cells into one, keeping only the top-left value. For most tasks, you are better off using the CONCAT, TEXTJOIN, or & operator to combine values into a single cell without losing data. This article explains both approaches, when to use each, and the common pitfalls.

What Merge & Center Actually Does

When you select two or more adjacent cells and click Home > Merge & Center, Excel combines them into a single cell that spans the original range. The text is centered horizontally. Only the upper-left cell’s content survives; all other selected cells are cleared. If those cells contained data, Excel shows a warning: “Merging cells only keeps the upper-left value and discards the other values.”

For example, if A1 contains “Total” and B1 contains “Sales”, merging A1:B1 results in a single cell with “Total” and “Sales” is gone. This is fine for a title or label, but destructive for data.

Other options in the same dropdown:

  • Merge Across – merges each row’s selected cells separately (useful for headers across multiple columns).
  • Merge Cells – merges without centering the text.
  • Unmerge Cells – reverses the merge, but the original data is not restored (only the top-left value remains).

On Excel for Mac, the same options appear under Home > Merge & Center. On Excel for the web, the button is also on the Home tab, but some advanced options like “Merge Across” are not available.

When Merging Is Actually Useful

Merging is primarily a formatting tool, not a data tool. It is useful when you want a single label to span multiple columns or rows, such as:

  • A title across the top of a report (e.g., “Q3 Financial Summary” over columns A–F).
  • A group label that spans several sub-columns.
  • Centering a heading across a table without using the “Center Across Selection” alignment trick.

However, many Excel users avoid merging entirely because it complicates sorting, filtering, and using ranges in formulas. A common alternative is Center Across Selection: select the cells, press Ctrl+1 (Mac: Cmd+1), go to the Alignment tab, set Horizontal to Center Across Selection, and click OK. This visually centers the text without merging, so the cells remain independent.

How to Combine Cell Contents Without Merging

If your goal is to combine text from multiple cells into one cell (like first and last names), use formulas instead of merging. Here are the main methods:

Method 1: Ampersand (&) operator

With first names in A2 and last names in B2, use:

=A2&" "&B2

This returns “John Smith” in the formula cell. Add a space inside the quotes to separate the values.

Method 2: CONCAT function (Excel 2016 and later)

With the same layout, use:

=CONCAT(A2, " ", B2)

CONCAT replaces the older CONCATENATE and is simpler. It returns “John Smith”.

Method 3: TEXTJOIN function (Excel 2019 and later, Microsoft 365)

If you have a list of items in A2:A10 and want to join them with a comma and space, use:

=TEXTJOIN(", ", TRUE, A2:A10)

The second argument TRUE ignores empty cells. So if A2:A10 contains “Apples”, “Bananas”, “”, “Cherries”, the result is “Apples, Bananas, Cherries”.

Method 4: Flash Fill (no formula)

If you have a pattern, type the first combined value manually (e.g., in C2 type “John Smith”), then press Ctrl+E (Mac: Cmd+E) to have Excel fill the rest based on the pattern. Flash Fill works best when the pattern is consistent.

How to Merge Columns Without Losing Data

If you already have data in multiple cells and want to merge them into one cell, you must first combine the values using a formula, then optionally convert the formula result to a static value. Here’s a step-by-step approach:

  1. In a new column (say C), enter a formula to combine the values from A and B, e.g., =A2&" "&B2.
  2. Drag the formula down to fill the column.
  3. Select the formula cells, copy them (Ctrl+C), then right-click and choose Paste Special > Values (or press Ctrl+Shift+V in Microsoft 365). This replaces formulas with static text.
  4. Now you can delete the original columns A and B if you wish.

This method is safe because it preserves all data. If you use Merge & Center on cells with data, you will permanently lose the non-top-left values.

Common Problems and How to Avoid Them

Merged cells cause several well-known annoyances:

  • Sorting and filtering break – Excel warns that “This operation requires the merged cells to have the same size” and often refuses to sort.
  • Copy-paste issues – Pasting a range that includes merged cells can shift the layout unexpectedly.
  • Formulas and ranges – A formula like =SUM(A1:A5) will not work correctly if some cells in that range are merged, because merged cells only count as one cell.
  • Keyboard navigation – Arrow keys and Tab skip over merged cells, making data entry awkward.

To avoid these, use “Center Across Selection” for visual centering and use formulas to combine text. If you must merge, do it only for static labels, and keep the data in separate cells elsewhere.

Alternatives to Merging for Common Tasks

Depending on what you want to achieve, there is often a better tool:

  • Centering a title – Use Center Across Selection (as described above).
  • Combining first and last names – Use =A2&" "&B2 or =TEXTJOIN(" ", TRUE, A2:B2).
  • Combining a list with separators – Use =TEXTJOIN(", ", TRUE, range).
  • Creating a single address block – Use =A2&CHAR(10)&B2 (CHAR(10) inserts a line break; make sure Wrap Text is on).
  • Merging rows or columns – Use Power Query (Data > Get & Transform) to combine tables or columns without affecting the original data.

Frequently Asked Questions

Can I merge cells and keep all the text?
No, the Merge & Center command only keeps the upper-left value. To keep all text, combine the values with a formula first, then optionally paste as values.

How do I unmerge cells without losing data?
Select the merged cell, click Home > Merge & Center to unmerge. The data that was in the other cells before merging is gone permanently. If you have not yet merged, you can copy the data elsewhere first.

Why is Merge & Center grayed out?
This happens when the worksheet is protected or when you are editing a cell. Unprotect the sheet (Review > Unprotect Sheet) or press Enter to finish editing, then try again.

Is there a keyboard shortcut for merging?
There is no default single-key shortcut, but you can press Alt+H+M+C to merge and center (Windows). On Mac, use Option+H+M+C or add the command to the Quick Access Toolbar.

Does merging affect formulas that reference the merged cells?
Yes. A formula that references a range containing merged cells may return incorrect results or errors, because merged cells occupy multiple rows/columns but only one cell value. It is best to avoid merging in data ranges.

Can I merge cells in Excel for the web?
Yes, the Merge & Center button is available on the Home tab. However, some options like “Merge Across” are not available in the web version.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.