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
- Click File from the menu bar.
- Under the File list, select Options.
The Excel Options dialog box opens.
Step 2: Display Developer Ribbon from Excel Options
- Click Customize Ribbon from the left menu pane.
- Under Customize Ribbon on the right, select Main Tabs.
- Check Developer under the Main Tabs list.
- Click OK.
There you go! You should now see the developer ribbon in Excel.
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 firstname.lastname@example.org.