Firstly, I would like to inform you that excel does not consists of any shortcut to merge cells. The only was is by making use of user created macro. Here is a macro to be used to merge the selected cells:
Code:
Sub MCells()
Selection.Merge
End Sub
Now assign a shortcut key from your keyboard. And this will enable you to use the shortcut key to merge cells. A macro that will help you to merge as well as center tool is:
Code:
Sub MCells1()
With Selection
.HorizontalAlignment = xlCenter
.Merge
End With
End Sub
Thus, using macro we can create user defined shortcut keys from keyboard in Microsoft excel.
Bookmarks