Excel Unable to Merge Cells? Causes, Fixes, and Alternatives

How-to basics · Updated November 21, 2026

If Excel is unable to merge cells, first check that you selected one continuous range, the cells are not inside an Excel table, and the sheet is not protected against formatting changes. In Excel for Microsoft 365 on Windows, select the range and use Home > Merge & Center; if merging is unavailable or unsuitable, use Center Across Selection to center a heading without combining cells.

Why Excel disables or rejects merging

The merge command depends on the selection and worksheet state. A button that is greyed out usually means Excel cannot apply the operation to what is currently selected or the sheet does not allow the required change. A command that is available but produces an unexpected result is more likely a data, layout, or selection issue.

  • The selected cells are in an Excel table. Excel does not allow merged cells inside a formatted table. Table features such as sorting and filtering rely on a consistent grid, which merging disrupts.
  • The worksheet is protected. Protection can prevent formatting changes, including merging. Whether formatting is allowed depends on the permissions set when the sheet was protected.
  • The selection is not one rectangular block. Merge commands apply to a continuous rectangular range, not to separate, nonadjacent selections.
  • You are editing a cell. If the insertion cursor is active inside a cell or the formula bar, finish or cancel editing before selecting a range and merging it.
  • The range contains existing merged cells. A selection that overlaps merges in an irregular way can make it hard to predict what Excel will combine. Unmerge the affected cells first, then select the intended range.

The first useful diagnostic is to click a blank cell, then select a small, ordinary rectangular range outside any table. If Merge & Center becomes available there, the issue is probably specific to the original selection or worksheet rather than Excel itself.

Check the selection and worksheet

Confirm that the selected area is contiguous: for example, A1:C1 is a single range, while A1:C1 plus E1:G1 is two separate ranges. Click once on the first cell, hold the mouse button, and drag to the last cell, or click the first cell and Shift-click the last. Avoid including cells from a second, separate block.

Next, look for signs that the range belongs to a table. A table often has filter arrows in its header and a Table Design tab when a table cell is selected. To make merges possible, you can convert the table to a normal range in desktop Excel for Windows: select a table cell, choose Table Design > Convert to Range, and confirm. This keeps the cell contents and formatting, but removes table behavior such as automatic expansion, structured references, and built-in filtering controls. Consider whether those features matter before converting.

For protection, open Review and check whether the available command says Unprotect Sheet. If you have permission and the password, unprotect the worksheet, apply the merge, and protect it again if needed. If the sheet owner allowed formatting cells while protecting the sheet, merging may still be permitted; protection settings vary, so a greyed-out button is not proof that every protected sheet blocks merges.

How to merge cells in Excel for Microsoft 365

Once the range and worksheet are ready, use the merge menu on the Home tab. The main options have different effects:

  • Merge & Center combines the selected cells and centers the remaining content in the resulting area.
  • Merge Across merges cells row by row. Selecting A1:C2, for example, creates one merged range across A1:C1 and another across A2:C2; it does not make one large A1:C2 block.
  • Merge Cells combines the selected area but does not apply centering automatically.
  • Unmerge Cells separates an existing merged area back into individual cells.

To merge a heading across a row, select the cells, choose Home > Merge & Center, and review the result. If Excel warns that only the upper-left value will be kept, stop and check the range before accepting. After merging, you can change horizontal or vertical alignment from the Alignment group on Home, and adjust row height or column width if the text is clipped.

In Excel for Mac, select the cells and use the merge controls on the Home tab; the exact ribbon arrangement can differ slightly with window size and ribbon customization. Excel for the web also provides merge controls on Home, though some dialog and formatting options available in desktop Excel may be presented differently. If a command is missing in any edition, check the current selection and whether the sheet is protected or the cells are in a table.

What happens to data when cells are merged

Merging is not a way to combine the contents of several cells. Excel keeps the value or formula from the upper-left cell of the selected range and discards content in the other cells. If you merge A1:C1, the content in A1 remains; entries in B1 and C1 do not become part of the merged cell. Excel normally displays a warning when those other cells contain data, but do not rely on a warning as a substitute for checking.

Before merging a range that may contain information, inspect every cell or make a copy of the data elsewhere. If the goal is to preserve several entries as one readable string, combine them in a separate cell with an appropriate formula or use a text-editing process first; merging alone will not join them. Keep an original copy if the contents are important, especially in a shared or operational workbook.

