Merge-Unmerge Cells (Excel Shortcut)

puneet-gogia-excel-champs

- Written by Puneet

Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)

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”.

cell-merge

And when you click OK it merges all the cells

merged-cells

AltHMA

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.

  • AltHMA: To merge selected cells into rows.
  • AltHMC: To merge cells and center align the value.
Last Updated: January 13, 2024