Microsoft Excel is one of the most powerful application software that Microsoft made.
Need of Developer Tab in Microsoft Excel?
We can do from simple calculations to very very complex calculations as well as many customization through macro and integrated VBA programming.
But, to record Macros or to insert some interactive components like Check-boxes, Radio Button and Combo box and many other controls, we need to have Developer tab where all these commands are located.
Lets have a look at our requirement, we are here displaying the screenshot before developer tab.
How to enable Developer Tab in Excel?
Step 1: Click on File menu and choose options as shown in below screen.
Step 2: Clicking on Options menu will bring you a new dialogue box having all the Microsoft Excel options. From the left side options choose, Customize Ribbon option. Check below screenshot.
Have a look at above screens, we have highlighted the value to be noticed in this case.
Step 3: Check on Developer check-box under Main Tab section in right section and click on OK.
Output – Developer Commands in Excel
Once we click on OK button above, no need to restart Microsoft Excel, Here we got the Developer Tab. In future series on Microsoft Excel, we will continue to write about Microsoft Excel for advanced users and use of developer controls given.
Video version of this article can be found on our YouTube channel.
Thank you for reading. We have more articles on Microsoft Excel. Do not forget to share the post if you find it helpful.