How to Add the Developer Tab in MS Excel 2016

Updated on January 12, 2018

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, 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 become visible.

Steps to Making the Developer Tab Visable

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 in 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.

Now the Developer tab is visible under your main menu options.

Recommended Book

I recommend the Excel 2016 Bible if you are a beginner or medium level user. This book has comprehensive tutorials and serves as an excellent reference book for your book shelf. The table of contents is quite large, so it almost makes sense to get the ebook. The rating on this book is usually at least 4 out of 5 stars.

© 2018 Joshua Crowder


    0 of 8192 characters used
    Post Comment

    No comments yet.