how to display developer tab in excel 2010

Now the Developer tab is displaying in the Ribbon. See screenshot:Ģ Then in the popping Excel Options dialog, click Popular in the left pane, then go to Top options for working with Excel section, and check Show Developer tab in the Ribbon option. In Excel 2007, you also can check an option in the Excel Options dialog to show the Developer tab in the Ribbon.ġ. Now you can see the Developer tab has shown in the Ribbon. And go right to the Customize the Ribbon section, and check Developer option in the Main Tabs list. In the popped out Excel Options dialog, click Customize Ribbon in left pane. Click File > Options to open the Excel Options dialog. To show the Developer tab in Excel 2010 and later versions, please do as follow steps:ġ. Show Developer tab in Ribbon in Excel 2010 and later versions Show Developer tab in Ribbon in Excel 2007 Show Developer tab in Ribbon in Excel 2010 and later versions Now I will tell you how to show or display the Developer tab in Excel Ribbon. In Excel, the Developer tab is hidden on the Ribbon in default, but if you usually do some special operations in Excel, such as insert controls, record macros and so on, showing the Developer tab on the Ribbon can greatly improve your work efficiency. Step 2: Click the File tab at the top-left corner of the window.How to show/display developer tab in Excel Ribbon? Once you have customized the ribbon to display the Developer tab, it will remain there for any other files that you open in Excel 2013. For example, this article will show you how to enable the Developer tab in Excel 2010. However, the steps are similar in other versions of Microsoft Excel as well. The steps in this article were written for Microsoft Excel 2013. How to Show the Developer Tab in Excel 2013 Fortunately this can be accomplished in just a few short steps by following our tutorial in the article below.

This tab contains some useful tools, such as Macros, so many people will eventually need to enable it. For example, you could use an option on the Formulas tab to add a concatenate formula to your spreadsheet.īut there are tabs in Excel 2013 that are not included in the navigational ribbon by default, and the Developer tab is one of them. Different settings and features are organized under appropriate tabs, allowing you to find the setting that you need to change. The navigational system in Microsoft Excel 2013 is based around a ribbon of tools and options at the top of the window.

How to display developer tab in excel 2010