How to Unlock the Hidden Developer Tab in Excel
Pinterest Stumbleupon Whatsapp

By default, Excel’s Developer tab is hidden away in the program’s settings, but turning it on is just a few clicks away. The series of tools may be daunting at first, but grasping the way they work can save you a lot of time in the long run.

To get the Developer tab to show up in Excel:

  • Go to File > Options.
  • Open the Customize Ribbon tab.
  • On the right under Main Tabs, make sure that Developer is checked.
  • Click OK.

How to Unlock the Hidden Developer Tab in Excel Excel Developer1

You should now see the Developer tab in your Excel menus.

How to Unlock the Hidden Developer Tab in Excel Excel Developer2 e1498496763327

So what do you need the Developer tab for? The Developer tab is home to macros that you can use to automate repetitive tasks like sending emails from an Excel spreadsheet or automatically inserting text strings. Using the Developer tools will require a little bit of coding knowledge.

And it’s not all serious work too. You can use these features for some pretty fun and unexpected things like creating a Sudoku came right there in Excel.

Do you use Excel’s Developer tools? If so, what do you use them for? Let us know in the comments.

Enjoyed this article? Stay informed by joining our newsletter!

Enter your Email

Leave a Reply

Your email address will not be published. Required fields are marked *

  1. Ron
    July 13, 2017 at 2:42 pm

    Great read. I especially like the note on "Developer tab in your Excel menus." Priceless tips. Thank you