Short cut to merge cells [Solved/Closed]

Posts
185
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
August 6, 2010
- - Latest reply:  Roopesh - Dec 31, 2012 at 12:23 AM
Hello,

If there a short cut on the key board to merge cells in excel?
See more 

8 replies

Best answer
101
Thank you
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

Say "Thank you" 101

A few words of thanks would be greatly appreciated. Add comment

CCM 6265 users have said thank you to us this month

GR8, you help me a lot, before It was taking much more time, but now it's good, thanks bro..
Thanks mate ... Thanks a Tone ... Really Works !! Great work ...
nice Job
badiya hai
80
Thank you
Shortcut for Merge & Center

Alt + h + m + c
10
Thank you
http://support.microsoft.com/kb/290938

this is a list of keyboard shortcuts for older version of Office.
May b this will help u
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
305
9
Thank you
Hello Rossdavid

Make a macro with your own shortcut key and with code

sub macroMergeCells()
Selection.MergeCells = True
End sub
I know little about excel and I have to merge columns labeled : Name - . - Last Name - @csan.com
into one column so I can create an email group for Outlook 2007.

Is there An easy way for a NOVICE like me to do this? There are 3k rows on this Excel sheet. I use Excel 2007

Thank you so much!!!

Kat
8
Thank you
excel 2007 - try press alt and you'll see letters what ever you want to shortcut
Select the cells to merge and press Alt + ent.
5
Thank you
When I do that only the upper left cell appears?
Posts
233
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
August 1, 2010
29
5
Thank you
Nice one EvilEyeleen I can confirm it works in Office 2007 as well.
Posts
185
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
January 29, 2010
68
3
Thank you
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 :)