How to show Developer tab in Excel?

In our previous article, you have learned How to Hide Formula in Excel 2007, 2010 & 2013. Now this article will explain you how to show developer tab in Excel.

You might be thinking about why we need to have a developer tab in Excel.

The answer is, you need a developer tab to open the VBA editor, create Macros and Form/ActiveX Controls like buttons, check-boxes, etc.

Follow below mentioned 3-step quick process to show developer tab in Excel 2007.


Open Microsoft Office Excel 2007 and click on START button in the top left of your Excel window. Now select Excel Options button.

Show Developer tab in Excel


Check “Show Developer tab in the Ribbon” option under Popular tab in Excel Options.

As soon as you click on “Show Developer tab in the Ribbon” option, it gets automatically activated in your excel.

Show Developer tab in Excel


Now you can see the below snapshot where Developer tab is enabled.

Show Developer tab in Excel

You can share this tip with your friends and colleagues that will help them to show developer tab in Excel. You can also write your comments about this article in comment section.

Subscribe to get free tech advice, tips and in-depth articles.

Start Your Dream Website Today & Earn Money Online

To Start a dream website, choose a Domain Name & Reliable Hosting Provider, Self-hosted Blogging Platform, WordPress Theme, Email Marketing and SEO Tool for traffic.

SiteGround Hosting Discount - 60% OFF
ConvertKit The Best Email Marketing Software
Free SEMRush SEM and SEO Tool
Get Your Hosting Package with SiteGround, Increase new email subscribers with ConvertKit and Research Keywords with SEMRush to Boost Organic Traffic.

Leave a Reply

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