Access Excel Options, Add-Ins, and Macros on Mac
Question details
Find Excel settings, add-ins, macros, and VBA tools on a Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- A user wants to manage Excel settings and development tools without the Windows File > Options menu.
- Observed behavior
- Excel for Mac uses the macOS menu bar and Excel preferences instead of the Windows File > Options menu.
Open Excel and make sure it is the active app so its menus appear in the macOS menu bar. Open the relevant workbook if you want to run or edit a macro.
Use Excel for Mac menus to access settings, add-ins, and macros
Use the Mac menu bar and Developer tab to find tools that appear in different locations on Windows.
In the macOS menu bar, choose Excel > Preferences to find Excel settings. In some versions, this may appear as Excel > Settings.
Choose Tools > Excel Add-ins. Select or clear the available add-ins you want to use, then confirm your choices.
Choose Excel > Preferences > Ribbon and Toolbar. Under the ribbon tabs, select Developer and save your changes.
Choose Tools > Macro > Macros to view or run a macro. To edit VBA code, choose Tools > Macro > Visual Basic Editor or use Visual Basic on the Developer tab.

Work with spreadsheets in WPS Office for Mac
WPS Office is a free, lightweight alternative with a familiar interface for everyday spreadsheet work. Open compatible Excel files to transition between office suites without rebuilding your documents.

Frequently Asked Questions
Where is File > Options in Excel for Mac?
Excel for Mac does not have the Windows File > Options menu. Choose Excel > Preferences or Excel > Settings in the macOS menu bar instead.
How do I show the Developer tab in Excel for Mac?
Choose Excel > Preferences > Ribbon and Toolbar, select Developer under the ribbon tabs, and save your changes.
How do I open the VBA editor on a Mac?
In Excel, choose Tools > Macro > Visual Basic Editor. You can also use Visual Basic on the Developer tab after enabling it.
Can I use Windows Excel add-ins on a Mac?
Not all add-ins are compatible. Check Tools > Excel Add-ins for available Excel add-ins, and consult the add-in provider about Mac support. Windows-only COM add-ins do not run on Mac.




