Joshua earned an MBA from USF and he writes mostly about software and technology.
Developer Tab Uses
The above 'Developer' tab shown in the screenshot above is not visible unless you activate it from the options menu. Adding this tab will open the doors to adding and managing Excel add-ins, changing certain worksheet properties, inserting both form and ActiveX controls, allowing access to visual basic and macro tools, and more.
More than likely, you are here because you are a somewhat advanced Excel user and you are ready to take the next step to learn developer skills. Otherwise, you are just curious to see what is behind that door. Either way, the instructions below will make the tab visible.
Steps to Making the Developer Tab Visible
First, click on the file button in the top left-hand corner of the screen and then click on the “Options” button in the bottom left-hand corner of the screen.
Next, after the 'Excel Options' window appears, click on the 'Customize Ribbon' button located in the list of options on the left side of the Excel Options window.
Lastly, find the 'Developer' option under 'Main Tabs' and click the check box beside it. Click on the 'OK' button at the bottom right-hand corner of the Excel Options window and you are done.
Check Developer Box
Now the Developer tab is visible under your main menu options.
Please see the video below for more help on adding the developer tab to Microsoft Excel.
Crowder, J. (2020, January 1). How to Add the Developer Tab in Excel. Retrieved January 1, 2020, from https://youtu.be/nskuG6pK5ig.
- How to Create a Button in Microsoft Excel That Opens a Calculator
Shows a Microsoft Excel user how to create a button that opens up the Windows pre-installed calculator application from an Excel spreadsheet.
- Create a Macro Button That Will Clear All of Your Work Within an Excel Worksheet
Shows a Microsoft Excel user how create a button and record a macro that will clear a workbook when the button is clicked.
- Create a Macro Button in MS Excel 2016 to Filter Data
The article will show you how to create a set of buttons allowing you to filter a table within a spreadsheet and revert to your original view quickly. A document template for the task will be provided.
- How to Create a Macro Button to Save & Close an Excel Workbook
The article describes how to create a macro button on an Excel spreadsheet that will save and close a workbook to avoid having to select both operations.
To learn more about developing in Excel, I recommend taking a look at the book Microsoft Excel 2019 VBA and Macros (Business Skills) by Bill Jelen to enhance your skills.
This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.
© 2018 Joshua Crowder