Kioskea
Recherche
Ask a question Report

Short cut to merge cells [Solved/Closed]

rossdavid 188Posts Tuesday November 18, 2008Registration date August 6, 2010Last seen - Latest answer on Dec 31, 2012 12:23AM
Hello,
If there a short cut on the key board to merge cells in excel?
Read more 
Answer
+98
moins plus
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

skybrainkhan- Jun 30, 2010 01:08AM
GR8, you help me a lot, before It was taking much more time, but now it's good, thanks bro..
kaka- Sep 6, 2010 12:28AM
Thanks mate ... Thanks a Tone ... Really Works !! Great work ...
anjali- Nov 16, 2012 01:02AM
thanks
SRk- Dec 15, 2012 02:16AM
nice Job
badiya hai
Roopesh- Dec 31, 2012 12:23AM
Superb ;)
Answer
+73
moins plus
Shortcut for Merge & Center

Alt + h + m + c

Answer
+10
moins plus
http://support.microsoft.com/kb/290938

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

Answer
+9
moins plus
Hello Rossdavid

Make a macro with your own shortcut key and with code

sub macroMergeCells()
Selection.MergeCells = True
End sub

Kat Zap- Nov 13, 2009 07:07PM
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
Answer
+8
moins plus
excel 2007 - try press alt and you'll see letters what ever you want to shortcut

Donna- Nov 8, 2012 03:02PM
Select the cells to merge and press Alt + ent.
Answer
+4
moins plus
When I do that only the upper left cell appears?

Answer
+3
moins plus
Nice one EvilEyeleen i can confirm it works in Office 2007 as well.

Answer
+2
moins plus
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 :)

This document entitled « Short cut to merge cells » from Kioskea (en.kioskea.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.

Not a member yet?

sign-up, it takes less than a minute and it's free!

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.