Developer tab in Excel: how to add, use and remove

This short tutorial will teach you how to get Developer tab in Excel 2010, Excel 2013, Excel 2016, and Excel 2019.

You want to access one of advanced Excel features but are stuck at the very first step: where's the Developer tab they are all talking about? The good news is that the Developer tab is available in every version of Excel 2007 to 2019, though it is not enabled by default. This article shows how to quickly activate it.

Excel Developer tab

The Developer tab is a useful addition to the Excel ribbon that allows you to access some of advanced features such as:

  • Macros - Write new macros using the Visual Basic editor and run macros you have previously written or recorded.
  • Add-ins - Manage your Excel add-ins and COM add-ins.
  • Controls - Insert ActiveX and Form controls into your worksheets.
  • XML - Use XML commands, import XML data files, manage XML maps, etc.

Excel Developer tab

Most often, the Developer tab is used for writing VBA macros. But it also provides access to a handful of other features that do not require any programming skills! For example, even an Excel novice can use the Developer tab to insert a check box, scroll bar, spin button, and other controls.

Where is the Developer tab in Excel?

The Developer tab is available in all versions of Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, and Office 365. The problem is that by default it stays behind the scene, and you need to show it first by using a corresponding setting.

Luckily for us, it's one-time setup. Once you activate Developer tab, it will stay visible when you open your workbooks next time. When you reinstall Excel, you will have to show the Developer tab again.

How to add the Developer tab in Excel

Though the Developer tab is hidden in every fresh installation of Excel, it is very easy to enable it. This is what you need to do:

  1. Right-click anywhere on the ribbon and choose Customize the Ribbon… in the pop-up menu of options:
    Customize the Ribbon…
  2. The Excel Options dialog window will show up with the Customize Ribbon option on the left selected.
  3. Under the list of Main Tabs on the right, select the Developer check box and click OK.

Adding the Developer tab in Excel

That's it! the Developer tab is added to your Excel ribbon. Next time you open Excel, it will be displayed for you.

Tip. Another way to get the Developer tab in Excel is to go to the File tab, click Options > Customize Ribbon and check the Developer box.

Reposition the Developer tab on the ribbon

When you enable Developer tab in Excel, it is automatically placed after the View tab. However, you can easily move it wherever you want. For this, do the following:

  1. Click on the Developer tab under Customize the Ribbon in the Excel Options dialog window.
  2. Click on the upward or downward arrow on the right. Each click moves the tab one position to the right or left on the ribbon.
  3. Once the tab is positioned properly, click OK to save the changes.

Reposition the Developer tab on the Excel ribbon

How to remove the Developer tab in Excel

If at some point you decide that you do not need the Developer tab on your Excel ribbon, simply right-click on any tab on the ribbon, pick Customize the Ribbon, and clear the Developer box.

On the next start of Excel, the tab will remain hidden until you select its checkbox again.

That's how to show the Developer tab in Excel. I thank you for reading and hope to see you on our blog next week!

You may also be interested in:

One Response to "Developer tab in Excel: how to add, use and remove"

  1. Imran Masud says:

    Lot of thanks Svetlana to teach us.

Post a comment

Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
Ultimate Suite 2018.5 for Excel
60+ professional tools for Excel 2019-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Sheila Blanchard