A neat, centred title across the top of a report is the first thing people notice. Excel has no single-chord shortcut for merging, but the KeyTip sequence gets you there in under a second, and once your fingers know it you'll never reach for the ribbon again.
Step by step
- Select the cells you want to merge, for example A1 to F1.
- Press Alt, then H to open the Home tab KeyTips.
- Press M to open the Merge menu, then C to Merge & Center.
- Repeat the same sequence on a merged cell to unmerge it.
Tips & troubleshooting
- Merging keeps only the value in the top-left cell, so move any other data out first.
- Press the keys one after another, not all together. Letters appear on the ribbon to guide you.
- Merged cells can get in the way of sorting and filtering, so keep them to titles and headings rather than your data.
The four merge commands
After Alt, H, M, the last key decides what happens.
- C, Merge & Centre: joins the cells into one and centres the contents.
- A, Merge Across: merges each row of the selection separately, useful for several label rows at once.
- M, Merge Cells: joins the cells but leaves the alignment alone.
- U, Unmerge Cells: splits them back into individual cells.
A safer alternative: Centre Across Selection
If all you want is a title centred over several columns, you don't need to merge at all. Select the cells, press Ctrl+1, open the Alignment tab and set Horizontal to Centre Across Selection. It looks identical, but every cell stays separate, so sorting, filtering, copying and selecting columns all keep working.
Problems merged cells cause
- Sorting fails with a message that all merged cells need to be the same size.
- Ctrl+Spacebar selects every column the merged cell touches, not just the one you are in.
- Rows containing merged cells don't auto-fit their height when text wraps.
- You can't merge cells inside an Excel table at all.
- Only the top-left value survives the merge. Excel warns you, but the other values are gone once you accept.
Combine the contents instead
If the aim is to join the text from several cells, merging is the wrong tool. Use a formula: =A2&" "&B2 joins two cells with a space, and =TEXTJOIN(", ",TRUE,A2:D2) joins a whole range with commas, skipping blanks.