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

March 07, 2018

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

If this article helps solve your problem, please consider supporting me because it takes a lot of effort (and coffee!) to provide this content.

👇 There's a special gift for you in return for your support.

Buy Me a Coffee at ko-fi.com

Enjoy the post!

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


Wow, you read the whole article! You know, people who make it this far are true learners. And clearly, you value learning. Would you like to learn more about Excel? Please consider supporting me by buying me a coffee (it takes a lot of coffee to write these articles!).

Buy Me a Coffee at ko-fi.com

Written by Joseph who loves teaching about Excel.

© 2021, Spreadsheets Made Easy