To do Alt + D F on Mac in Excel, install Accelerator Keys, then press Option, then D, then F. It opens the Excel 2003 Data > Filter menu. Then press the next letter, such as F for AutoFilter.
If you are looking for the Alt + D F 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.
Alt + D + F is the legacy shortcut for the Data > Filter menu. In Excel 2003, it opens the Filter submenu: AutoFilter, Show All, and Advanced Filter.
Excel for Mac has no Filter submenu. AutoFilter, Clear Filters, and Advanced Filter are items in the Data menu. When you press F, Accelerator Keys keeps the Data menu open and moves the letters to those three items. So the next key works the same as on Windows.
| Shortcut | Command | Modern Equivalent |
|---|---|---|
| Alt + D + F + F | AutoFilter | Alt + A + T |
| Alt + D + F + S | Show All | Alt + A + C |
| Alt + D + F + A | Advanced Filter | Alt + A + Q |
Then press the next letter from the table above. Press Esc to close the menu.
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.
Press F (AutoFilter), S (Show All), A (Advanced Filter).