Creating Shortcut key to merge cells

April 2018




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.
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 (https://ccm.net/).
Excel - Comparing cell A1 to entire A column in Sheet 2
Finding the difference between dates with the DATEDIF function