Creating Shortcut key to merge cells

December 2016


If there a shortcut to be pressed on the keyboard to merge cells in excel? I was trying to find a code or any macro which will allow me to do this! Thanks for your help!


To do this, you will have to make a macro with your own shortcut key with codes..

I will advise you using these codes:

sub macroMergeCells()
Selection.MergeCells = True
End sub


Thanks to Excelguru for this tip on the forum.

Related :

This document entitled « Creating Shortcut key to merge cells » from CCM ( is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.