Short cut to merge cells [Solved/Closed]

If you're running Office 2003 (I don't know if this works for 2007), you can set it up so that Alt+m will merge your selected cells:

1. Choose 'Tools'
2. Choose 'Customize'
3. Right click on your merge and centre icon on the toolbar at the top of your screen
4. Click 'Image and Text'
5. Close the Customize window

The shortcut Alt+m should now work.

It seems silly that this works, but it's a godsend for me.

-Cheers

Shortcut for Merge & Center

Alt + h + m + c

Hello Rossdavid

Make a macro with your own shortcut key and with code

sub macroMergeCells()
Selection.MergeCells = True
End sub

http://support.microsoft.com/kb/290938

this is a list of keyboard shortcuts for older version of Office.
May b this will help u

excel 2007 - try press alt and you'll see letters what ever you want to shortcut

When I do that only the upper left cell appears?

Nice one EvilEyeleen i can confirm it works in Office 2007 as well.

There is a short cut for this in the tab menu, it's call merge and center, select the cells you want to merge and just click on it :)