Quick answer: If Merge & Center is dimmed or does nothing, press Esc or Enter first, because Excel blocks formatting commands while you’re still typing in a cell. If it’s still unavailable, check whether the cells sit inside an Excel table (convert it with Table Design > Convert to Range) or on a protected sheet (Review > Unprotect Sheet). When all you want is a title centered over several columns, Center Across Selection gives the same look without merging anything.
In this guide
- Before you start: what merging does to your data
- Fix 1: Finish editing the cell
- Fix 2: Convert an Excel table to a normal range
- Fix 3: Unprotect the sheet
- Fix 4: Check for a shared or read-only workbook
- Use Center Across Selection instead of merging
- Merged cells that break sorting, filtering or pasting
- How to unmerge cells
- Excel for the web
- Match the symptom to the fix
- Related guides
Applies to: Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019 and Excel 2016 on Windows. The steps refer to the Merge & Center button in the Alignment group on the Home tab. Excel for the web gets a short section of its own near the end, because its options differ.
Before you start: what merging does to your data
Microsoft’s article on merging cells gives one warning that’s worth reading before you try any fix: when you merge, only the contents of the upper-left cell are kept (upper-right in right-to-left languages), and the contents of the other cells are deleted. So if the button suddenly works again, check that the cells you selected don’t hold data you need. Copy that data somewhere else first, or use the alternative described further down.
The same article explains that you can’t split a single cell in Excel; to make one look split, Microsoft suggests merging the cells above it instead. Keep that in mind when you inherit a sheet and can’t work out why a layout behaves the way it does.
Fix 1: Finish editing the cell
While a cell is in edit mode (you see a blinking cursor inside it, or in the formula bar), Excel can turn off formatting commands on the ribbon, and Merge & Center is one of the buttons affected. Nothing is wrong with the workbook in that case:
- Press Enter to keep what you typed, or Esc to cancel it.
- Select the cells you want to merge again, by dragging across them.
- Select Merge & Center on the Home tab, or open its arrow for Merge Across and Merge Cells.
The status bar at the bottom left should read Edit or Enter while you’re editing and Ready once you’re out, which is a quick way to confirm which state you’re in.
Fix 2: Convert an Excel table to a normal range
If your data was formatted with Format as Table or Insert > Table, the merge buttons are expected to stay unavailable for any selection inside it. Microsoft’s article on converting tables doesn’t mention merging, so treat this as the first thing to check rather than a documented rule. A sign that you’re in a table is the Table Design tab appearing on the ribbon when you click a cell in the data.
To turn the table back into a plain range, which is the route Microsoft gives:
- Click any cell in the table.
- Open the Table Design tab.
- In the Tools group, select Convert to Range, then confirm.
You can also right-click the table and choose Table > Convert to Range. Microsoft notes that the table style formatting stays, but table features go away: the sort and filter arrows disappear from the header row, and formulas that used table names change to regular cell references. If you rely on those features, don’t convert the whole table just for a heading. Put the heading in a row above the table and merge or center it there instead.
Fix 3: Unprotect the sheet
Worksheet protection stops people from changing locked cells, and a protected sheet can leave formatting buttons such as Merge & Center unavailable. Microsoft’s protection article gives a simple check: when a sheet is protected, the Review tab shows Unprotect Sheet where Protect Sheet normally is.
- Select Review > Unprotect Sheet, or go to File > Info > Protect > Unprotect Sheet.
- If the sheet has a password, type it and select OK.
- Merge the cells, then protect the sheet again from Review > Protect Sheet if it needs to stay protected.
Microsoft says it can’t recover a forgotten sheet password, so if the file came from someone else, ask them to unprotect it. The Protect Sheet dialog has a Format cells option that lets users change settings in the Format Cells dialog, but that article doesn’t say whether it covers merging, so don’t count on it. Microsoft also points out that sheet protection isn’t meant as a security feature; it only guards against accidental changes.
Fix 4: Check for a shared or read-only workbook
None of the Microsoft pages cited here cover this case, so check the points below on your own copy of Excel:
- Legacy shared workbooks. The older Shared Workbook feature restricts some editing commands, and merging cells appears to be one of them. If the title bar shows Shared next to the file name, the owner can turn sharing off (the command is no longer on the default ribbon in newer versions, so it may have to be added back), or you can save a copy and work on that.
- Protected View or read-only. A file opened from email or the internet can open in Protected View, and a file opened as read-only won’t accept edits. If there’s a yellow bar with Enable Editing, select it. If Excel says the file is locked or read-only, see Excel file is locked for editing by another user.
- Co-authoring in OneDrive or SharePoint. Modern co-authoring is a different feature from the old Shared Workbook, and merging should normally still work. If the button is unavailable only in a co-authored file, close it, open it again in the desktop app and retry.
Use Center Across Selection instead of merging
The sorting and selection problems described below don’t arise if you don’t merge at all. Center Across Selection centers the text in the left cell over the cells you select, while every cell stays separate, so sorting, copying and selecting columns keep working. This option isn’t covered in the Microsoft articles cited here, so check the label on your screen:
- Type the heading in the leftmost cell, and leave the cells to its right empty.
- Select that cell and the cells it should span in the same row.
- Press Ctrl+1 to open Format Cells, and go to the Alignment tab.
- Under Horizontal, choose Center Across Selection, then select OK.
It only works across a row, not down a column, and the text spreads only over empty cells. If a cell to the right has content, the heading stops there. It’s a good fit for report titles and for headings over a group of columns.
Merged cells that break sorting, filtering or pasting
Sometimes the merge works, and the trouble starts later. Excel can refuse to sort a range that contains merged cells of different sizes, with a message that the cells need to be the same size. Filtering may also return odd results, because a merged block counts as one cell sitting in its top row. Pasting into a selection that overlaps merged cells can fail in a similar way. The exact wording of these messages may vary between versions.
The fix in each case is to unmerge the cells in the data area (next section) and, for headings, use Center Across Selection. If a filter still misbehaves after that, see Excel filter not working. Merged header rows can also get in the way when you lock rows at the top of a sheet; Freeze Panes not working in Excel covers that.
How to unmerge cells
Microsoft’s steps to split a merged cell back into separate cells:
- Select the merged cell.
- Select the arrow next to Merge & Center on the Home tab.
- Select Unmerge Cells.
Unmerging doesn’t bring back text that was deleted when the cells were merged; the content ends up in the upper-left cell. If you’ve lost track of which cells are merged, Microsoft suggests the Find command. In the desktop app, Home > Find & Select > Find, then Options > Format and the Merge cells box on the Alignment tab should find them all; the dialog layout can differ slightly by version.
Excel for the web
Microsoft lists Excel for the web among the versions its merge article applies to, but the article has no separate web steps. In the browser, the merge command should be on the Home tab, though its position and label can differ from the desktop app. If a file is protected, read-only or uses a feature the browser doesn’t support, select Editing or Open in Desktop App if it’s offered, and follow the fixes above there.
Match the symptom to the fix
| What you see | Possible cause | What to try |
|---|---|---|
| The whole ribbon looks dimmed, not just Merge & Center | The cell is still in edit mode | Press Enter or Esc (Fix 1) |
| Table Design appears when you click the data | The cells are inside an Excel table | Convert to Range, or put the heading above the table (Fix 2) |
| Review tab shows Unprotect Sheet | The sheet is protected | Unprotect the sheet (Fix 3) |
| Title bar shows Shared or a yellow Enable Editing bar | Shared workbook, Protected View or read-only | Enable editing or stop sharing (Fix 4) |
| Excel won’t sort after merging | Merged cells of different sizes in the range | Unmerge, then use Center Across Selection |
Related guides
- Freeze Panes not working in Excel: how to fix it
- Excel filter not working: how to fix it on Windows 11
- Excel file is locked for editing by another user: how to fix it
- How to print an Excel sheet on one page
- Excel tips and tricks: 10 ways to work faster in Excel
Leave a Reply