The Developer Tab
You can typically spot an advanced Excel user from a normal one by looking at their ribbon. Things like a fully loaded QAT (Quick Access Toolbar) and extraneous add-in tabs are dead giveaways a user is delving into some of the more advanced functionalities of Excel (this assumption can be applied to Word & PowerPoint also).
Today you will learn how to unlock some of Microsoft Office's more advanced tasks. This includes
- Access to the VBE (Visual Basic Editor)
- Ability to insert Form and ActiveX controls (think drop downs, scroll bars, check boxes, etc...)
- Import and Export XML files
How To Add the Developer Tab
Microsoft has chosen to hide this Ribbon tab by default. I am assuming this is done because the majority of users do not use (learn to use) all the awesome stuff stored on the tab. The Developer tab is hidden away on most of the Office Suite's programs but in this post I will cover get it showing in Excel, PowerPoint, and Word.
1. Click the File Tab and select Options
2. Click Customize Ribbon
3. Check the box next to Developer in the Main Tabs listbox.
Now that you have tweaked your options to show the Developer tab you should see this tab appear near the end of you Ribbon tab. Check out the images below to see which features are added to your Office Ribbon when you active the Developer tab in each respective program.
Excel Developer Tab
PowerPoint Developer Tab
Word Developer Tab
Share This Post!
Did you find this post helpful? Do you want to support this blog because you're just that awesome?! By sharing this post on Facebook, Twitter, or Google+ you are not only providing others with great information, you are creating exposure for The Spreadsheet Guru. Growing this community is my number one goal as I have found learning to increase exponentially when lots of people are contributing to the conversation. Learning is the whole reason why this blog exists! If you want to spread the word just click on the Share button right below this paragraph (next to the Like button -- I enjoy "likes" too!) and select your preferred social medium. Thank you so much for reading and I hope I can continue to provide you with great content in the future! Cheers!