To merge multiple cells in a single cell you can use the shortcut keys Alt ➜ H ➜ M ➜ A. When you press this shortcut key merges all the cells but only takes the upper left value (the value you have in the first cell). It shows you a message that says, “merging cells only keeps the upper left value and discard other values”.
And when you click OK it merges all the cells
Alt ➜ H ➜ M ➜ A
If you want to unmerge cells you need to use the same shortcut keys for that. And following are some other important shortcut keys related to merging cells.
- Alt ➜ H ➜ M ➜ A: To merge selected cells into rows.
- Alt ➜ H ➜ M ➜ C: To merge cells and center align the value.
More Shortcuts
- Absolute Reference (Excel Shortcut)
- Add Column (Excel Shortcut)
- Copy and Paste (Excel Shortcut)
- Cut and Paste (Excel Shortcut)
- Delete Cell (Excel Shortcut)
- Delete Row(s) (Excel Shortcut)
- Edit Cell (Excel Shortcut)
- Insert Cell (Excel Shortcut)
- Insert – Add Row(s) (Excel Shortcut)
- Lock Cells (Excel Shortcut)
- Paste Values (Excel Shortcut)
- Select Row (Excel Shortcut)
- Transpose (Excel Shortcut)
- Unhide Columns (Excel Shortcut)
- Open Go To Option (Excel Shortcut)
⇠ Back to Excel Shortcut Keys (Cheat Sheet PDF)