Group Rows Shortcut in Excel on Mac (Alt + D G G)

💡
Quick Answer

The Excel 2003 group shortcut is Alt + D G G. It groups the selected rows or columns so that you can collapse them. On a Mac, install Accelerator Keys, select the rows or columns, then press Option, then D, then G, then G.

Download Accelerator Keys for Free Now

If you are looking for the group shortcut in Excel on Mac, Alt + D G G is the one many Windows users know from Excel 2003. Windows Excel still accepts it. With Accelerator Keys, it works on your Mac too.

What Does Alt + D G G Do?

Alt + D + G + G is the legacy shortcut for Data > Group and Outline > Group. It groups the selected rows or columns. Excel adds an outline bar with a minus button. Click the button to collapse the group, and click it again to expand it.

Legacy vs. Modern Shortcut Comparison

Shortcut Era Menu Path
Alt + D + G + G Legacy (Excel 2003) Data > Group and Outline > Group
Alt + A + G + G Modern (Ribbon) Data > Group > Group

Both shortcuts work with Accelerator Keys.

How It Works on Mac

On your Mac, Accelerator Keys runs Data > Group and Outline > Group in the Excel menu bar. It works on any ribbon tab and at any window width.

Step-by-Step: How to do Alt + D G G on Mac Excel

  1. Install the Fix: Download Accelerator Keys (14-day free trial, no credit card required).
  2. Select the rows or columns: Select full rows or full columns. If you select only cells, Excel asks if you want to group rows or columns.
  3. Press Option: Press the Option key. It works like Alt on Windows.
  4. Press the letters one at a time: Press D, then G, then G.
  5. Result: Excel groups the rows or columns and shows the outline bar.

Frequently asked questions

Does Alt + D G G work natively on Mac Excel?

No. Excel for Mac’s own KeyTips do not support the legacy Alt + E, Alt + I, Alt + O, and Alt + D menu keys. Accelerator Keys adds them. Press Option, then D, then G, then G.

How do I group columns instead of rows?

Select full columns, then press Option, then D, then G, then G. If you select only cells, Excel asks you to choose rows or columns.

What is the modern equivalent of Alt + D G G?

The modern ribbon shortcut is Alt + A + G + G (Data > Group > Group). Both work on Mac with Accelerator Keys.

Related Links