#Where is the developer tab in excel how to

I am assuming this is done because the majority of users do not use (learn to use) all the awesome stuff stored on the tab. Microsoft has chosen to hide this Ribbon tab by default.

Ability to insert Form and ActiveX controls (think drop downs, scroll bars, check boxes, etc.).

Open Excel from the Start menu and create a blank workbook by double-clicking the Blank workbook option (selected by default).

#Where is the developer tab in excel how to

In this tutorial, Ill show you how to activate the Excel Developer tab. Even if you donвЂ™t need to use form controls, XML, or add-ins, itвЂ™s nice to know where they are. Excel doesnt show the Developer tab by default, so youll need to dive into the options to find the correct setting.

Access to the VBE ( Visual Basic Editor) The Developer tab opens up some very powerful possibilitiesespecially if you take advantage of Excel automation with Visual Basic and Excel macros.Today you will learn how to unlock some of Microsoft Office's more advanced tasks. But the steps are the same for Outlook, Excel. We show you here how to enable the Developer tab in Word. Things like a fully loaded QAT (Quick Access Toolbar) and extraneous add-in tabs are dead giveaways a user is delving into some of the more advanced functionalities of Excel (this assumption can be applied to Word & PowerPoint also). The Developer tab is a pre-built custom tab that has a good variety of advanced commands. You can typically spot an advanced Excel user from a normal one by looking at their ribbon.