How do I assign a new keyboard shortcut in Excel 2010

Question

I need a keyboard shortcut for Merge & Center. I'd like it to be ControlShiftM. I am unfamiliar with Macros as was suggested in another answer and when I go to Options, I can't find shortcuts...I tried to follow the Help info, but as was already answered the Excel Customize Ribbon doesn't have the same options that Word 2010 does.

So, how do I go about it step by step? I know this is for superuser...and I'm not one...but I hope to be one some day. Please help me on the way.

Solution

There are some built in shortcuts. You can press ALT then H then M then C.

Or to use less keystokes, you can right click on the "Merge & Center" button and click "Add to Quick Access Toolbar" and then use ALT followed by whatever position it is in the toolbar (by default 4).

Comments

[arantebw]

Looks like this has been asked before: superuser.com/questions/212583/…

[Tog]

Would you care to expand on your answer

[Momen Zaqout]

What it actually does is 'repeat previous action', pretty much like F4 or Ctrl-Y'. I was misled by clicking the 'merge and center' button, and then trying Alt-Enter.