Creating Shortcut key to merge cells

December 2016




Issue



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!

Solution


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

Note


Thanks to Excelguru for this tip on the forum.

Related :

This document entitled « Creating Shortcut key to merge cells » from CCM (ccm.net) 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.