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:
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.
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:
Click on View:
Click on the checkbox labeled Developer Tab: