![show developer tab excel 2016 show developer tab excel 2016](https://images.saymedia-content.com/.image/t_share/MTc1MDE0NDYxODk4MjM3NzM5/how-to-add-the-developer-tab-to-ms-excel-2016.png)
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.
![show developer tab excel 2016 show developer tab excel 2016](https://thedatalabs.org/wp-content/uploads/2020/11/Develop-Tab-in-Excel.jpg)
Under the list of Main Tabs on the right, select the Developer check box and click OK. Microsoft has chosen to hide this Ribbon tab by default. This is what you need to do: Right-click anywhere on the ribbon and choose Customize the Ribbon in the pop-up menu of options: The Excel Options dialog window will show up with the Customize Ribbon option on the left selected. Ability to insert Form and ActiveX controls (think drop downs, scroll bars, check boxes, etc.).Access to the VBE ( Visual Basic Editor).
#Show developer tab excel 2016 how to
Today you will learn how to unlock some of Microsoft Office's more advanced tasks. Click the Excel Option button at the bottom, then you will enter the Excel Option window Click the Popular button at the left Under Top Option for Working with Excel, check the Show Developer tab in the Ribbon option. 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). Now uncheck the developer Tab from the Main Tabs list in the excel options window (Right Side). Click on Customize the Ribbon, this will show you Excel options window. Please find the below screen shot for the same. Then click Developer > Insert > More Controls. You can typically spot an advanced Excel user from a normal one by looking at their ribbon. The Developer tab is not displayed on the Ribbon in Office apps by default, but it’s easy to add and gives you access to advanced features like macros, ActiveX controls, and form controls to Word, Excel, PowerPoint, and Visio. Right click on any main menu item in the Ribbon. In the Excel Options dialog box, click Popular in the right bar, then check the Show Developer tab in the Ribbon box, and finally click the OK button.