How to enable Developer Tab in Excel 2010

How to enable Developer Tab in Excel 2010 (with Images)

Steps to Enable Developer Tab in Excel

What is a Developer Tab:  This tab need to be accessed when we are developing or running macros using Visual Basic to use with Microsoft Office programs. In most of the cased by default this tab wont be enabled or added to the Excel Ribbon.

Why is it important: This tab contains lots tools which are essentials when we are creating  applications to use with Microsoft Office programs. For example to insert From Controls and ActiveX Controls while creating a macro.

How to enable Developer Tab in Excel 2010:

Step 1 : Click on ‘Options‘ from the ‘File’ tab.

enable Developer Tab

Step 2: Click on ‘Customize Ribbon‘ from categories pane and enable the ‘Developer’ tab  from the Main Tabs list by clicking the Tick mark . And then click ‘OK‘.

enable Developer Tab

Once enabled it appears in the Excel Ribbon along with the other Excel menus options.

enable Developer Tab


About Anson

I’m Anson having a decade of versatile experience in Business Process Outsourcing, Finance & Accounting, Information Technology, Operational Excellence & Business Intelligence. I have got the opportunity to work for Genpact, Hewlett Packard, M*Modal and Capgemini in various roles and responsibilities, starting from an Associate to a Manager. Learning anything new has always been my passion and if related to Business and Technology then I love it. is an outcome of my passion towards the same and I have been into asKeygeek since 2012. Outside business and technology I’m a movie buff who spends hours together watching and learning Cinema, I do make Short Films 🙂


  1. Pingback: How to enable Developer Tab in Excel 2010 | asK...

  2. Farah Carnegia

    Excellent site you have here but I was wanting to know if you knew of any forums that cover the same topics discussed here? I’d really like to be a part of online community where I can get feedback from other knowledgeable people that share the same interest. If you have any recommendations, please let me know. Thanks a lot!

  3. Johnnie Vaccaro

    I simply want to tell you that I am just very new to blogging and site-building and actually savored this web blog. Most likely I’m likely to bookmark your blog . You definitely have exceptional articles and reviews. With thanks for sharing your web site.

  4. Jacinto Skonczewski

    My husband and i have been now glad Michael could round up his survey from the ideas he grabbed from your very own weblog. It is now and again perplexing just to happen to be freely giving solutions which usually the others could have been trying to sell. So we acknowledge we have got the blog owner to be grateful to for this. The type of illustrations you made, the straightforward site menu, the friendships you make it possible to instill – it is many fabulous, and it is facilitating our son in addition to the family reason why the subject matter is pleasurable, and that is wonderfully mandatory. Thanks for all the pieces!

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.