How to Display Developer Tab on the Ribbon in Excel

When you’re planning to work with VBA macros, you’ve to make sure that the Developer tab is present on the Excel Ribbon. The Developer tab containing useful commands for VBA users does not appear by default. In this tutorial, we are going to show some steps to display the Developer tab on the ribbon in Excel.


Download Practice Workbook

Download the following practice workbook. It will help you to realize the topic more clearly.


Features of Developer Tab

Basically, the Developer tab allows you to explore the more advanced features and unique functions of Excel. This ribbon tab contains diverse features such as:

  • Visual Basic→ Basically, it launches the VB editor where one can input the code that he wants to run (Keyboard shortcut ALT + F11).
  • Macros→ From the developer tab we can record new macros and get the list of available macros for our desired work (Keyboard shortcut ALT + F8).
  • Add-ins→ There are Excel Add-ins and COM Add-ins which we can insert into the worksheet.
  • Controls→ In this feature, we can modify the control properties. We can also view the code and run the dialog.
  • XMLXML mainly includes XML source task pan to map the properties and expansion packs. It also imports an XML data file.

2 Steps to Display the Developer Tab on the Ribbon in Excel

If you want to apply and run VBA code in Excel, you have to go to the developer option first. It is not displayed in the ribbon by default. But you can customize it by following the 2 simple steps, we discussed below.


Step 1: Open Excel Options and Navigate to Customize Ribbon Option

Microsoft Excel provides numerous features to ease our comfort. We need to open Excel Options first to show the Developer ribbon tab. Then we need to choose the Customize Ribbon option to display the Developer tab. Here we share 3 ways to open it for opening the Excel Options and accessing the Customize Ribbon.


1. Utilizing the File Tab

As you know, the File tab in Excel provides some necessary Excel features e.g. Open, Save, Save As, Options, etc. Luckily, you can customize the ribbon by clicking the Options from the File tab.

  • Initially, go to the File tab.

Utilizing the File Tab to display the developer tab

  • Then choose the Options as shown in the below screenshot.

Opening Excel option

  • Immediately, the Excel Options dialog will appear in front of you. Now, pick the Customize Ribbon option.


2. Using Keyboard Shortcut

Now, we know what you’re thinking. Are there any shortcut keys? Lucky you! There are shortcut keys for opening Excel Options. We describe it below.

  • Just press ALT + F + T to open the Excel Options dialog box.

Using Keyboard Shortcut to open Excel option for displaying the developer tab

  • After that, choose the Customize Ribbon option from the Excel Options box.


3. Right-Clicking on the Ribbon

Unlike the previous two methods, we may open the Customize Ribbon option from the Excel Options directly. We can open the Customize Ribbon option by following the process.

  • Firstly, right-click on any option of the ribbon. Thus, a wizard will appear.
  • Next, click on Customize the Ribbon.

Right Click to Customize the Ribbon 

Consequently, you’ll see the Customize Ribbon option in the Excel Options. Have a look at the following picture.

Customize ribbon


Step 2: Format the Customize Ribbon Option

We can import or export any tabs in the ribbon by customizing them. Personalizing the ribbon helps you to maintain the correct order you want to organize them. We can also hide some tabs if we don’t want them, or we can unhide them from the Customize Ribbon also. Utilizing the Customize Ribbon option, we can also display the Developer tab, where we can do our VBA and macros.

  • Now, go to the Customize Ribbon >> check the Developer box >> select OK.

Format the Customize Ribbon Option to display the developer tab

  • Finally, the Developer tab will appear in the ribbon bar.


Conclusion

That’s all about today’s session. And these are some easy methods on how to display the developer tab on the ribbon in Excel. Please let us know in the comments section if you have any questions or suggestions. For your better understanding please download the practice sheet. Visit our website Exceldemy, a one-stop Excel solution provider, to find out diverse kinds of excel methods. Thanks for your patience in reading this article.

Tags:

Kawser

Kawser

Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Not only how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can checkout my courses at Udemy: https://www.udemy.com/user/exceldemy/

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo