How to use Merge & Center in Excel
By the Analistable team · Updated · 2 min read
Select the cells, then choose Home → Merge & Center (shortcut Alt, H, M, C). The cells become one cell with the text centred, and only the upper-left value is kept. Click it again to unmerge. For headings over a table, Center Across Selection (Ctrl+1 → Alignment → Horizontal) looks the same but keeps every cell separate, so sorting, filtering and copying keep working.
Part of our guide: How to merge cells, columns and text in Excel
Using Merge & Center
- Type the heading in the left-most cell (for example A1).
- Select the cells to span, such as A1:F1.
- Click Home → Merge & Center, or press Alt, H, M, C.
The arrow next to the button offers Merge Across (merge each row separately), Merge Cells (without centring) and Unmerge Cells.
Why is Merge & Center greyed out?
| Cause | Fix |
|---|---|
| You're editing a cell | Press Enter or Esc first |
| The selection is in an Excel table | Tables don't allow merges; use Center Across Selection or convert to a range |
| The sheet is protected | Review → Unprotect Sheet |
| The workbook is shared (legacy sharing) | Turn off sharing, or avoid merges |
What it costs
Merged cells keep only one value, can't be sorted with neighbouring rows, make filter results confusing, and block pasting ranges of a different shape. Many teams ban them in data sheets for these reasons. Read merging cells in Excel for how to find and undo them.
The alternative: Center Across Selection
- Type the heading in A1 and select A1:F1.
- Press Ctrl+1 to open Format Cells.
- On Alignment, set Horizontal to Center Across Selection and click OK.
The heading appears centred over A–F, but B1:F1 are still separate, empty cells. Details and limits: Center Across Selection.
Merging the *contents* of cells (joining text) is different — see combining text in Excel.
Undo merged cells safely
- Select the range and choose Home → Merge & Center → Unmerge Cells.
- The value stays in the top-left cell; the others become empty.
- To refill them, press F5 → Special → Blanks, type
=and the up arrow, then Ctrl+Enter. - Copy the range and Paste Special → Values to remove the formulas.
Merge & Center in Excel for the web and Mac
Both have the same button on the Home tab. On a Mac the Alt shortcut sequence isn't available, so use the ribbon or add the command to the Quick Access Toolbar.
When merging is fine
Merged cells are harmless in printed forms, invoices and dashboards that nobody sorts or filters. Avoid them inside data tables that will be sorted, filtered, copied or used by formulas.
Frequently asked questions
- What is the shortcut for Merge & Center?
- Press Alt, H, M, C in sequence on Windows. Alt, H, M, U unmerges.
- Does Merge & Center delete data?
- Yes. If more than one cell has a value, only the upper-left value is kept.
- What's better than Merge & Center?
- Center Across Selection gives the same look for headings without merging cells.