Excel Merge Cells Greyed Out in a Table? Here’s Why

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, Merge & Center is usually greyed out because the selected cells are inside an Excel table: Excel does not allow merged cells within a table. To use merging, move the cells outside the table or convert the table to a normal range with Table Design > Convert to Range; if you need to keep the table’s sorting and filtering, use an unmerged layout instead.

Why Excel disables merging in a table

An Excel table is more than a block of cells with a particular color or border. It is a structured data range with features such as filter buttons, consistent column headers, automatic expansion when you add rows, and calculated columns. Those features depend on each row and column retaining a predictable shape. Merging cells would make some rows span different numbers of columns, which interferes with that structure.

For example, imagine a sales table with Date, Region, and Amount columns. If you merge the Region and Amount cells in one row, that row no longer has the same independent cells as the rows above and below. Sorting, filtering, adding records, and referring to table columns become less reliable or ambiguous. Excel prevents the merge rather than allowing a layout that could undermine those table behaviors.

This is different from ordinary worksheet cells. A range can contain merged cells, but once a range is formatted as an Excel table, merging inside its boundaries is not supported. The disabled command is therefore usually a restriction of the table, not a fault with Excel or your keyboard.

Check whether the selected cells are in a table

Click one of the cells where you want to merge. If Excel displays a Table Design tab on the ribbon, that cell belongs to a table. Depending on the ribbon layout or window size, the tab may appear only while a table cell is selected. You can also look for filter arrows in the header row, but those arrows alone are not conclusive because filters can be applied to ordinary ranges too.

Another clue is the formula bar or the table’s visual styling: banded rows and a named table range often indicate a table, but formatting can be copied to a normal range, so appearance by itself does not prove it. The contextual Table Design tab is the more useful check.

If only some of the selected cells are in the table, Excel may still disable merging because the selection crosses the table boundary. Select the exact cells again and check whether they fall within the table. A selection that includes a table cell and an adjacent worksheet cell is not a way to bypass the restriction.

Convert the table to a normal range

If the data no longer needs table behavior, convert the table to a range, then apply Merge & Center. In Excel for Microsoft 365 on Windows, use these steps:

  1. Click a cell inside the table.
  2. Open Table Design on the ribbon.
  3. Choose Convert to Range. If Excel asks you to confirm, choose Yes.
  4. Select the worksheet cells you want to merge.
  5. On the Home tab, open the Merge & Center menu and choose the appropriate merge command.

Conversion keeps the cell contents and generally retains the table’s visible formatting, but it removes the table object and its special behaviors. The filter controls, automatic table expansion, and table-specific column features are no longer available as table features. Formulas that used structured table references may be changed to ordinary cell references, so inspect important formulas afterward. Save a copy first if the workbook is important or shared with others.

Converting just to merge a heading can be more change than necessary. A safer layout is often to put the heading in a worksheet row above the table, leaving the table itself intact. You can then merge the heading cells outside the table, or center the heading without merging if the cells beneath it need to remain independently usable.

Keep the table and use a different layout

If sorting, filtering, and automatic expansion matter, do not convert the table solely to make the sheet look a certain way. Several alternatives can give a similar appearance while keeping every table cell separate:

  • Put a title above the table. Insert a worksheet row above the table and place the title in a cell outside the table. If you merge cells for presentation, ensure the merged area does not overlap the table.
  • Use Center Across Selection. Select the adjacent cells for the visual span, open Format Cells, choose the Alignment tab, and set Horizontal to Center Across Selection. This centers text across the selected cells without combining them into one cell. It is most suitable when the cells to the right of the text are empty.
  • Wrap the header text. Select the header cell and use Home > Wrap Text. Increase the row height or column width as needed instead of merging neighboring header cells.
  • Adjust widths and alignment. Widen a column, shorten a heading, or use left, center, or right alignment to make the table easier to read without changing its structure.
  • Use a text box for a visual heading. A text box can sit above the table without changing the cells used for data. Keep it out of the table’s header and records so it does not obstruct filtering or editing.

