15

Is there a keyboard shortcut to merge cells in Google Sheets? I've looked and can't find it. F4 doesn't repeat merging cells either. I'm on OSX, Apple keyboard.

Anyone been able to do this with a shortcut? I have to merge an ungodly amount of cells and would prefer to not have to use the drop down menus to do it.

10

There doesn't seem to be a native shortcut, but you can use Alt+O, M, and then Enter to select "Merge All" quickly from the dropdown menu.

  • What's the equivalent of this on a mac? – spacetyper Jun 20 '17 at 16:04
  • 1
    See @Yu De Lim's answer below: use "control option" (menu keyboard shortcut letters) in this case: control-option-"o"-"m" (enter) – Williams Jan 1 '18 at 21:00
6

Use @Pikachu's solution (Alt+O,M,Enter) for the first one then use Ctrl+Y (Edit - Redo) for the rest. This assumes you're doing them one after the other, as I am.

4

Use @Pikachu's solution (Alt+O,M,Enter). On a mac the equivalent is control+option+O,M,Enter.

  • I've been looking for the "control option" command to open menus in drive for soooo long! Thank you. – Williams Jan 1 '18 at 20:58
  • +1 for mac equivalent. Thank you. – Carl G Sep 23 at 20:59
0

On Linux the following works: ALT+SHIFT+O,M,ENTER

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.