How to Merge Cells in Excel in Table Format

How-to basics · Updated November 18, 2026

In Microsoft Excel for Microsoft 365 on Windows, you cannot merge cells inside a formatted Excel Table. To merge them, select a cell in the table, choose Table Design > Convert to Range, confirm, then select the cells and use Home > Merge & Center. If you only want a heading to look centered across columns while keeping the table intact, use Center Across Selection instead.

What You’ll Need

  • An Excel workbook containing the cells you want to combine. Save a copy first if the data matters, because merging can discard cell contents.
  • Permission to convert the Excel Table to a regular range if the cells are currently part of a table. You can skip this if the range only has table-style formatting and is not an actual Excel Table.
  • Microsoft Excel for Microsoft 365 on Windows for the menu paths below. Excel for Mac has similar commands, though ribbon labels and placement can differ slightly.

Step-by-Step

  1. Check whether the cells are in an actual Excel Table. Click one of the cells you want to merge. If a contextual Table Design tab appears on the ribbon, the selected cell belongs to an Excel Table. A colored, banded range by itself does not prove it is a table: Excel’s table styles can also be copied or applied to ordinary ranges. This distinction matters because Excel does not allow merged cells within an actual table.
  2. Decide whether merging is the right choice. Merging is useful for a single title spanning several columns, but it is usually unsuitable for the rows and columns that hold sortable or filterable records. A merged area becomes one cell, and Excel keeps only the content in its upper-left cell. If you need the table’s filtering, structured references, or automatic expansion, leave the cells unmerged and use the visual alternative described in the Tips section.
  3. Convert the table to a normal range if necessary. Click a cell in the table, open Table Design, and choose Convert to Range in the Tools group. Confirm the prompt by choosing Yes. The data and much of its visible formatting remain, but it is no longer an Excel Table. Table-specific functions, such as automatic expansion and structured table references, will no longer work in the same way. If the ribbon is narrow, look for the command in the Tools area or widen the Excel window.
  4. Select the cells to merge. Drag across the adjacent cells, or click the first cell and hold Shift while selecting the last. For example, to create one heading across columns A through D in row 1, select A1:D1. Do not select entire rows or columns unless that is genuinely what you intend to merge. Check that the selection contains only the cells you want to turn into one cell.
  5. Check the contents before merging. If multiple selected cells contain text, numbers, or formulas, copy any content you need to keep somewhere safe. Excel does not combine the contents into a sentence or preserve each value in the merged result; it keeps the upper-left cell’s value and removes the contents of the other selected cells. If those other cells contain information, cancel and move or combine it into a separate cell before proceeding.
  6. Merge the selected cells. On the Home tab, find the Alignment group and open the arrow beside Merge & Center. Choose Merge & Center to make one cell and center its content. Choose Merge Cells if you want one cell but do not want Excel to center the content. Use Merge Across when you want separate merged areas for each row of a multirow selection. The button may display a different default command, so use its drop-down arrow to choose the exact action.
  7. Review the result and adjust formatting. Confirm that the intended content remains, then set alignment, wrapping, font, borders, and column widths as needed from the Home tab. A merged cell may not display all its text if the row height is fixed or the merged area is too narrow. Use Wrap Text or adjust the row height and column widths. Save the workbook when the layout is correct.

Excel for Mac: The basic process is the same: convert an actual table to a range using the contextual table tab’s Convert to Range command, then select the cells and use the merge command on the Home tab. Depending on the Excel for Mac ribbon layout, the contextual tab may be labeled Table rather than Table Design. If a command is not visible, expand the ribbon or use Excel’s command search. In Excel for the web, use the desktop app if you cannot find a table conversion command or need to preserve workbook features reliably.

Common Mistakes

  • Trying to merge cells without converting the table. Excel disables or refuses merging inside a real Excel Table. Convert the table to a range first, or keep it as a table and use Center Across Selection for a heading that only needs a merged appearance.
  • Assuming Merge & Center combines the text. It does not join values from separate cells. Only the upper-left cell’s content remains after a merge. Copy or relocate other values first, and verify the selection before confirming.
  • Merging cells in the middle of a data list. A data table works best when each record occupies one row and each field has its own column. Merged cells can interfere with sorting, filtering, selecting, copying, and adding records. Keep merged cells for titles or presentation areas outside the main data body.
  • Converting a table without considering what depends on it. Formulas using structured references, table-specific behavior, and automatic table growth can be affected. If other sheets or reports rely on the table, check those dependencies before converting. Undo may reverse a recent action, but it is not a substitute for saving a backup before a major layout change.
  • Selecting more cells than intended. A selection that includes a neighboring label or value can merge it into the same cell and remove its contents. Read the selection outline and check the upper-left cell before choosing a merge command.

