How to add and use Developer tab in Excel

Here's how to quickly enable Developer tab in Excel!

The Microsoft X logo on a blue background featuring the Developer tab.

You can trust PC GuideOur team of experts use a combination of independent consumer research, in-depth testing where appropriate – which will be flagged as such, and market analysis when recommending products, software and services. Find out how we test here.

Last Updated on

If you want to know how to add Developer tab in Excel, we’ve got you covered right here.

Some of the features Excel offers are actually hidden, and they need specific commands and steps inputted before you can use them. One of these features is the Developer tab, which allows users to use advanced functions such as writing code, creating macros, designing forms, and importing and exporting XML file formats.

In this guide, we’ll go over how to add Developer tab in Excel, along with how to use it. So, without any further ado, let’s dive in!


How to show Developer tab in Excel

Because the Developer Tab isn’t usually needed for standard Microsoft Excel use, it is hidden away within the Ribbon Tab.

Follow these steps to enable the developer tab in Excel.



Go to any tab

First, go to any tab and press right-click anywhere in the ribbon. For those who don’t know, the ribbon is the place where you find all the options of a certain tab.



Choose Customize

Next, from the list of options that will appear, choose Customize the Ribbon.

A screenshot of the Developer Tab in Excel on a computer.



Click on Developer

Finally, scroll through the options under Main Tabs, and check the box next to Developer.

A screenshot of a computer showing the Excel application with the Developer tab active.

This will enable the Developer tab in Excel.

Learn how to create a chart using the Developer Tab in Excel.

Can I reposition the Developer tab in Excel?

To reposition the Developer tab, you will need to go back to the Customize the Ribbon options and click on the upward or downward arrow on the right side of the Main Tabs. Make sure the Developer option is selected as you click on the arrows.

How to use Developer tools in Excel

Now the Developer Tab has been activated, you might want to know what some of the tools and features available actually do: 

  • Interactive Controls: The Interactive controls give you access to Active-X and form tools. They let you insert interactive tools into your Excel spreadsheets, such as checkboxes, radio buttons, combo boxes, and scrollbars. 
  • Add-Ins: Add-ins let you manage any inbuilt add-ins as well as any new add-ins you may have added to the spreadsheet.
  • Macro Options: If you use coding a lot in your professional career or you just have an interest in using it, the Marco Option is a great feature for you. It gives you access to lots of macro options such as VB Editor and changing macro security,

Final thoughts

With the steps provided here, you’ll be able to add the Developer tab in Excel in no time. If you’re looking for more advanced options and tools within Excel, then gaining access to the Developer Tools could be the perfect option for you. If you play around with the different features that are included in the Developer Tools, you’ll find just how useful they can be in making your spreadsheet even more advanced. And if you want to remove it, you just have to go back to the customize options and uncheck the Developer box from there.

Learn more about Excel and its features through these guides:

Kevin is the Editor of PC Guide. He has a broad interest and enthusiasm for consumer electronics, PCs and all things consumer tech - and more than 15 years experience in tech journalism.