How To Display The Developer Tab In Excel

Table of Contents[Show]
How To Display The Developer Tab In Excel


Excel Developer Tab - In a previous tutorial about the Excel User Interface, I said that by default the Developer Tab or Excel Developer Tab is not displayed. I think this is because the Developer Tab is not intended for beginner Excel users. The menus in this tab are intended for advanced users.

The things we can do with the Developer tab in the Microsoft Office EXCEL program include:

  1. Write excel macros .
  2. Runs the macro and record.
  3. Using XML commands.
  4. Use ActiveX controls .
  5. Create applications for use with Microsoft Office programs.
  6. Use form controls in Microsoft Excel.
  7. And others.

How to activate the developer tab is actually relatively very easy. If we really need the Developer tab for the things that I mentioned above, then please follow the tutorial on how to display or bring up the developer tab below:

1) How to Show Developer Tab in Excel 2007

To activate or display the Developer Tab in Microsoft Excel 2007, the steps taken are as follows:

1) Open Microsoft Excel 2007 Application.

2) Click Microsoft Office Button in the upper left corner of the worksheet.

3) Then choose Excel Options.

4) After the Excel Options dialog box appears, select the section Popular  and then check the options Show Developer tab in the Ribbon.

Microsoft Excel 2007 Developer tab


5) Then click OK to save the settings.

How to activate excel tab developer above does not apply to excel version 2010 and above. Then for Excel 2010, Excel 2013 and Excel 2016, how do you do it?

How to bring up the Developer tab in Excel 2010, 2013 and 2016

Since the Excel 2010 version, Microsoft Excel has made major changes to the Excel user interface. So that more or less also affects how to display the developer tab which is not active by default.

Broadly speaking, the way to display the Developer Tab in Microsoft Excel 2010, Excel 2013 and Excel 2016 is actually the same, namely by opening the Excel option in the Customize Ribbon category .

For details please follow the instructions below.

Screen shot How to display the TAB or the developer menu I took from Microsoft Excel 2013. For the Excel 2010 or Excel 2016 version, the steps to display it are more or less the same.

First step

The steps for displaying the developer tab in Excel are as follows:

1) Run the Microsoft Office Excel program.

2) Right click on any part of the Ribbon and select it Customize the Ribbon.

How to activate the Developer tab in Microsoft Excel

3) In the dialog box that appears, pay attention to the right. If necessary, make sure it is Main Tabs Active.

4) Check the section Developer check box.

How to activate the Developer tab in Microsoft Excel

Second Way

Apart from the first way, you can also activate the Developer TAB in Excel in the following ways:

1) Open the Microsoft Office Excel Program

2) Select Menu File

3) select Options

How to activate the Developer tab in Microsoft Excel

 

4) After that the Excel Options dialog box will appear . Choose Customize Ribbon.

5) If the Customize Ribbon section doesn't display the Developer options yet, pay attention to the section Choose commands from and select it Main Tabs.

6) Click the Developer section then click add.

7) If the Customize Ribbon section already displays Developer options. skip steps 5 and 6, just check the developer options section.

How to activate the Developer tab in Microsoft Excel

 

8) Click OK. done.

Those are the steps on how to display or activate the Excel Developer Tab that I can write.

Before going, don't forget to Bookmark and share this excel tutorial article with the buttons provided below. Hopefully useful and greetings Excel Class.

Leave a Comment