Tips

  • Use Center Across Selection for a heading that only needs to look merged. This keeps each cell separate and preserves the table structure. Select the cells across which the heading should appear, open the Alignment dialog launcher on the Home tab, choose the Alignment tab, set Horizontal to Center Across Selection, and select OK. The heading text should be in the leftmost selected cell. This changes the visual alignment; it does not create one larger cell.
  • Put a report title above the table. If the title should span the same columns as a table, insert a blank row above the table and put the title there. You can merge cells in that separate row without changing the table’s data area. Keep the table’s header row intact so every column has its own field name.
  • Consider Merge Across for repeated row labels. When you select a block several rows high and choose Merge Across, Excel merges the selected cells horizontally within each row rather than creating one tall merged cell. Check the selection carefully: each row’s merged area still keeps only its own leftmost cell’s content.
  • Keep a recoverable copy. Before converting a table or merging cells, save a separate copy of the workbook or duplicate the worksheet. This gives you a way back if a formula, report, or layout relies on the original table. If you are unsure whether a selection contains data, inspect it before using the merge command.
  • Prefer a consistent data structure over decorative merges. For a worksheet used for analysis, keep one value per cell and use bold text, fill color, borders, or alignment to distinguish headings. Those formats can make a report clear without making cells harder to sort, filter, or reference.

Troubleshooting

  • Merge & Center is dimmed or unavailable: First check whether the selection is inside an Excel Table. Click within it and look for the contextual Table Design tab; if it appears, use Table Design > Convert to Range and confirm. If the selection is not in a table, check whether the worksheet is protected or whether you selected an unusual range. Remove sheet protection if you are authorized to do so, or select a simple group of adjacent cells and try again.
  • Excel says merging keeps only the upper-left value: That is expected. Cancel if you need all the contents, then copy them to another location or combine them in a separate cell before merging. Do not proceed on the assumption that Excel will concatenate values automatically.
  • The heading disappears or appears wrong after merging: Excel retains the upper-left cell’s content. If the text was in another selected cell, undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then move the text to the selection’s upper-left cell and merge again. If the text is present but hard to see, check font color, horizontal alignment, wrapping, and row height.
  • The merged cells are difficult to sort or filter: Merged cells are a poor fit inside a list of records. If the merge was just made, use Home > Merge & Center > Unmerge Cells or press Ctrl+Z on Windows (Command+Z on Mac) if it is the latest action. For future headings, use Center Across Selection or place the heading outside the data area. If the table was converted to a range, recreating it with Insert > Table may be possible after removing merges and checking that the data has one header per column.
  • The table’s formulas or behavior changed after conversion: Converting a table to a range removes table-specific behavior. If the change is recent, undo it; otherwise, use the saved copy to restore the table, or recreate the table after fixing the merged layout. Review formulas that used structured references and check whether new rows still receive the expected formatting or formulas.
  • You cannot find the table or merge command: Click a cell in the relevant area and look for the contextual tab; it only appears when a table cell is selected. Expand the ribbon if it is collapsed, or use the search box at the top of Excel to locate a command. If you are in Excel for the web and a command is unavailable, open the workbook in the desktop app.

Frequently Asked Questions

Can I merge cells inside an Excel Table?
No. Excel Tables do not support merged cells in their table area. Convert the table to a range first, or use Center Across Selection to create a similar centered look without merging.

Will converting a table to a range delete my data?
Converting changes the table into a normal cell range; it does not ordinarily delete the values. However, table features such as structured references and automatic expansion are affected, so save a copy and check formulas and dependent reports first.

Does Merge & Center combine the contents of every selected cell?
No. It keeps the value in the upper-left cell and removes the contents of the other selected cells. Move or combine any information you need to retain before merging.

Can I merge cells without losing the table’s filtering and sorting features?
Do not merge cells in the table’s data area. Keep the Excel Table and use Center Across Selection for a visual heading, or place a merged title in a separate row above the table.

What is the difference between Merge Cells and Merge & Center?
Both create a single cell from the selected cells and keep only the upper-left content. Merge & Center also centers that content; Merge Cells does not apply that centering automatically.

How do I undo a merge?
Select the merged cell and choose Home > Merge & Center > Unmerge Cells. Unmerging restores the individual cells but does not bring back values that were removed from the other cells. Use Ctrl+Z on Windows or Command+Z on Mac immediately after merging if you need to undo the action and recover the prior contents.

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.