Short cut to merge cells in Microsoft Excel

I have just recently started to work on Microsoft Excel. I am not very used to computer and this is my first experience of using Microsoft Office. I am finding a bit difficult to grasp MS-Excel. I have been assigned a work which required merging of Cells in Excel. I have heard there is a shortcut to achieve the merging of cells in Excel. What is the Shortcut to do that? Help me.

Even I was confused when I started to use Microsoft excel. My job profile required a lot of updating and adding entries using Microsoft excel. This was quite tedious process. Even I had to edit and do merging of cells in Microsoft Excel. You can create a macro that has shortcut key defined by you. This will help you to perform merging of cells easily.

Code:

---

sub macroMergeCells()
Selection.MergeCells = True
End sub

---

I know how to merge cells in Microsoft Office 2003. The Alt + M keys can be use simultaneously to merge the excel cells together. Go to menu bar and select Tools, now select customize. At the top of the screen right click on merge and center icon of the toolbar. Click on the Image and Text. Once done with it then close the window. Now the Alt+M key must work as a keyboard shortcut for you.

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.