How to Display the Developer Tab in Excel

Features of Developer Tab

The Developer tab provides access to advanced features and unique functions in Excel. Here are some of its key features:

  • Visual Basic: Launches the VBA editor, allowing you to input code (Keyboard shortcut: ALT + F11).
  • Macros: Record new macros and access a list of available macros (Keyboard shortcut: ALT + F8).
  • Add-ins: Insert Excel Add-ins and COM Add-ins.
  • Controls: Modify control properties, view code, and run dialogs.
  • XML: Includes XML source tasks for mapping properties and importing XML data files.

How to Display the Developer Tab

To enable the Developer tab, follow these two simple steps:

Step 1 – Open Excel Options and Navigate to Customize Ribbon

  • Click the File tab in Excel.

Utilizing the File Tab to display the developer tab

  • Choose Options (see screenshot below).

Opening Excel option

  • In the Excel Options dialog, select Customize Ribbon.

Step 2 – Select Developer Tab

  • Under Customize Ribbon, check the Developer box.
  • Click OK.

Format the Customize Ribbon Option to display the developer tab

The Developer tab will now appear in the ribbon bar, allowing you to work with VBA and macros.

Read More: How to Add Custom Ribbon Using XML in Excel

Alternatives to Opening Excel Options

1. Using Keyboard Shortcut

  • Press ALT + F + T to open the Excel Options dialog.

Using Keyboard Shortcut to open Excel option for displaying the developer tab

  • Choose Customize Ribbon from the options.

2. Right-Clicking on the Ribbon

  • Right-click any ribbon option.
  • Select Customize the Ribbon.

Right Click to Customize the Ribbon 

The Customize Ribbon option will be available in the Excel Options.

Customize ribbon

Read More: How to Use Excel VBA to Customize Ribbon

Download Practice Workbook

You can download the practice workbook from here:

Related Articles

Get FREE Advanced Excel Exercises with Solutions!
Kawser Ahmed
Kawser Ahmed

Kawser Ahmed is a Microsoft Excel Expert, Udemy Course Instructor, Data Analyst, Finance professional, and Chief Editor of ExcelDemy. He is the founder and CEO of SOFTEKO (a software and content marketing company). He has a B.Sc in Electrical and Electronics Engineering. As a Udemy instructor, he offers 8 acclaimed Excel courses, one selected for Udemy Business. A devoted MS Excel enthusiast, Kawser has contributed over 200 articles and reviewed thousands more. His expertise extends to Data Analysis,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF