developer tab - feature image

How to Enable the Developer Tab on the Ribbon (Windows or Mac)

The Developer Tab is where you’ll find tools that you can use to record macros, access the Visual Basic Editor, add add-ins, and more. However, the Developer Tab is disabled by default. In this post, we’ll quickly cover how to enable the Developer Tab for both Windows and Mac.

Developer Tab in Windows

To enable the Developer Tab in Windows:

  • Click on File
  • Then Options
  • Then Customize Ribbon
  • Then on the right side, click on the checkbox for Developer

Here’s an animated gif to further illustrate how to enable the menu for Windows:

developer tab - windows

Developer Tab in Mac

Enabling the the menu in Mac is slightly different. To enable the Developer Tab:

Click on the main Excel menu, then Preferences:

developer tab - mac - preferences

Click on View:

developer tab - mac - view

Click on the checkbox labeled Developer Tab:

developer tab - mac - enable

Are you ready to master Excel Dashboards?

Learn Excel Dashboard Course Power BI Webinar

Still not convinced? Check out my review of the course!