Can You Merge Cells in an Excel Table? What to Do Instead

How-to basics · Updated November 18, 2026

No. In Microsoft Excel for Microsoft 365 on Windows, you cannot merge cells that are part of an Excel table. If you need a merged heading or layout, put it outside the table, or convert the table to a normal range first; converting removes table features such as automatic filtering and structured references.

Why Excel tables do not allow merged cells

An Excel table is more than a colored range. It is a structured data area: each column has one header, each row represents a record, and Excel can sort, filter, expand, and refer to the data as a unit. Merging cells conflicts with that consistent grid. A merged area may cover several columns or rows, leaving Excel without a clear, separate value for each affected field.

For example, imagine a sales table with columns for Date, Region, Product, and Revenue. If you merge the Region and Product cells in a row to make the layout look cleaner, Excel can no longer treat those cells as two independent fields in that record. Sorting or filtering the data relies on each row having values in the same column positions. Merged cells make that structure ambiguous and can also interfere with pasting, selecting, and expanding table data.

This restriction applies to cells inside the table, not every cell on the worksheet. You can merge ordinary worksheet cells above, below, or beside a table, provided the merged area does not overlap the table. A common solution is to place a report title above the table and leave the table itself as a regular, unmerged grid.

How to tell whether a range is an Excel table

A range can look like a table because it has colored rows, borders, or bold headings, but those visual features alone do not establish that it is an Excel table. Click a cell in the data area. If a contextual Table Design tab appears on the ribbon, the selected range is a table. The tab may be called Table or have a slightly different label in some Excel editions or localized versions.

Other clues include filter arrows in the header row, automatic formatting on newly added rows, and formulas that use a table name and column labels. For instance, a formula may refer to Sales[Revenue] rather than a worksheet address such as D2:D50. These clues are helpful, but the contextual tab is the clearest check.

If the range is only formatted to look like a table, merging may be allowed because it is not a structured Excel table. That does not mean merging is a good idea in a data range: merged cells can still cause problems with sorting, filtering, copying, and formulas.

What happens when you try to merge cells inside a table

Excel prevents a merge that would affect cells in a table. Depending on how you select the cells and which Excel build you use, the merge command may be unavailable or Excel may display a message explaining that the operation is not allowed. The practical answer is the same: the table must remain an unmerged grid.

Do not confuse this rule with merging cells in a regular worksheet range. Outside a table, the Home tab has the Merge & Center command and its dropdown options. Those commands can combine ordinary cells, but they do not override the table restriction. If a selection partly overlaps a table, adjust it so that it is entirely outside the table or choose a different layout.

There is also an important data-loss issue when merging ordinary cells: Excel keeps the content from the upper-left cell of the selected area and removes content from the other cells. A warning may appear, but do not assume all values will be preserved. Copy or combine any needed contents before using a merge command.

Convert the table to a range before merging

If merging is essential and you no longer need the range to behave as a table, you can convert it to a normal range. In Excel for Microsoft 365 on Windows:

  1. Click any cell in the table.
  2. Open Table Design on the ribbon.
  3. In the Tools group, select Convert to Range.
  4. Confirm the prompt asking whether you want to convert the table to a normal range.
  5. Select the worksheet cells you want to merge, then use Home > Merge & Center or the dropdown beside it to choose another merge option.

On Excel for Mac, select a table cell and look for Table Design > Convert to Range; ribbon wording and placement can vary by version. Then select the cells and use the merge command on the Home tab. The change from table to range is the key step on both platforms.

Conversion keeps the cell values and generally retains the table’s existing appearance, but the range is no longer a table. You can still sort or filter ordinary ranges using worksheet commands, but you lose table-specific behavior such as automatic expansion, table style controls, and structured table references. Check formulas that refer to the table, as Excel may convert structured references to ordinary cell references. Save a copy first if the workbook depends on those features.

Alternatives that keep the table intact

