On Windows, the merge shortcut in Excel works through the ribbon: select the cells, then press Alt, H, M, C one after another. This is Merge and Center, which joins the cells into one and centres the text, the usual choice for report titles.
Excel has no single Ctrl key for merging, so the ribbon keys are the standard method. Swap the last letter to choose a different kind of merge, and keep in mind that merging keeps only the top left value.
Quick facts
Merge and Center
Alt, then H, then M, then CMerge Cells
Alt, then H, then M, then MMerge Across rows
Alt, then H, then M, then AUnmerge
Alt, then H, then M, then UData kept
Top left cell onlySafer option
Center Across Selection
Every merge shortcut in Excel
| Option | Keys | What it does |
|---|---|---|
| Merge and Center | Alt, then H, then M, then C | One cell, text centred |
| Merge Across | Alt, then H, then M, then A | Merges each selected row separately |
| Merge Cells | Alt, then H, then M, then M | One cell, alignment unchanged |
| Unmerge Cells | Alt, then H, then M, then U | Splits back into normal cells |
Press the keys one by one. Holding them together does nothing. After you press Alt, letters appear on the ribbon to guide you.
How to merge cells in Excel with the shortcut
- Type the title in the first cell, for example A1.
- Select A1 across to the last column of the table, such as A1 to F1, with Shift + Right.
- Press Alt, H, M, C.
- The title now sits centred above the whole table.
To repeat the same merge on another range, select it and press F4.
The data loss warning
If more than one cell in the selection contains data, Excel warns that only the upper left value will be kept. Click Cancel if you need the other values. To combine text from several cells into one, use a formula such as =A2&" "&B2 instead of merging.
Center Across Selection: merge without merging
- Select the title cell and the cells across.
- Press Ctrl + 1 to open Format Cells.
- On the Alignment tab, set Horizontal to Center Across Selection and press Enter.
The title looks merged, but every cell stays separate, so filters and the sort shortcut keep working.
When merging does not work
| Problem | Fix |
|---|---|
| Merge button greyed out | You are editing a cell; press Esc. Or the data is a table, which cannot merge |
| Cannot sort the data | Unmerge cells in the range first |
| Merged cell will not paste | Paste into a range of the same merged size |
| Keys type letters into a cell | Press Esc to leave edit mode before Alt |
Merge in Excel for Mac and more keys
On a Mac, Excel shows no key letters on the ribbon, so click Merge and Center on the Home tab. Alignment keys are in Excel alignment, text wrapping in wrap text, and the full set in the Excel shortcut keys list.
Frequently asked questions
What is the shortcut for merge and center in Excel?
Is there a Ctrl shortcut to merge cells?
No. Excel uses the ribbon sequence. You can add Merge to the Quick Access Toolbar to get Alt + a number.
How do I unmerge cells?
Why did my data disappear after merging?
Merging keeps only the top left value.
What is merge and centre?
The British spelling of Merge and Center; same keys.
Can I merge cells in Excel for Mac with keys?
Use the Home tab button; there are no ribbon key letters on Mac.