Option-Key Shortcuts in Excel for Mac: Dropdown Lists, VBA Editor and Macro Dialog (2026)
Which Alt-style shortcuts become Option shortcuts in Excel for Mac?
Microsoft's Mac table lists Option+Down arrow for the Filter list and AutoComplete list, Option+F11 to open Visual Basic and Option+F8 to display the Macro dialog box.
| Task | Mac shortcut (Microsoft) | Exceljet |
|---|---|---|
| Display the Filter list or PivotTable page field menu | Option+Down arrow key | Option+Down (Activate filter) |
| Display the AutoComplete list | Option+Down arrow key | Option+Down |
| Open Visual Basic | Option+F11 | Not opened |
| Display the Macro dialog box | Option+F8 | Not opened |
| Insert an Excel 4.0 macro sheet | Cmd+F11 | Not opened |
| Open the Power Query Editor | Option+F12 | Not opened |
Exceljet lists the Option key and the down arrow for both Display AutoComplete list and Activate filter, which matches Microsoft.
What about the dropdown list for data validation?
Microsoft's Mac table does not name data validation lists; it lists Option+Down arrow for the Filter list, PivotTable page field menu and AutoComplete list, so treat validation lists as untested.
We found no opened source that says Option+Down opens a data validation list on a Mac. If you need that, test it on your Mac before telling a team it works.
What other Option and Cmd function-key shortcuts does Microsoft list?
Microsoft's Mac table also lists Cmd+F11 to insert an Excel 4.0 macro sheet and Option+F12 to open the Power Query Editor, so Option and Cmd carry several function-key shortcuts.
The same table lists F12 for the Save As dialog box and Cmd+F12 for the Open dialog box, which shows how many macOS function-key combinations Microsoft assigns.
Why do the F keys on a MacBook not respond?
Apple says the top-row keys on many Apple keyboards have special functions, and to use them as F1, F2 or other standard function keys you combine them with the Fn or Globe key.
So Option+F11 may need to be typed as Option+Fn+F11 on a MacBook whose top row defaults to brightness, volume and similar controls. Microsoft's page includes a section on changing function key preferences, which we did not read in full. Our guide to the Fn setting covers that choice.
What do the sources say?
Microsoft and Exceljet agree that Option with the down arrow opens the filter and AutoComplete lists, and Microsoft alone lists the Option+F11 and Option+F8 macro shortcuts, with Apple explaining the Fn requirement.
None of the pages we opened is dated, and we did not run any of these shortcuts.
Where does Mac Excel Shortcuts fit?
Mac Excel Shortcuts is our app that replicates Windows Excel shortcuts on a Mac. We did not check whether it covers these shortcuts, so see the covered-list page before relying on it.
It has a free trial of 7 days or 10 shortcut uses, then costs $49 once or $4.99 a month. This page is not a test of the app. See the list of shortcuts it covers.
FAQs
How do I open the VBA editor in Excel for Mac?
Microsoft lists Option+F11 to open Visual Basic. On a MacBook you may need Fn as well.
How do I open the macro dialog in Excel for Mac?
Microsoft lists Option+F8 to display the Macro dialog box.
How do I open a dropdown with the keyboard?
Microsoft lists Option+Down arrow for the Filter list, PivotTable page field menu and AutoComplete list. It does not name data validation lists.
Why does Option+F11 do nothing on my MacBook?
Apple says top-row keys act as special keys unless combined with Fn or Globe. Try Option+Fn+F11.
Related guides
Function keys in Excel for Mac and the Fn setting: F-key behaviour.
Alt key equivalent on Mac: the Alt-to-Option overview.
Mac Excel shortcut cheat sheet: the wider list.
How we checked this guide
We opened the pages below on November 15, 2026. We read Microsoft's Excel for Mac shortcut table directly from the page and compared it with the other sources. We did not test Excel on a Mac. Limits: Microsoft and Exceljet carry no edit date; Exceljet was read only through its index; data validation lists and the Option+Fn+F11 typing are not covered by any opened source.
References
Microsoft Support, Keyboard shortcuts in Excel, undated (page footer shows 2026). Mac section read November 15, 2026.
Exceljet, Excel shortcuts, undated. Accessed November 15, 2026.
Apple Support, Mac keyboard shortcuts, published September 14, 2026. Accessed November 15, 2026.
