How to show the Developer Tab on the Ribbon

When you’re planning to work with VBA macros, you’ve to make sure that the Developer tab is present on the Excel Ribbon. The Developer tab does not appear by default. Developer tab contains useful commands for VBA users. The following figure shows the developer tab on the Excel Ribbon.

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide.

How to show the Developer Tab on the Ribbon

The Developer tab.

To display this tab, follow these steps:

    1. Right-click any Ribbon control and select Customize the Ribbon from the shortcut menu. Customize the Ribbon tab of the Excel Options dialog box appears.
How to show the Developer Tab on the Ribbon

Select Customize the Ribbon… from the shortcut menu.

  1. In the list box on the right, place a checkmark next to Developer.
  2. Click OK to return to Excel.
How to show the Developer Tab on the Ribbon

Place a check mark next to Developer.

Happy Excelling 🙂

Read More…

Types of commands on the Ribbon


Hello! Welcome to my Excel blog! I am conducting deep dives into the world of Excel. Please join with me and explore Excel deeply. Keep in mind this African proverb: "If you want to go fast, go alone, If you want to go far, go together." Let's together explore Excel deeply! ☕

We will be happy to hear your thoughts

      Leave a reply