Combine Cells in an Excel Table: Merge or Join Data

How-to basics · Updated November 18, 2026

In Microsoft Excel, you cannot merge cells inside a formatted Excel Table. To make a merged cell, first convert the table to a normal range, then select the cells and choose Home > Merge & Center. If you only want to combine the contents of cells, use a formula instead; that keeps every table row and column intact.

That distinction matters: merging changes the cell layout, while joining combines text or values. The steps below help you choose the right method and avoid losing data or making a list difficult to sort and filter.

What You’ll Need

  • Excel for Microsoft 365 on Windows, or a version of Excel with the Table Design and Merge & Center commands.
  • A saved copy of the workbook before changing a table that contains important data.
  • If you are merging cells, a clear plan for which cell’s contents to keep. Excel preserves the upper-left cell’s contents and discards contents in the other selected cells.

Step-by-Step

  1. Decide what you mean by combine. If you want a single larger cell for a heading or visual layout, you mean merge. If you want to put two or more cell values together, such as a first and last name, you mean join. If you want a label centered over several columns without changing the grid, use Center Across Selection. A formal Excel Table supports neither merged cells within its table area nor the usual merge command there, so choose the approach before editing.
  2. Check whether your data is an Excel Table. Click a cell in the data. If a contextual Table Design tab appears on the ribbon, it is a formatted Excel Table. The table commonly has filter arrows in its header, but filters alone do not prove it is a Table. If you only have a regular range with borders or colors, you can select cells directly and use the merge steps in step 5 without converting anything.
  3. Make a copy and inspect the cells. Save the workbook, or create a duplicate sheet before changing a valuable table. Identify the exact cells to merge and note their contents. When Excel merges a selection, only the value or formula in its upper-left cell remains; values in the other cells are removed. If you need all of them, copy the values elsewhere or join them into one cell before merging. Also check whether the area is part of a dataset that people need to sort, filter, or expand.
  4. Convert the Excel Table to a normal range if a true merge is essential. Click any cell in the table, open Table Design, and choose Convert to Range. Confirm the prompt by choosing Yes. The rows and values remain on the sheet, but table features such as automatic expansion, table styles, and structured table behavior are removed. Existing formulas, filters, and formatting may need attention after conversion. This change is necessary because Excel does not allow merged cells within a formal Table.
  5. Select only the cells you intend to merge. Drag across the adjacent cells, or click the first cell and Shift-click the last. Merging works on a contiguous rectangular selection, such as B2:D2. Avoid selecting entire columns or multiple unrelated rows by mistake. If you select more than one row and choose Merge & Center, Excel may merge each row across its selected columns, which is different from making one large cell across the whole block.
  6. Choose the merge behavior. On the Home tab, open the dropdown beside Merge & Center. Choose Merge & Center to make one centered cell, Merge Cells to merge without centering, or Merge Across to merge each selected row separately. Use the plain merge option if you do not want Excel to change alignment. Review the result immediately and use Undo if the wrong cells were merged.
  7. Finish the layout and check the workbook. Adjust alignment, wrapping, column width, row height, and borders as needed. Try sorting and filtering if the converted range still needs those operations. If the data must remain a proper Excel Table, do not leave merged cells in its data area. Unmerge the cells first, then select the range and use Insert > Table or press Ctrl+T on Windows to create a table again. Confirm that the range and header setting are correct.

For a heading above a table, you can usually avoid converting the data. Put the heading in a row outside the table and merge the cells in that row only. If the worksheet does not have a spare row, make space outside the table before merging; check the table boundary afterward so the heading has not become part of the table.

On Excel for Mac, the commands are also on the ribbon: use Table Design > Convert to Range, then Home > Merge & Center. In Excel for the web, ribbon options can differ by build. If you cannot find the conversion or merge command, open the workbook in the desktop app for these layout changes. Keyboard equivalents also differ: Ctrl+T creates a table on Windows, while Command+T is commonly used for a table on Mac; use the ribbon if a shortcut behaves differently in your version.

If the goal is to combine text while retaining a table, leave the cells separate and create a result in a new column. With a first name in A2 and a last name in B2, enter =A2&" "&B2 in C2. For example, if A2 contains Maya and B2 contains Chen, the result is Maya Chen. In a Table, enter the equivalent formula in the first row of a new column; Excel will usually fill the calculated column for the other table rows. The source values stay in their own cells, so sorting and filtering still work normally.

