Office for Mac Issues

Access Excel Options, Add-Ins, and Macros on Mac

Olivia MillerOlivia Miller Nov 14, 2026 868 views

Question details

Find Excel settings, add-ins, macros, and VBA tools on a Mac.

How to Access Excel Options, Add-Ins, and Macros on 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.
Before you start

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.

Solution 1Recommended

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.

1
Open Excel preferences

In the macOS menu bar, choose Excel > Preferences to find Excel settings. In some versions, this may appear as Excel > Settings.

2
Manage Excel add-ins

Choose Tools > Excel Add-ins. Select or clear the available add-ins you want to use, then confirm your choices.

3
Enable the Developer tab

Choose Excel > Preferences > Ribbon and Toolbar. Under the ribbon tabs, select Developer and save your changes.

4
Access macros and VBA

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.

Use Excel for Mac menus to access settings, add-ins, and macros
Check add-in and macro compatibility: Windows-only COM add-ins and some VBA code may not work in Excel for Mac. Enable macros only in workbooks you trust.
Free Microsoft Office alternative

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.

Edit spreadsheets using a familiar ribbon-style interfaceOpen and save compatible Microsoft Excel formats, including XLSXUse spreadsheet tools for everyday data managementWork in a lightweight office suite with a free version
microsoft office alternative - wps office

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.