Filter Shortcut in Excel on Mac (Alt + D F F)

💡
Quick Answer

The Excel 2003 filter shortcut is Alt + D F F (Data > Filter > AutoFilter). It turns the filter arrows on or off. On a Mac, install Accelerator Keys, click a cell in your data, then press Option, then D, then F, then F.

Download Accelerator Keys for Free Now

If you are looking for the filter shortcut in Excel on Mac, Alt + D F F 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 F F Do?

Alt + D + F + F is the legacy shortcut for Data > Filter > AutoFilter. It turns AutoFilter on or off. When it is on, each header cell gets a filter arrow. You use the arrows to show only the rows that you need.

Legacy vs. Modern Shortcut Comparison

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

Both shortcuts work with Accelerator Keys.

How It Works on Mac

On your Mac, Accelerator Keys runs Data > AutoFilter 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 F 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 F, then F.
  5. Result: Filter arrows show on the header row. Press the same keys again to remove them.

Frequently asked questions

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

Does Alt + D F F still work in Windows Excel?

Yes. Windows Excel 2007 and newer still accept the Excel 2003 menu keys, so Alt + D F F turns filters on or off. With Accelerator Keys, the same keys work on Mac.

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

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

Related Links