The Developer tab in Excel contains tools for macros, Visual Basic for Applications, form controls, and add-ins. It is hidden by default in many Microsoft 365 installations, but you can display it from Excel’s ribbon settings.
Show the Developer tab in Excel
- Open Microsoft Excel.
- Select File > Options.
- Choose Customize Ribbon.
- In the Main Tabs list on the right, check Developer.
- Click OK.
The Developer tab should now appear on the ribbon. Enabling the tab does not automatically enable macros in workbooks.
Macro security is separate
Excel may block or warn about macros based on Trust Center settings and the source of the file. Do not weaken macro security merely because a workbook asks you to enable content. Only run VBA or add-ins when you trust their source and understand why they are needed.
If your organization manages Microsoft 365, administrators may control macro behavior even though you can display the Developer tab yourself.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.