Alt + D P Mac Excel Shortcut: Legacy PivotTable (2026 Guide)

💡
Quick Answer

To do Alt + D P on Mac in Excel, install Accelerator Keys, then press Option, then D, then P. It runs the Excel 2003 command Data > PivotTable and PivotChart Report. The modern ribbon shortcut is Alt + N + V.

Download Accelerator Keys for Free Now

If you are looking for the Alt + D P 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 P Do?

Alt + D + P is the legacy shortcut for Data > PivotTable and PivotChart Report. It starts a new PivotTable from your data. On Windows, Alt + D P opens the old PivotTable and PivotChart Wizard. On your Mac, Accelerator Keys runs Data > Summarize with PivotTable, which asks for the data range and where to put the PivotTable.

Legacy vs. Modern Shortcut Comparison

Shortcut Era Menu Path
Alt + D + P Legacy (Excel 2003) Data > PivotTable and PivotChart Report
Alt + N + V Modern (Ribbon) Insert > PivotTable

Both shortcuts work with Accelerator Keys.

How It Works on Mac

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

Step-by-Step: How to do Alt + D P 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. The first row must have headers.
  3. Press Option: Press the Option key. It works like Alt on Windows.
  4. Press the letters one at a time: Press D, then P.
  5. Result: Excel asks for the range and the location. Click OK to create the PivotTable.

Frequently asked questions

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

What is the modern equivalent of Alt + D P?

The modern ribbon shortcut is Alt + N + V (Insert > PivotTable). Both work on Mac with Accelerator Keys.

Related Links