Creating Shortcut key to merge cells

July 2017




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


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 (ccm.net).