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