Often, the goal is visual rather than structural: a heading should span the width of several columns, or text should look centered over a group. You can usually achieve that without merging the table’s cells. Keeping the grid intact preserves the table’s usefulness for analysis and makes later edits less fragile.

  • Put a title above the table. Insert a blank worksheet row above the table and place the report title there. If desired, merge cells in that separate row, making sure the selected cells do not overlap the table.
  • Use Center Across Selection for a heading outside the table. Select the ordinary cells across which the text should appear, open Format Cells from the Home tab’s Alignment controls, and choose Center Across Selection in the Horizontal alignment list. This centers the text visually without combining the cells. It is not a way to merge cells within the table.
  • Use the table’s own header row. Give each column a distinct, concise label, such as “Q1 Sales” and “Q2 Sales,” rather than making one header occupy multiple columns. A table needs a separate header for each field.
  • Add a group label outside the table. If several columns belong to a section, add a label above the table and use borders, fill color, or an underline to show which columns it describes.
  • Adjust alignment and wrapping. Use horizontal alignment, Wrap Text, column widths, or row heights to improve readability while leaving each cell separate.

For example, a report may have four quarterly columns under an “Actual results” heading. Keep all four column headers separate in the table, then add “Actual results” in a worksheet row above the table and format that heading across the same width. Sorting and filtering continue to operate on the actual table headers, not on a merged label.

Why keeping the table structure matters

Tables are useful when data will be updated, analyzed, or shared with other tools. A new row entered directly below a table can become part of it, and table formulas and formatting can extend automatically. Header filters let readers isolate records, while structured references can make formulas easier to understand. A merged cell inside that grid would weaken the consistent one-value-per-field design these features rely on.

Consider a customer list with one row per customer. If several cells are merged to make a category label span multiple records, sorting by customer name could separate that label from the records it was meant to describe. A better arrangement is to repeat the category value on each relevant row, or keep category headings in a separate summary area. Repeated values may look less decorative, but they are much easier to filter, summarize, and use in a PivotTable.

Before converting a table, consider whether you need its features later. If the workbook is a one-time, print-focused report, a normal range may be sufficient. If people will add records or use filters, retaining the table and changing the design around it is usually the safer choice.

Undoing a merge and fixing common problems

If cells are already merged in a normal range, select the merged area and choose Home > Merge & Center > Unmerge Cells. Unmerging restores the individual cell grid, but it does not bring back values that were discarded when the cells were first merged. Check the upper-left cell and any backups or earlier versions if other contents mattered.

If a merge command is unavailable, check whether the selection is inside an Excel table, whether the worksheet is protected, and whether the selected area contains a mixture of merged and unmerged cells. A selection that crosses the table boundary can also be a source of confusion. Try selecting a small, clearly defined range outside the table to distinguish a table restriction from another worksheet issue.

If you converted a table and then decide you need table functionality again, select a cell in the range and use Insert > Table, or press Ctrl+T on Windows and confirm whether the range has headers. On Mac, the usual shortcut is Control+T; depending on keyboard settings, the Insert tab’s Table command may be easier to use. Before recreating the table, unmerge cells within the proposed range and make sure the header row has one label per column. A table cannot use a merged header area.

Frequently Asked Questions

Can I merge cells in an Excel table header?
No. Each table column needs its own header cell. Put a wider section heading in a worksheet row above the table, and leave the actual table headers unmerged.

Can I merge cells in a table after converting it to a range?
Yes. After converting the table to a normal range, you can merge cells as you would elsewhere on the worksheet. The range will no longer have table-specific features, and merging can discard values in cells other than the upper-left one.

Does converting a table to a range delete my data?
Conversion is intended to keep the cell contents and existing appearance, but it removes table behavior. Review formulas that use structured references and make a backup when the workbook relies on table features. The later merge itself can remove the contents of cells other than the upper-left cell.

Can I center a heading across table columns without merging?
Yes. Put the heading in a separate worksheet row above the table. You can use Center Across Selection on those ordinary cells, or simply format and align the heading without merging. Do not apply the merge to cells inside the table.

Why can I merge cells in a formatted range but not in a table?
Cell colors and borders do not necessarily make a range an Excel table. A structured table has data-management features and requires a consistent grid, so Excel blocks merging within it. Click the range and check for the contextual Table Design tab to confirm whether it is a table.

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.