Table of contents
- Things you need to know about Developer tab in Excel
- Add the developer tab to the ribbon in Excel 2016
- Other versions of Excel
- Developer tab in Excel with shortcut
*Click images to enlarge
Things you need to know about Developer tab in Excel
By default all the Microsoft Office products don’t show the developer tab that’s because this tab is like its name a little bit advanced, means only for Developer but in this tutorial, we are going to display it once for a time and you can use it whenever you want.
Also, there is no shortcut to display the Developer tab in Excel, there is one only method to do that let’s explain it together.
Add the developer tab to the ribbon in Excel 2016
- The Ribbon
It’s simply the third top bar in Excel (under the menu bar)
- Customize the Ribbon: by choosing an empty area in the Ribbon and click left button
- Add the developer tab to the ribbon: A window of Excel Options will appear and you just need to check the Developer checkbox and click the “OK” button.
- The Developer tab in Excel
Other versions of Excel
To get the Developer tab in Excel 2013 or 2010 use the same points as Excel 2016.
For Excel 2007 :
- Click the Office Button in left top of Excel
- Click the Excel Option button at the bottom, and Excel option window will appear
- Click the Popular menu at the left
- In the section “Top Option for Working with Excel”, check or enable the Show Developer tab in the Ribbon option
- Click Ok button to save
Unfortunately for the Excel 2003 there is no Developer tab :p but there is the menu “Tools” that contains the same element as the Developer tab in the other version.
Developer tab in Excel with shortcut
Follow those quick steps to add the developer tab in Excel for Windows and Mac systems with only using the keyboard.
Now you know how to add a Developer tab in Excel and use it like a pro :).
If you like this tutorial please like and share :).