Microsoft Excel has great features to allow Users to easily work with the Work Sheets. And some of the features are allowed you to write programming; for example, macros. Some of these features can be enabled or disabled through Microsoft Excel Options. 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 the Options may not be displayed by default. Users need to enable/disable the options they want to use to deal with their data in the Work Sheets.
One such option is to allow the User to write Programming; add event handlers to Controls in the WorkSheet etc. These can be handled through the Developer tab; a tab that displays the Controls which are helpful in writing macros/programs.
In this article, we will see the Steps to display the Developer tab in Microsoft Excel 2013.
Step 1. Open Microsoft Excel 2013.
Step 2. Click on the File tab. And then click on the Options tab. Microsoft Excel 2013 displays the “Excel Options” dialog.
Step 3. Click on the “Customize Ribbon” option on the left side, to allow you to Customize the controls which are displayed on the Ribbon.
Step 4. From the “Customize the Ribbon:” combo box, select the “Main Tabs” options. Microsoft Excel will display the Main Tabs, under the Main Tabs list.
Step 5. Check the Developer tab from the list of Main Tabs and click on the OK button.
Step 6. Now you will see the Developer tab is visible on the Ribbon control.
🙂 Sahida