How to show the Developer Tab in Excel

//

Brian Krisanski

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, show the Developer Tab in Excel 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.

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