The Microsoft Corporation Developer tab lets you do more than just run macros or create new macros. Some of the options that you will find in the left pane of the Excel Options window where you select Customize Ribbon include: You could also remove default ribbon tabs like the View tab or the Layout tab, if you were so inclined.

For example, a lot of other applications that you install, such as other document creation or accounting applications may customize the ribbon by adding their own tabs among the existing tabs. The Customize Ribbon option in the Excel Options dialog box lets you add or remove the Developer option, but it also lets you remove other tabs from the ribbon interface that you might not be using. If you wish to enable the Developer tab in those applications then you will need to follow these steps there as well. However, this will not affect other Microsoft Office applications that you have also installed, such as Microsoft Word or Microsoft Powerpoint. Once you have added the Developer tab in Excel 2010 using the steps above then it will remain accessible for each future file that you open on this computer. More Information on How to Show Developer Tab – Excel 2010 If you want to add any other tabs or remove any other tabs, then you can feel free to customize this menu as you see fit. That menu in Excel Options will only show the tabs and options with a check mark next to them. If you go to File > Options > Customize Ribbon you simply need to click the box to the left of the Developer tab to remove it, then click OK. Luckily removing that tab is a very similar process to how we added it above. If you are working with an Excel installation that has a Developer tab, but you don’t want it, then you may be wondering how to remove it. How to Remove the Developer Tab in Excel 2010

This new tab provides you access to many new options and tools that will expand the functionality of your Excel installation.

How to show developer tab in excel