software

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

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:
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.
--
tjquot;Sorcerer Mickeyquot; wrote:

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

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

Choose Toolsgt;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.

Sorcerer Mickey wrote:
gt; How can I create a keyboard shortcut (preferably a left-handed one) that will
gt; perform the same function as the quot;merge cellsquot; button on my Excel toolbar.--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlOops! I swear the subject said quot;unmergequot; the first time I read it!

Debra Dalgleish wrote:
gt; I don't know of a built-in keyboard shortcut, but you can add the
gt; Unmerge button to your toolbar:
gt;
gt; Choose Toolsgt;Customize
gt; Under Categories, choose Format
gt; In the list of commands, about half way down the list, find the Unmerge
gt; Cells button, and drag it to one of your toolbars.
gt; Click the Close button.
gt;
gt; Sorcerer Mickey wrote:
gt;
gt;gt; How can I create a keyboard shortcut (preferably a left-handed one)
gt;gt; that will perform the same function as the quot;merge cellsquot; button on my
gt;gt; Excel toolbar.
--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html
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: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=527313