Common Mistakes

  • Trying to merge cells inside a Table. Excel disables or blocks merging in the Table area. Convert to a range only if the layout benefit is worth losing Table features; otherwise use a formula or a heading outside the Table.
  • Assuming a merge combines the contents. A merge combines the selected cell area, not the text inside the cells. Excel keeps only the upper-left cell’s content. Copy or join the other values first if they matter.
  • Merging cells in the middle of a sortable list. Merged areas can prevent sorting or produce errors because rows no longer have a consistent cell structure. Keep records in one value per cell and reserve merges for presentation areas.
  • Selecting a large block unintentionally. Merge Across acts row by row, while other merge choices can create a different shape than expected. Check the selection outline before choosing a command.
  • Converting a Table without checking what depends on it. Structured references, automatic formula filling, banded styles, and automatic range expansion may change or be lost. Review formulas, filters, and formatting after conversion, and keep an original copy.

Tips

  • Prefer a centered heading over merged data cells. A title in a separate row above the data looks organized without disrupting the rows that need to be sorted.
  • Try Center Across Selection when appearance is the only goal. Select the cells, press Ctrl+1 on Windows, choose the Alignment tab, set Horizontal to Center Across Selection, and choose OK. On Mac, Command+1 opens Format Cells. This centers the leftmost cell’s content across the selection without actually merging cells. It is formatting, not a way to combine values.
  • Keep source data normalized. Store one item per cell in a working dataset, such as one name per column. Create a separate display column for combined text, rather than merging cells that contain records.
  • Use Undo promptly. Ctrl+Z on Windows or Command+Z on Mac reverses a recent merge. Undo may not be available after closing the workbook or making many later changes, so a saved copy is a safer fallback.
  • Use clear labels for joined results. If you combine fields with a formula, give the new column a useful header such as Full Name. Check that blank source cells do not create unwanted spaces or separators in your chosen formula.

Troubleshooting

Merge & Center is grayed out or will not work: Click a cell and see whether Table Design appears. If the selection is inside a formal Table, convert it to a range using Table Design > Convert to Range, or keep the Table intact and use a formula or a heading outside it. Also make sure the worksheet is not protected; if it is, you may need permission to unprotect it before changing cell layout.

Excel says it will keep only the upper-left value: That is expected. Cancel if you still need the other values, then copy them or combine them into a separate cell first. After confirming the surviving value, merge the selection. Do not assume Excel will concatenate the contents for you.

The merged heading looks off-center or text is cut off: Check the horizontal and vertical alignment, turn on Wrap Text if the heading needs multiple lines, and adjust the row height or column widths. A merged cell’s displayed width comes from the combined columns, but its row height may not expand as expected for wrapped text. You can also use Center Across Selection to preserve separate cells.

Sorting or filtering stopped working after the change: Merged cells in a data area are likely the cause, or converting the Table removed its normal filter controls. Use Home > Merge & Center > Unmerge Cells to undo the merges, restore one record per row, and apply filters again with Data > Filter. If you need Table features, recreate the Table only after the range has no merged cells.

The table formatting or formulas changed after conversion: Converting to a range keeps the cell values, but it removes Table functionality and can alter how formulas or styles behave. Compare the result with your saved copy. If you need automatic table behavior, undo or restore the copy, remove the need for merging, and keep the data formatted as a Table.

Frequently Asked Questions

Can you merge cells in an Excel Table?
No. Excel does not allow merged cells inside a formal Excel Table. Convert the Table to a range before merging, or use a formula or a separate heading if the Table must stay intact.

Will converting a Table to a range delete its data?
No. The cell values remain, but Table features such as automatic expansion and structured table behavior are removed. Save a copy first and check formulas, filters, and formatting afterward.

Does Merge & Center combine the text from every selected cell?
No. It keeps the content from the upper-left cell and removes content from the others. To combine text, use a formula in another cell or copy the values together before merging.

Can I merge cells without centering the text?
Yes. Open the dropdown beside Home > Merge & Center and choose Merge Cells. You can set alignment separately using the alignment controls on the Home tab.

How do I center a heading over columns without merging them?
Use Center Across Selection from Format Cells > Alignment. Select the cells, open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, then choose Center Across Selection under Horizontal. The cells remain separate.

What is the safest way to combine first and last names in a Table?
Keep First Name and Last Name in separate columns and add a Full Name column with a formula. This combines the displayed text while preserving the Table’s row structure for sorting, filtering, and updates.

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.