How to add developer tab in Excel?

Things you need to know about Developer tab in Excel

By default all the Microsoft Office products don’t show the developer tab that’s because this tab is like its name a little bit advanced, means only for Developer but in this tutorial, we are going to display it once for a time and you can use it whenever you want.
Also, there is no shortcut to display the Developer tab in Excel, there is one only method to do that let’s explain it together.

Add the developer tab to the ribbon in Excel 2016

1. The Ribbon
   It’s simply the third top bar in Excel (under the menu bar)
   

   Menu, Title and the Ribbon bar

2. Customize the Ribbon: by choosing an empty area in the Ribbon and click left button
   

   Customize the Ribbon

3. Add the developer tab to the ribbon: A window of Excel Options will appear and you just need to check the Developer checkbox and click the “OK” button.
   

   Add the developer tab to the ribbon

4. The Developer tab in Excel
   

   The Developer tab in Excel

Other versions of Excel

To get the Developer tab in Excel 2013 or 2010 use the same points as Excel 2016.
For Excel 2007 :

1. Click the Office Button in left top of Excel
2. Click the Excel Option button at the bottom, and Excel option window will appear
   

   Excel 2007 option window

3. Click the Popular menu at the left
4. In the section “Top Option for Working with Excel”, check or enable the Show Developer tab in the Ribbon option
   

   Show Developer tab in the Ribbon option

5. Click Ok button to save

Unfortunately for the Excel 2003 there is no Developer tab :p but there is the menu “Tools” that contains the same element as the Developer tab in the other version.

Developer tab in Excel with shortcut

Follow those quick steps to add the developer tab in Excel for Windows and Mac systems with only using the keyboard.

 

Now you know how to add a Developer tab in Excel and use it like a pro :).

If you like this tutorial please like and share :).