Alt + D Mac Excel Shortcut: Legacy Data Menu (2026 Guide)

💡
Quick Answer

To do Alt + D on Mac in Excel, install Accelerator Keys, then press Option, then D. It opens the Excel 2003 Data menu. Then press the next letter, such as S for Sort.

Download Accelerator Keys for Free Now

If you are looking for the Alt + D shortcut on Mac Excel, you may know it from Excel 2003, where Alt + D opened the Data menu. Windows Excel still accepts these menu keys. With Accelerator Keys, they work on your Mac too.

What Does Alt + D Do?

Alt + D is the legacy shortcut for the Data menu. From there you sort, filter, add subtotals, set data validation, split text to columns, group rows, make PivotTables, and refresh data.

How It Works on Mac

Excel for Mac keeps the Data menu in the macOS menu bar. Accelerator Keys opens Data and shows the Windows letter on each item. Then you press the next letter, the same as on Windows. It works on any ribbon tab and at any window width.

Supported Alt + D Sequences

Shortcut Command Modern Equivalent
Alt + D + S Sort Alt + A + S + S
Alt + D + F Filter Menu —
Alt + D + B Subtotals Alt + A + B
Alt + D + L Data Validation Alt + A + V + V
Alt + D + T Data Table Alt + A + W + T
Alt + D + E Text to Columns Alt + A + E
Alt + D + N Consolidate —
Alt + D + G Group and Outline Menu —
Alt + D + P PivotTable Alt + N + V
Alt + D + R Refresh Data Alt + A + R + R

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

  1. Install the Fix: Download Accelerator Keys (14-day free trial, no credit card required).
  2. Select your data: Click a cell in your data.
  3. Press Option: Press the Option key. It works like Alt on Windows.
  4. Press the letter: Press D.
  5. Result: The Data menu opens. Each item shows its Windows letter.

Then press the next letter from the table above. Press Esc to close the menu.

Frequently asked questions

Does Alt + D 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.

What keys come after Alt + D?

Press S (Sort), F (Filter Menu), B (Subtotals), L (Data Validation), T (Data Table), E (Text to Columns), N (Consolidate), G (Group and Outline Menu), P (PivotTable), R (Refresh Data).

Related Links