After a merge, the merged area is represented by its upper-left cell for many worksheet operations. For example, a formula referencing B1 in a merged A1:C1 area does not retrieve a separate value from the visually covered B1 position. Merged layouts can therefore surprise users who later write formulas, copy data, sort records, or select cells by address.

When merging creates later problems

A worksheet can look tidy after a merge and still become harder to maintain. Sorting a list with merged cells can fail or behave awkwardly because the merged blocks do not match the uniform row structure that sorting expects. Filtering, copying and pasting, selecting ranges, and filling formulas can also be less predictable when merges interrupt the grid.

These limitations matter most in data tables: lists of customers, dates, inventory, transactions, or survey responses. Keep each record on one row and use one value per cell in those areas. A merged title above the table may be acceptable, but merging cells within the data rows is usually a poor fit. If a workbook will be analyzed, imported, or refreshed, a regular rectangular structure is generally easier to work with.

Merges can also complicate row sizing. A long heading in a merged range may not display fully when you use AutoFit, and changes to column widths can alter how the text wraps. If the heading is clipped, try widening the relevant columns, enabling Wrap Text, adjusting row height, or using a non-merged layout instead of repeatedly changing the merge.

Use Center Across Selection instead

If you want a heading to appear centered across several columns but do not need a single merged cell, Center Across Selection is often the safer choice in desktop Excel. It changes the alignment of the text in the leftmost cell so it appears centered over the selected cells, while the cells themselves remain separate. That preserves a normal grid for sorting, selecting, and editing.

To set it in Excel for Microsoft 365 on Windows, enter the heading in the leftmost cell of the intended area and leave the neighboring cells empty. Select the range, open Format Cells from the Home tab’s Alignment group dialog launcher, and choose the Alignment tab. Under Horizontal, select Center Across Selection, then choose OK. The option changes alignment rather than joining cell contents, so it is useful for report headings but does not make the text a value in every selected cell. The Format Cells dialog and its available choices can vary slightly by platform.

Another approach is to place the heading in one cell and use a suitable column width, text wrapping, or indentation. For a report that will be printed, adjust page layout or use a text box when the heading should sit visually over a group of columns without changing the worksheet grid. Choose the method based on whether the sheet is primarily a display, a data source, or both.

A practical troubleshooting sequence

If the merge control still does not work, use this sequence rather than changing several settings at once:

  1. Press Enter or Esc to leave cell-edit mode, then select one contiguous rectangular range.
  2. Check whether the selected cells are part of a table. If so, decide whether converting the table to a range is appropriate.
  3. Check Review for sheet protection and ask the workbook owner for access if you do not have permission to change it.
  4. Look for existing merges that cross the intended range. Unmerge those areas, then select and merge the exact target cells.
  5. Verify that the upper-left cell contains the content you want to keep and that the other cells do not contain information you need.
  6. If the goal is only visual centering, use Center Across Selection or another layout option instead.

If the command remains unavailable in a simple, unprotected range outside a table, check whether the workbook is in an unusual editing state, whether Excel needs an update, and whether the issue occurs in a new blank workbook. Testing a blank workbook can help distinguish a workbook-specific problem from an application issue without risking the original data.

Frequently Asked Questions

Why is Merge & Center greyed out in Excel?
Common causes include selecting nonadjacent cells, working inside an Excel table, editing a cell, or lacking permission to format a protected sheet. Select one continuous range outside a table and check the Review tab for sheet protection.

Can I merge cells without losing data?
Not by using Excel’s merge command when multiple selected cells contain content: Excel keeps the upper-left cell’s content and discards the others. Copy or combine any needed values before merging, or use a layout method that leaves the cells separate.

Why can’t I merge cells in an Excel table?
Excel tables require a consistent grid for features such as filtering and sorting, so cells inside a table cannot be merged. You can convert the table to a range if you no longer need its table features, or place a heading outside the table.

Does merging cells affect sorting?
It can. Merged areas within a data list do not fit the uniform row structure that sorting expects, and may prevent a sort or make the layout difficult to manage. Avoid merges in the records themselves; use a separate heading area or Center Across Selection.

What is the difference between Merge Across and Merge & Center?
Merge & Center combines the full selected block into one area and centers its retained content. Merge Across instead makes separate merges across each row of a multirow selection. Both retain the upper-left content of each resulting merged area and can discard other cell contents.

Can I undo a merge?
Use Home > Merge & Center > Unmerge Cells, or the corresponding merge menu option. Unmerging restores the individual cells, but it does not bring back values discarded during the merge. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac if you need to reverse a recent merge and its data loss.

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.