What is the Keyboard Shortcut to Merge Cells in MS Excel?

Is there any shortcut key to merge cells in MS Excel 2007?

Yes, there is a Shortcut key to make your office much easier to work. You can’t split an individual cell, but you can make it appear as if a cell has been split by merging the cells above it. Generally we will select the cells which needs to be merged and click “Merge & Center” option.

Keyboard Shortcut to Merge Cells in MS Excel

It’s a waste of time each time selecting the cells and clicking on “Merge & Center” option. Instead we can use a Shortcut key feature ;) Just do the following things in MS Excel,

  1. Just select the cells
  2. Press Alt + Enter key
  3. Now the cells will be merged :)

3 Most Wanted MS Office Tips

See the below example I merged the cells in MS Excel 2007,

Shortcut to Merge Cells in MS Excel

Though this is a simple post, I think this simple tip will make your work much easier in MS Excel:)

Subscribe to receive more Computer Tips & Tricks to your Inbox

Share this Post:
Digg Google Bookmarks reddit Mixx StumbleUpon Technorati Yahoo! Buzz DesignFloat Delicious BlinkList Furl

9 Responses to “What is the Keyboard Shortcut to Merge Cells in MS Excel?”

commenter

Things happen and we don’t know how to do simple things in fact. Thank you so much!

commenter

trick is not working pls input a solution for merge cell shotcut

commenter

Its working. Pls recheck again

commenter

In Excel 2010 (and maybe other versions), you can’t just simply do Alt + Enter. That shortcut repeats the last action you, e.g. you pasted text, Alt+Enter will paste that exact text again.

So…go up to the HOME toolbar and find the merge option you want. Do that as your first action. Afterwards, you can simply hit Alt+Enter for the remaining cells.

commenter

THANK YOU SOOO Much for the shortcut! You saved a lot of my time! :D

commenter

Shortcut for merge and venter is:
Alt + H + M + C

Then you may use Alt + Enter for repeating action or continue to use the above shortcut!

commenter

Thank you Teresa for helpful message

commenter

It was really helpful. Thanks a lot.

commenter

Thanks.

Leave a Reply:

Name (required):
Mail (will not be published) (required):
Website:
Comment (required):
XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>