0
Thanks

A few words of thanks would be greatly appreciated.

Creating Shortcut key to merge cells

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.

0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
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).