Alt + D F A Mac Excel Shortcut: Legacy Advanced Filter (2026 Guide)

💡
Quick Answer

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

Download Accelerator Keys for Free Now

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

Alt + D + F + A is the legacy shortcut for Data > Filter > Advanced Filter. It opens the Advanced Filter dialog. You filter with a criteria range, which can hold complex conditions. You can also copy the result to another place, or keep only unique records.

Legacy vs. Modern Shortcut Comparison

Shortcut Era Menu Path
Alt + D + F + A Legacy (Excel 2003) Data > Filter > Advanced Filter
Alt + A + Q Modern (Ribbon) Data > Advanced

Both shortcuts work with Accelerator Keys.

How It Works on Mac

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

Step-by-Step: How to do Alt + D F A 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. Put your criteria range above or next to the data.
  3. Press Option: Press the Option key. It works like Alt on Windows.
  4. Press the letters one at a time: Press D, then F, then A.
  5. Result: The Advanced Filter dialog opens. Set the list range and the criteria range, then click OK.

Frequently asked questions

Does Alt + D F A 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 F, then A.

Is Alt + D F A the shortcut for Show All?

No. Alt + D F A opens Advanced Filter. Some lists online give it as Show All. To clear filters and show all rows, use Alt + D F S.

What is the modern equivalent of Alt + D F A?

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

Related Links