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.
Microsoft Excel



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.
Microsoft Excel


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).
Microsoft Excel


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.

Comments

Popular posts from this blog

GSTIN CheckSum Digit Logic

Spell-Number in Rupees Excel VBA Formula

Convert Number to Words Currency in MS Word