The developer ribbon is a key component for developing code and macros, and add-ins for Microsoft Excel and other applications. It also allows you to insert form controls, and work with data outside of Excel. This Small Shot shows you how to display the developer ribbon, which may not appear by default, in Microsoft Excel 2007 or higher.
- Click File from the menu
- Select Options from the file options list
The Excel Options dialog box appears, as shown below…
- Select Customize Ribbon from Excel Options
- Check Developer under Main Tabs
- Click OK
There you have it! The Developer ribbon is now a part of the Microsoft Excel menu.
If you have a right button on your mouse, right-click on any menu item at the top of the screen, and select Customize the Ribbon… from the shortcut menu.