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.
- 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.
- Mark Developer from the Main Tabs section.
- Then just press OK.
Now see that the tab is enabled successfully in the ribbon bar.
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.
- Click on File beside the Home tab.
- After that click Options from the appeared menu and then you will get the Excel Options dialog box.
- Next, click on the Customize Ribbon.
- Later, mark Developer from the Main Tabs section.
- Finally, just press OK.
Then you will get the tab in the ribbon bar.
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.
- First, click on the Customize Quick Access Toolbar icon.
- Then select More Commands from the appeared list.
- 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.
The command is added now.
- Finally, press OK.
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.
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.