There’s a reason we’re starting our Excel VBA Tutorials series with this article. Enabling the developer tab in Excel unlocks a world of automation possibilities.
- Right click your top ribbon.
- Click Customize the Ribbon.
- Make sure “Main Tabs” is selected in the drop-down menu on the right. It will likely be selected by default.
- Check the box next to “Developer.”
- Click OK.
You’ll now see the Developer tab in the Excel Ribbon. Starting in the next lesson, you will begin to learn what kind of neat VBA tricks you can do with the Developer tab.