Excel with Examples

How to add developer tab in Excel?

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

    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

    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

    Add the developer tab to the ribbon

  4. The Developer tab in Excel
    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

    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

    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.

Developer tab in Excel with shortcut

Developer tab in Excel with shortcut

 

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 :).

Leave a Comment