Show Developer Ribbon in Excel – Quick Tip

Show Developer Ribbon in Excel

The purpose of this lesson is to teach you how to show developer ribbon in Excel. When you start Excel for the first time, you may not see the developer tab.

Although we emphasize Excel in this instruction, the steps here should work in any Office program that has a ribbon. For the purpose of this lesson, we used Excel 2010.


The developer tab has very useful tools to help you go beyond the normal functions you use in Excel. You can use it for automation and to improve the user experience.

With this ribbon, you can create code and automate data. Moreover, you get to customize the sheet and work with data from web sources. If you enjoy programming, this ribbon is important to your projects.

Steps to Show Developer Ribbon

Follow the steps below to show the developer ribbon.

Step 1: Display Excel Options
File menu to open options dialog box.
Open Excel options dialog box.
  1. Click File from the menu bar.
  2. Under the File list, select Options.

The Excel Options dialog box opens.

Step 2: Display Developer Ribbon from Excel Options
Excel options dialog box to display ribbon.
Excel options dialog box.
  1. Click Customize Ribbon from the left menu pane.
  2. Under Customize Ribbon on the right, select Main Tabs.
  3. Check Developer under the Main Tabs list.
  4. Click OK.


Developer ribbon in Excel.
Developer ribbon in Excel.

There you go! You should now see the developer ribbon in Excel.

Quick Shortcut

Shortcut menu to customize the ribbon.
Shortcut menu to customize the ribbon.

Instead of going through the file menu to get to Excel options, you can right-click on any of the items on the menu and click Customize the ribbon…

Additional Notes on Developer Ribbon

Questions and Comments

If you have any questions or comments, email us at

External Links

Show the Developer tab

Techronology Home