Now you will see the Developer tab is visible on the Ribbon control. Click Popular, and then select the Show Developer tab in the Ribbon. Click the Microsoft Office Button Button image, and then click Excel Options. Check the Developer tab from the list of Main Tabs and click on the OK button. You should display the Developer tab or run in developer mode when you want to write macros, run macros that you previously recorded, or create applications to use with Microsoft Office programs. Microsoft Excel will display the Main Tabs, under the Main Tabs list. From the “Customize the Ribbon:” combo box, select the “ Main Tabs” options. Click on the “ Customize Ribbon” option on the left side, to allow to Customize the controls which are displayed on the Ribbon. Microsoft Excel 2013 – Excel Options dialog Microsoft Excel 2013 displays the “Excel Options” dialog. In this article, we will see the Steps to display the Developer tab in Microsoft Excel 2013. These can be handled through the Developer tab a tab that displays the Controls which are helpful in writing macros/programs.

One such Option is to allow the User to write Programming add event handlers to Controls in the WorkSheet etc. Users need to enable/disable the Options whichever they want to use to deal with their data in the Work Sheets. Some of the Options may not be displayed by default. Once the options are enabled, Microsoft Excel will display the Controls / Icons (on the Ribbon control which is a toggle with the Menu) to allow the Users to access the features. Some of these features can be enabled or disabled through Microsoft Excel Options. On the File tab, go to Options > Customize Ribbon. The Developer tab isnt displayed by default, but you can add it to the ribbon. Developer Tab would appear in the Excel file. Show the Developer tab Excel for Microsoft 365 Outlook for Microsoft 365 More. After clicking on Options, select Customize Ribbon from left Select Main Tabs on the right then check on the Developer checkbox and click on the OK button. And some of the features are allowed to write programming for example, macros. Open a new excel sheet and navigate to file. Microsoft Excel has great features to allow the Users to easily work with the Work Sheets.

Display developer tab in excel