How to show the Developer Tab in Excel 6

How to show the Developer Tab in Excel


image-Developer Tab


By default, the Developer Tab is not displayed as a menu option in Excel when you first open it up. You can, however, add it by following the few steps below.

Adding the Developer Tab to your Ribbon menu allows you to:

  • Write macros and VBA (Visual Basic for Applications) code.
  • Run macros that you previously recorded.
  • Use XML commands.
  • Use ActiveX controls.
  • Create applications to use with Microsoft Office programs.
  • Use form controls in Microsoft Excel.


By default, the Developer Tab is not displayed as a menu option in Excel. You can add it in a… Click To Tweet


How to show the Developer tab

Step 1 Click the File tab and then click Options
image-Developer Tab Options Menu
Step 2 Click Customize Ribbon.
Step 3 Under Customize the Ribbon and under Main Tabs, select the Developer check box and then click OK.
image-Developer Tab Customise Ribbon


The Developer Tab will now show in the Ribbon Menu for you and will continue to show in Excel until you either reverse the instructions below or you reinstall Excel on your computer.

image-Display the Developer Tab



Please Share

If you liked this article or know someone who could benefit from this information, please feel free to share it with your friends and colleagues and spread the word on Facebook, Twitter or Linkedin.



  • Pingback: How to make a cell flash in Excel and why I wouldn't do it!()

  • Great tip. Now what type of macros might I want to write or run as a small business owner?

    • Thanks Ursula,
      Stay tuned as we’ll be covering this exact topic in some upcoming posts. But to give you a hint… You don’t need to know VBA (Visual Basic for Applications) in order to use macros in your business. Once you have the Developer tab showing, you can “record” yourself undertaking a repetitive task you do on a daily/weekly basis and then “play/re-run” the recording the next time you need to do it to have Excel repeat the process for you.

  • I love your simple step-by-step posts! They’re so clear and easy to understand and implement. Have a great weekend!

    • Thanks Monica. Hope you enjoy your weekend as well.

  • Thanks Monica. Enjoy your weekend as well.