Is there a keyboard shortcut for merge cells?

[calindor]

I've looked through help and done a bit of a web search and can't find out if there is a keyboard shortcut for merging cells in excel?

A little help, anyone? Thanks!

 

[Andrew Poulsom]

Not as such, but you can use this sequence:

Ctrl+1 A Alt+M Enter

 

[byrne]

You could try settin up the merge function as a macro and then assign your own key shortcut.

 

[TommyGun]

Or if you need to do this multiple times at once, then do one merge, and then use F4 to repeat your last action.

 

[Juan Pablo González]

Sub MyMerge()
    On Error Resume Next
    Selection.Merge
End Sub

Sub TurnOnMyMerge()
    Application.MacroOptions "MyMerge", ShortcutKey:="M"
End Sub

Sub TurnOffMyMerge()
    Application.MacroOptions "MyMerge", ShortcutKey:=""
End Sub

Execute the "TurnOnMyMerge" macro, and that will make Control Shift M the shortcut for merge.

 

[calindor]

I was doing that key sequence, Andrew.. it just seemed like too much to go through. You and I think alike.

Thanks for the macro idea, Byrne, and thanks for the macro Juan!

I don't know why I didn't think of F4 before, Tommygun!

Thanks for all your help, people!

Maybe you can help me with my next problem... see next thread.

 

[stils]

f4 works a treat. Thank you forum for saving me time!

 

[claar]

Great tips -- especially F4 -- thanks!

But there is a built-in excel keyboard shortcut for merge cells: Alt-Enter

 

[claar]

Great tips -- especially F4 -- thanks!

But there is a built-in excel keyboard shortcut for merge cells: Alt-Enter

Woops -- Alt-Enter is "repeat last action", just like F4. I thought it was merge since my last action was merging cells

 

[teylyn]

Merged cells should be avoided, if possible, because they lead to all kinds of problems for data processing.

Use "Center Across Selection" instead