Quick key to "merge cells"

[Guest]

How can I create a keyboard shortcut (preferably a left-handed one) that will
perform the same function as the "merge cells" button on my Excel toolbar.

 

[Guest]

You could add Merge Cells to the Format menu and then type Alt, o, m.
Add Merge by going to Tools and click Customize. On the Commands tab, click
Edit. Find the Merge Cells command and drag it into the Format menu.

--OR--

You could create a macro and assign a keyboard shortcut.
If you are new to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Sub MergeThem()
If TypeOf Selection Is Excel.Range Then
If Selection.Areas.Count = 1 Then
Selection.Merge
End If
End If
End Sub

One way to assign the keyboard shortcut: In Excel, go to Tools and point to
Macros and click Macros. Select the macro you want to change and click
Options. Assign the keyboard shortcut and click OK.

 

[Debra Dalgleish]

I don't know of a built-in keyboard shortcut, but you can add the
Unmerge button to your toolbar:

Choose Tools>Customize
Under Categories, choose Format
In the list of commands, about half way down the list, find the Unmerge
Cells button, and drag it to one of your toolbars.
Click the Close button.

 

[Debra Dalgleish]

Oops! I swear the subject said "unmerge" the first time I read it!

 

[John James]

If you follow Debra's instructions you will find both a merge icon and a
merge and centre icon.