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.
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.
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.
Use @Pikachu's solution (Alt+O,M,Enter). On a mac the equivalent is control+option+O,M,Enter.
On Linux the following works: ALT+SHIFT+O,M,ENTER
Honestly, easiest way: 1. copy a merged cell. 2. paste it on top of a the cell/row you want to merge.
fastest method.
I created a macro, you just need to set it to run when shift, ctrl, alt & "number" is pressed.
Macro script:
/** @OnlyCurrentDoc */
function Unavngivetmakro() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getActiveRange().mergeAcross();
};
For MacOS this works like a charm:
ALT + SHIFT + O + M + A
I just wanted to add that merging the first set of cells manually, then selecting ALL the cells you want merged the same way, then using Ctrl+Y works as well and saves a ton of time.
