Creating Shortcut key to merge cells

April 2018


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.
Published by jak58. Latest update on November 6, 2009 at 01:17 AM by jak58.
This document, titled "Creating Shortcut key to merge cells," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (
Excel - Comparing cell A1 to entire A column in Sheet 2
Finding the difference between dates with the DATEDIF function