For example, you would need to click the Office button instead of the File tab to get to the Excel Options menu. In older versions of Excel it could be different. Excel tips for other newer versions like Excel 2013, Excel 2016, or Excel for Office 365 all follow the same steps. Most other versions of Microsoft Excel will provide access to the Developer option as well. It will only be removed if you uninstall excel or go back to the Options menu and uncheck the box. Once you show the Developer tab on the ribbon it will remain there even when you close and open Excel. it also provides access to advanced features like the VB editor, lets you insert controls such as form controls, and even enables things like XML commands and or allows you to manage XML maps. 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 find developer tab in excel 2010