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

💡
Quick Answer

To do Alt + D T on Mac in Excel, install Accelerator Keys, then press Option, then D, then T. It runs the Excel 2003 command Data > Table. The modern ribbon shortcut is Alt + A + W + T.

Download Accelerator Keys for Free Now

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

Alt + D + T is the legacy shortcut for Data > Table. It opens the Data Table dialog. A data table shows how a formula result changes when one or two inputs change. You give Excel the row input cell, the column input cell, or both.

Legacy vs. Modern Shortcut Comparison

Shortcut Era Menu Path
Alt + D + T Legacy (Excel 2003) Data > Table
Alt + A + W + T Modern (Ribbon) Data > What-If Analysis > Data Table

Both shortcuts work with Accelerator Keys.

How It Works on Mac

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

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

  1. Install the Fix: Download Accelerator Keys (14-day free trial, no credit card required).
  2. Select the table range: Set up the formula and the input values. Then select the full table range, with the formula and the inputs.
  3. Press Option: Press the Option key. It works like Alt on Windows.
  4. Press the letters one at a time: Press D, then T.
  5. Result: The Data Table dialog opens. Set the input cells and click OK.

Frequently asked questions

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

What is the modern equivalent of Alt + D T?

The modern ribbon shortcut is Alt + A + W + T (Data > What-If Analysis > Data Table). Both work on Mac with Accelerator Keys.


Related Links