Center Across Selection is not the same as Merge & Center. With Center Across Selection, the text remains in its original cell and neighboring cells remain separate. With a merge, several cells become one larger cell. The first option is generally more suitable for a worksheet that must remain sortable and editable.

What merging changes and why it can cause trouble

When you merge a group of cells that contain data, Excel keeps the content of the upper-left cell and removes the contents of the other cells in the selection. For example, if A1 contains North and B1 contains West, merging A1:B1 keeps North and discards West. Copy the values elsewhere before merging if any of them matter.

Merged cells can also complicate common worksheet tasks. Sorting a range that includes merged cells of inconsistent sizes may be blocked, and selecting, filling, copying, or pasting into merged areas can be less predictable than working with ordinary cells. A merged heading can be harmless in a presentation sheet, but merged cells inside a list of records are usually a poor fit.

Do not merge table headers to make a multi-level heading. A table is designed around one header row with a distinct name for each column. Instead, add a descriptive title above the table and keep its actual column headings in the table header row. That preserves meaningful fields for filters and formulas.

If Merge & Center is still disabled outside a table

If Table Design does not appear when you select the cells, check other reasons the command may be unavailable. Excel’s ribbon can disable commands when the worksheet is protected, when you are editing a cell rather than selecting cells, or when the selection is not a suitable contiguous range. Press Esc to leave cell-editing mode, then select the cells again.

For a protected sheet, check the Review tab for the sheet protection controls. If you have permission, unprotect the sheet before changing its layout; if it is protected by someone else, ask the workbook owner rather than trying to work around the protection. Protection settings vary, and allowing cell selection does not necessarily permit formatting or merging.

Also check that the workbook is not in a state that prevents editing, such as being opened read-only. If the command remains unavailable, try selecting a small, adjacent group of ordinary cells in a blank area of the sheet. If merging works there, the original selection or its table status is the likely cause. If it does not, check protection and editing status before changing the workbook.

Windows, Mac, and Excel for the web

The main table restriction applies across current Excel versions: cells within an Excel table cannot be merged. On Windows, the conversion route is Table Design > Convert to Range. Excel for Mac also provides table design controls when a table is selected, though the ribbon presentation can differ; select the table first and look for the table design tab and its conversion command. The Home tab’s merge controls are also arranged somewhat differently across platforms.

In Excel for the web, table cells likewise cannot be merged as a way to bypass the table structure. The available ribbon commands can differ from desktop Excel. If you need to convert the table or adjust a complex layout and cannot find the relevant control in the browser, open the workbook in the desktop app, make the change there, and confirm the result before returning to the web version.

Frequently Asked Questions

Can I merge cells in an Excel table without converting it?
No. Excel does not support merged cells inside a table. Keep the table and use an unmerged layout, such as Center Across Selection or a title placed above the table.

Will converting a table to a range delete my data?
Converting to a range is intended to keep the cell data and formatting, but it removes table features such as automatic expansion and table-specific filtering behavior. Check structured-reference formulas and save a backup before converting an important table.

Does Convert to Range remove the table colors?
It generally leaves the existing formatting in place, so the cells may still look like a banded table. The range is no longer a table object, however, and its formatting will not behave like an automatically expanding table style.

Why does merging keep only one cell’s value?
Excel retains the upper-left cell’s content when merging a selection and discards content from the other cells. Copy or combine any values you need before merging.

Is Center Across Selection the same as Merge & Center?
No. Center Across Selection changes how text is displayed across adjacent cells; it does not merge them or discard their separate cell structure. It is often a better choice when the data must remain sortable.

Can I merge cells in an Excel table header?
No. Table header cells are part of the table, so they cannot be merged either. Use a separate title row above the table and keep one distinct header cell for each table column.

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.