To show the Developer tab in Excel for Mac, choose Excel › Preferences (Settings on newer macOS), click Ribbon & Toolbar, select Main Tabs under Customize the Ribbon, check Developer, and click Save. The tab appears on the ribbon right away and stays there until you turn it off.
This guide covers the current method, the older View setting some versions use, what the Developer tab is for, recording your first macro, and the Windows steps. The Mac steps come from Microsoft’s guide to using the Developer tab in Excel for Mac.
How to Enable the Developer Tab in Excel for Mac
- Open Excel on your Mac.
- Click Excel in the menu bar and choose Preferences (or Settings).
- Click Ribbon & Toolbar.
- Under Customize the Ribbon, select Main Tabs, then check Developer.
- Click Save and close the window.
Result: A Developer tab appears on the ribbon. It stays visible in every workbook until you uncheck the box.
If you see a View option instead
Microsoft’s Excel for Mac forms article gives an older route that some versions still use: choose Excel › Preferences, click View under Authoring, and check Developer tab under In Ribbon, Show.
What Is the Developer Tab For?
Microsoft lists the Developer tab as the place to write and run macros, use XML commands and form controls, and build add-ins. In Excel for Mac, you’ll mostly use it for:
- Recording macros to repeat a set of steps with one click.
- Visual Basic to open the VBA editor and write or edit macro code.
- Form controls such as buttons, check boxes, list boxes and combo boxes for fill-in forms. Word has its own form tools on the same tab; see how to make a Word document fillable.
- Macros to run or delete macros you’ve saved.
How to Record Your First Macro
- On the Developer tab, select Use Relative References if you want the macro to work from whichever cell is active.
- Select Record Macro.
- Enter a name. Microsoft says it must start with a letter and can’t include spaces, so use underscores between words.
- Choose This Workbook under Store macro in, add an optional shortcut key and description, and click OK.
- Do the steps you want to record, then select Stop Recording.
Result: The macro is saved and can be run from Developer › Macros. To keep it, save the workbook as a macro-enabled file (.xlsm). If you do this often, change the default save type in Excel for Mac to .xlsm.
Microsoft notes that a macro shortcut key overrides any matching Excel shortcut while that workbook is open, so pick a letter you don’t use for something else.
How to Show the Developer Tab in Excel for Windows
- Click File › Options.
- Click Customize Ribbon.
- Under Main Tabs, check Developer.
- Click OK.
Microsoft’s Show the Developer tab article adds that it stays visible unless you clear the box or reinstall Office.
Troubleshooting
- No Developer option in Excel for the web: The Developer tab isn’t available in Excel for the web. Open the file in the desktop app instead.
- The tab disappeared: check the setting again. Microsoft says reinstalling Office can reset it.
- Macros won’t save: save as Excel Macro-Enabled Workbook (.xlsm). Regular .xlsx files can’t store macros.
Frequently Asked Questions
Does the Developer tab change my workbook?
No. It only adds tools to the ribbon. Nothing in your files changes until you use them.
Can I remove the Developer tab later?
Yes. Go back to the same setting and uncheck Developer.
More Excel Guides
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read hundreds of millions of times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.