Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Is there a keyboard shortcut for merge cells?

This is a discussion on Is there a keyboard shortcut for merge cells? within the Excel Questions forums, part of the Question Forums category; I've looked through help and done a bit of a web search and can't find out if there is a ...

  1. #1
    New Member
    Join Date
    Feb 2003
    Location
    London, ON
    Posts
    13

    Default Is there a keyboard shortcut for merge cells?

    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!

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    69,583

    Default

    Not as such, but you can use this sequence:

    Ctrl+1 A Alt+M Enter

  3. #3
    New Member
    Join Date
    Feb 2003
    Posts
    15

    Default

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

  4. #4
    MrExcel MVP TommyGun's Avatar
    Join Date
    Dec 2002
    Location
    Clear Lake, TX
    Posts
    4,202

    Default

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

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,950

    Default

    Code:
    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.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  6. #6
    New Member
    Join Date
    Feb 2003
    Location
    London, ON
    Posts
    13

    Default

    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.

  7. #7
    New Member
    Join Date
    Apr 2009
    Posts
    1

    Default Re: Is there a keyboard shortcut for merge cells?

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

  8. #8
    New Member
    Join Date
    Nov 2009
    Posts
    2

    Default Re: Is there a keyboard shortcut for merge cells?

    Great tips -- especially F4 -- thanks!

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

  9. #9
    New Member
    Join Date
    Nov 2009
    Posts
    2

    Default Re: Is there a keyboard shortcut for merge cells?

    Quote Originally Posted by claar View Post
    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

  10. #10
    Board Regular teylyn's Avatar
    Join Date
    Sep 2008
    Location
    New Zealand
    Posts
    296

    Default Re: Is there a keyboard shortcut for merge cells?

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

    Use "Center Across Selection" instead

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com