In Excel: press Alt+Shift+→ / Alt+Shift+← on Windows (⌘+Shift+K / ⌘+Shift+J on Mac) to group or ungroup the selected rows instantly — no mouse or menu required.
Keyboard shortcut: Group & Ungroup
| Platform | Shortcut |
|---|---|
| Windows | Alt+Shift+→ / Alt+Shift+← |
| Mac | ⌘+Shift+K / ⌘+Shift+J |
Select whole rows or columns first, or Excel asks which direction to group.
Click the target cell, row header, or column header so Excel knows what to act on.
Hold the modifier key(s) in Alt+Shift+→ / Alt+Shift+← (Windows) or ⌘+Shift+K / ⌘+Shift+J (Mac) simultaneously, then tap the final key.
Excel executes the Group & Ungroup operation instantly.
Undo with Ctrl+Z (⌘+Z on Mac) if the result is not what you expected.
What this does
Pressing Alt+Shift+→ / Alt+Shift+← on Windows — or ⌘+Shift+K / ⌘+Shift+J on a Mac — triggers the Group & Ungroup action instantly. The shortcut bypasses the right-click context menu and the ribbon, so you can group or ungroup the selected rows mid-keystroke without breaking your editing rhythm. Excel's shortcut model is consistent: once you learn Alt+Shift+→ / Alt+Shift+← for Group & Ungroup you can apply the same muscle-memory pattern across dozens of related operations, making the whole workflow noticeably faster. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “excel group shortcut”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the tool above before you touch the real workbook. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. The point is a workflow that saves repeating the same clicks every week, but the practical win is that someone else can open the file and understand what happened without asking you.
A worked example
Practical use: you are cleaning a dataset and need to group or ungroup the selected rows multiple times. Select your target, hit Alt+Shift+→ / Alt+Shift+← on Windows (⌘+Shift+K / ⌘+Shift+J on Mac) for the first Group & Ungroup action, then press F4 to repeat the last action at each subsequent selection — this chains the Alt+Shift+→ / Alt+Shift+← shortcut into a rapid-fire workflow that beats any menu approach. Use the Group & Ungroup shortcut whenever you would otherwise right-click and choose an option from the context menu or navigate the ribbon. In high-volume data work the Alt+Shift+→ / Alt+Shift+← keystroke saves 2–4 seconds per action; across a hundred repetitions that is several minutes back in your session. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.
In Google Sheets
Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. If you take one thing from this page on “excel group shortcut”, make it the habit rather than the keystrokes: set the problem up with labelled inputs, reference those cells, and let Excel do the recomputing. Bookmark the page for the syntax, but do the example once in a blank sheet and check it against the tool above — five minutes of hands-on practice fixes the method in memory far better than re-reading, and it surfaces the small snags while they are still harmless. After that the technique is genuinely yours: faster than searching for it again, and reliable enough to drop into work that other people depend on.
Common mistakes
- Using Ctrl instead of the correct modifier or vice versa — always double-check whether Alt+Shift+→ / Alt+Shift+← starts with Ctrl, Alt, or Shift.
- Activating a cell for editing (cursor visible inside the cell) before pressing the shortcut — many shortcuts only fire when a cell is selected, not in edit mode. Press Escape to exit edit mode first.
- Expecting the shortcut to work the same in Google Sheets: most Group & Ungroup shortcuts are Excel-specific; Sheets uses different key combos for the same operations.
Frequently asked questions
Is there a Mac shortcut for Group & Ungroup?
Yes — on Mac use ⌘+Shift+K / ⌘+Shift+J. The function is identical to pressing Alt+Shift+→ / Alt+Shift+← on Windows; only the modifier keys differ because Mac replaces Ctrl with ⌘ and sometimes Alt with Option (⌥).
What if the Group & Ungroup shortcut (Alt+Shift+→ / Alt+Shift+←) doesn't work?
Check that you are not in cell-edit mode (press Escape first), that no dialog is open, and that no add-in has reassigned the shortcut. On a laptop, some function keys require pressing Fn first.
Can I use the Group & Ungroup shortcut multiple times in a row?
Yes — press Alt+Shift+→ / Alt+Shift+← repeatedly for each Group & Ungroup action, or pre-select multiple rows/columns and press the shortcut once to apply it to all of them simultaneously. You can also press F4 after the first use to repeat the last action.
Other ways people ask this
On the way here you may have searched this as “excel group shortcut key”, “keyboard shortcut group excel” and “excel group keyboard shortcut” — it is all the same task, and this page is the single, complete answer to it.
Is there a keyboard shortcut for this?
Yes — “excel group shortcut” is one key combination away rather than a trip through the menus. Use the Windows/Mac toggle above to see the exact keys for your machine, and remember Ctrl on Windows maps to ⌘ on Mac.
Why do people search for this in so many different ways?
Because the same task has many names. “excel group shortcut key”, “keyboard shortcut group excel”, “excel group keyboard shortcut” all point at the one operation explained on this page, which is why they all lead here.