Quick key to "merge cells"
 

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.

Quick key to "merge cells"
 

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.
--
tj


"Sorcerer Mickey" wrote:

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.

Quick key to "merge cells"
 

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

Choose ToolsCustomize
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.

Sorcerer Mickey wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Quick key to "merge cells"
 

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

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

Choose ToolsCustomize
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.

Sorcerer Mickey wrote:

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.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Quick key to "merge cells"
 

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


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=527313