Nov 16, 2018 - To add/enable developer tab in excel 2007, 2010, 2013, 2016 & excel 2011 For Mac. Just Follow these simple steps to insert the developer tab.
This is an update to a post I had done earlier. I’ve now added a YouTube video to go along with the post. One of the things that I searched for and had a hard time finding in the Mac version of Excel was how to add the Developer tab to the Ribbon. The Developer tab is a handy way to launch the Visual Basic Editor, launch the Macro dialog box, quickly start recording a macro and access many of the other developer tools available. To add the Developer tab, select Excel from the menu. It is between the Apple logo and File in the upper left hand corner of the menu. From the drop down menu select Preferences.
In the Sharing and Privacy section, select Ribbon. In the middle of the Ribbon dialog box you will see a box listing Tab or Group title. Scroll through this list and find Developer.
Check the box and click OK. You know have access to the Developer tab on the Ribbon. Hopefully this will help someone from countless, fruitless Internet searches that I had to do to discover this information.