Answer for How to Display / Activate DEVELOPER tab in Excel? What is Use of Developer Tab in Excel
Question: In Microsoft Excel, how do I get the DEVELOPER tab at my ribbon? Answer: To display the DEVELOPER tab, click on the File menu and then select Options from the drop down menu. When the Excel Options window appears, click on the Customize Ribbon option on the left. Click on the Developer checkbox under the list of Main Tabs on the right. Then click on the OK button. Now you should see the DEVELOPER tab in the toolbar at the top of the screen. All of the DEVELOPER tab option groups should be available - Code, Add-Ins, Controls, ML, and Modify (see below). Uses of Developer Tab: Write macros. Run macros that you previously recorded. Use XML commands. Use ActiveX controls. Create applications to use with Microsoft Office programs. Use form controls in Microsoft Excel. Work with the ShapeSheet in Microsoft Visio. Create new shapes and stencils in Microsoft Visio.