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.

developer_tab

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

developer_tab_01

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

https://www.youtube.com/watch?v=dgCg_XWiJ9s

https://www.youtube.com/watch?v=JseW8fq9eZ8

Wyman W
Wyman is a Business Analyst based in Hong Kong, specialized in creating custom Function and Sub solutions, and is proficient in report automation with Access.

He is also a:
- Microsoft Most Valuable Professional (Excel)
- Microsoft Community Contributor
- Microsoft Office Specialist
- Microsoft Specialist
- Microsoft Technical Associate
- Microsoft Certified Professional
- IBM SPSS Specialist

2 thoughts on “Add Excel Developer Tab

  1. Orrin says:

    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!!!

    1. Wyman W Wyman W says:

      Thank you for your support and visiting my site!

Leave a Reply

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