Add Excel Developer Tab

This Excel tutorial explains the use of Excel Developer Tab and how to add Excel Developer Tab for Excel 2007, 2010 and 2013.

What is Excel Developer Tab?

Excel Developer tab is a category in menu bar which contains everything you need regarding Macro, such as recording Macro, inserting Controls (button,  text box, drop down list, etc), view the Property of Control. Below is a screenshot of Excel 2013 Developer Tab.


In Excel 2003, you can find everything under “Tools” > “Customize”, where you can check box to show the VBA stuff you need.


For Excel 2007 and onwards, you need to add the “Developer” tab in menu  to get all the VBA stuff.

Add Excel Developer Tab

Excel 2007

Right click anywhere on the menu bar > Customize Quick Access Tool Bar > Popular > check the “Show Developer Tab in Ribbon” box

Excel 2010, 2013, 21016

Right click anywhere on the menu bar  > Customize the Ribbon > check “Developer” box.

Below is a screenshot from Excel 2016

add excel developer tab 001

What’s Next?

Now that you have added Developer tab, you can try to create your first Macro by using “Record Macro” function.

Excel Record Macro

Outbound References

2 thoughts on “Add Excel Developer Tab

  1. Hi Wyman, it’s a lucky to visit your blog, I learned very much from your articles, I’d like to say there might be “In Excel 2013”, not “In Excel 2003” in Add Excel Developer Tab.
    I am an Excel fan comes from Suzhou China, thanks again!!!

Leave a Reply

Your email address will not be published.