How to Get Developer Tab in Excel (3 Quick Ways)

The developer tab is an important feature in Excel. While using VBA, this tab helps a lot. But by default, this tab gets hidden. No worries! It’s quite easy to get it in the ribbon. So in this article, I’ll show 3 quick ways to get the developer tab in Excel.


What Is the Developer Tab?

The Developer tab in Excel is a feature. And it is basically get hidden by default.

By using this tab we can make VBA applications, create macros, record macros, use add-ins, design forms, insert controls, import-export XML data, etc.


3 Ways to Get Developer Tab in Excel

Have a look that the Developer tab is not enabled in my Excel 365. Now go forward to see how to enable it.


1. Apply Shortcut Way to Get Developer Tab in Excel

First, we’ll learn a shortcut method to get the Developer tab. It’s one of the easiest and fast ways.

Steps:

  • Right-click your mouse on any position in the ribbon bar.
  • Select Customize the Ribbon from the context menu.

Soon after a dialog box named Excel Options will open up.

Apply Shortcut Way to Get Developer Tab in Excel

  • Mark Developer from the Main Tabs section.
  • Then just press OK.

Apply Shortcut Way to Get Developer Tab in Excel

Now see that the tab is enabled successfully in the ribbon bar.

Read More: How to Hide Ribbon in Excel (6 Simple Ways)


2. Use Excel File Option to Enable the Developer Tab

We can open the Excel Options dialog box in another way and then we can enable the tab from there. Let’s see how to do it.

Steps:

  • Click on File beside the Home tab.

Use Excel File Option to Get Developer Tab

  • After that click Options from the appeared menu and then you will get the Excel Options dialog box.

Use Excel File Option to Get Developer Tab

  • Next, click on the Customize Ribbon.
  • Later, mark Developer from the Main Tabs section.
  • Finally, just press OK.

Use Excel File Option to Get Developer Tab

Then you will get the tab in the ribbon bar.

Read More: How to Show, Hide, & Customize Excel Ribbon


Similar Readings


3. Customize Quick Access Toolbar to Get the Developer Commands

In this last method, I’ll show an alternative way where you won’t get the Developer tab directly but you will be able to add specific commands to the Developer tab by customizing the Quick Access Toolbar.

Steps:

  • First, click on the Customize Quick Access Toolbar icon.
  • Then select More Commands from the appeared list.

Customize Quick Access Toolbar to Get the Commands of the Developer Tab

  • Next, choose the Developer Tab from the Choose Commands from box.
  • Later, select the command you want to add. I selected Macros [View macros].
  • Then press the Add button.

Customize Quick Access Toolbar to Get the Commands of the Developer Tab

The command is added now.

  • Finally, press OK.

Customize Quick Access Toolbar to Get the Commands of the Developer Tab

Here’s the Macros command in the toolbar.

  • Click it and you will get the Macros dialog box.

It’s the appeared Macro dialog box after clicking the command.

Read More: Types of commands on the Ribbon


Conclusion

I hope the procedures described above will be good enough to get the developer tab in Excel. Feel free to ask any question in the comment section and please give me feedback.


Related Articles

Tags:

Mithun

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo