Enable Developer Tab – Excel 2007 to Excel 2016 and Office 365

Written by Amey Dabholkar

June 28, 2015

I have been asked by many of the Excel viewers regarding how to enable developer Tab.
There are different steps for the different version. I have divided the Excel Versions into two groups one is Excel 2007 and another is Excel 2010 + (Including Excel 2013). The procedure for Excel 2010 and Excel 2013 is same. The main difference in Excel 2007 and Excel 2010 + is that in Excel 2010 + you can create your own custom tabs.  But before learning on how to enable developer tab we will first learn what is the use of developer tab. The reason is that many of our readers are not familiar with the use of developer tab.

Use of Excel Developer Tab

One can use Excel Developer tab to add macros and VBA functionality to Excel. One can create their own function one can also repeat the events with a click of a button (Macro) , you could also create a user form. Let’s learn step by step on how to become pro in VBA for Excel

Group 1 : Excel 2007 Enable Developer tab

In Excel 2007 there is only one method to enable the developer tab.

In the above image, you can go to the Popular tab and then in the Top options for working with Excel just check the option which states ” Show developer tab in the Ribbon” and click ok and you will see the developer tab.

Group 2: Excel 2010 , Excel 2013.

In Excel 2010 and Excel 2013, there are many options you could enable developer tab. We would study some of them in order to enable developer tab.

Once you right click on the ribbon then click on customize the ribbon. There it will show a menu having the list of all different tabs. Just check the Developer tab and click ok to add a developer tab. In this option, you could also Enable and disable different tabs like View, Data etc. It is recommended that not to disable any tab because they are helpful in many places.

In the later blog post, i will also teach you how to create a custom menu in Excel 2013. This will help you to add a popular command to that menu and also you could add your own PERSONAL.XLSB macros to the ribbon. Be sure to check it out.



Submit a Comment

Your email address will not be published. Required fields are marked *

Pin It on Pinterest

Share This