How to show the Developer Tab in Excel
By default, the Developer Tab is not displayed as a menu option in Excel when you first open it up. You can, however, add it by following the few steps below.
Adding the Developer Tab to your Ribbon menu allows you to:
- Write macros and VBA (Visual Basic for Applications) code.
- 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.
By default, the Developer Tab is not displayed as a menu option in Excel. You can add it in a few steps. Click To Tweet
How to show the Developer tab
Step 1 Click the File tab and then click Options
Step 2 Click Customize Ribbon.
Step 3 Under Customize the Ribbon and under Main Tabs, select the Developer check box and then click OK.
The Developer Tab will now show in the Ribbon Menu for you and will continue to show in Excel until you either reverse the instructions below or you reinstall Excel on your computer.
Please Share
If you liked this article or know someone who could benefit from this information, please feel free to share it with your friends and colleagues and spread the word on Facebook, Twitter or Linkedin.