How to Add the Developer Tab in the Ribbon

The Developer Tab is mainly used for working with Macros. Using the Developer tab, you can create, run and edit Macros. In addition to this, the developer Tab can also be used for working with XML sheets and From Controls. By default, the Developer tab will not be shown in the Ribbon of any Office application and this becomes difficult when you want to work with Macros and Xml Sheets without the developer tab. below is a tutorial that will tell you how to add the Developer tab into the Ribbon of the Excel 2010 Application.

NOTE: - the procedure for adding the Developer Tab into the Ribbon of every Office Application such as MS Outlook, MS PowerPoint and MS Word remains the same. In our illustration we are using the MS Excel 2010 Application.

1) Click on ‘File’ tab and then on ‘Options’ tab.

Figure 1

2) In “Excel Options” window that appears on the screen, click on the ‘Customize Ribbon’ tab.

Figure 2

3) Now, under ‘Customize the Ribbon’ box, use the drop down arrow to find the ‘Main Tabs’ and under the Main Tabs, select the check box that is against the ‘Developer’ option.

Figure 3

4) Finally click on the ‘OK’ button in Excel Options window.

So, this is how you can make the Excel application show the Developer tab in the Ribbon.

Read Other Applications