In this article, we explain how to add or show a developer tab to a ribbon menu in Excel. Find out, the steps in here’s.
Adding the Developer tab in Microsoft Excel gives you access to advanced Excel features. Below are the steps to add or show a developer tab to a ribbon menu in Excel.
How to add or show a developer tab to a ribbon menu in Excel
The Developer tab is not enabled by default in Microsoft Excel, which makes many of the Intermediate and Advanced Excel features hidden from users.
However, it’s really easy to add the Developer tab to the ribbon menu and access Excel add-ins, ActiveX controls, Visual Basic commands, macros, forms, interactive tools, and various other features.
Show the developer tab in the Excel ribbon menu
The fastest way to reveal the Developer tab in Microsoft Excel is to right-click on a blank space in the ribbon menu and select Customize the Ribbon….

On the next screen, check the small box next to Developer and click OK.

If that doesn’t work, you can try any of the following methods, depending on the version of Microsoft Excel installed on your computer.
- Excel 2010 and later: click File> Options> Customize Ribbon> check Developer and click OK.
- Excel 2007 and earlier: Click the Microsoft Office Button> Excel Options> Popular> Show Developer Tab in Ribbon.
- Excel on a Mac: Click Customize Toolbar Down Arrow and select More Commands. On the More Commands screen, click the Ribbon tab and select Developer.
That’s how to add or show a developer tab to a ribbon menu in Excel. Visit our site Suntamah.com for the latest technology articles.