WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android


Add Developer Tab in Excel (Step-by-Step)

July 22, 2022

Add developer tab in Excel is a quick process that will give you access to essential features to complete your work. Additionally, you can use the Developer tab to insert a checkbox, spin button, scroll bar, and other controls.

Among the advanced features it offers are:

Add-ins: You can manage your Excel add-ins and COM add-ins.

Macros: You will have the opportunity to write new macros with the “Visual Basic” editor, and you will be able to execute macros that you have previously recorded or written.

XML: You can use XML commands, manage XML maps, import XML data files, and more.

Controls: You can insert forms and ActiveX controls in your spreadsheets.

How to activate or add developer tab in Excel?

Activating or add developer tab in excel online will allow you to export and import XML files, insert Controls or create a macro. To add it, you will need to perform the following steps:

1. Right-click on the ribbon, and click “Customize Ribbon.”

2. When you are in “customize the ribbon,” on the right side of the dialog, you will need to select “main tabs.” (Only if it is necessary). Then check the “developer” checkbox.

3. To continue, click “OK.” You can find the “Developer” tab next to the “View” tab.

How to add developer tab in Excel 2016 for Mac?

If you want to know the steps to add developer tab in excel mac, you are in the right place. Follow these steps:

1. Open Excel on your Mac computer and click on the “Excel” tab at the top of the screen; then, you must choose the “Preferences” option.

2. To continue, you must select the “Ribbon and Toolbar” option.

3. You will need to check the box to the left of “Developer” in the right column and click the “Save” button in the bottom right corner of the window.

WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
Algirdas Jasaitis

How to add developer tab in Excel 2016 for Windows?

To display and add developer tab in excel 2016, you will need to perform these simple steps:

1. Click on the “File” menu and then select “Options” from the menu on the left. It may be the last option on the list; you must scroll down to see it.

2. When the “Excel Options” window appears, you need to click on the “Customize Ribbon” option on the left. Then click the “Developer” checkbox below the list of primary tabs on the right. To continue, you will need to click the “OK” button.

3. Now, you can see the “developer” tab in the toolbar at the top of the screen. All option groups on the Developer tab should be available: Controls, Codes, XML, Modify, and Plugins.

With these simple steps, you can add developer tab in excel 2019 correctly to improve your spreadsheet.

FAQs about Developer Tab in Excel 

1.Which version of Excel has Developer Tab?

The Developer tab is available in Excel versions such as Excel 2019, Excel 2016, Excel 2013, and Excel 2010.

2.What is the Developer Tab in Excel, and why is it important?

The Developer tab in Excel provides access to advanced features and functionalities for customization and automation. It allows users to automate tasks, create macros, use controls, work with add-ins, and handle XML data. It is important for users who want to enhance productivity, perform advanced data analysis, and customize Excel to their specific needs.

3.What can I do with the Developer tab Excel?

With the Developer tab in Excel, you can automate tasks using macros, create custom applications with Visual Basic for Applications (VBA), utilize controls for interactive interfaces, extend Excel's functionality with add-ins, and work with XML data. It opens up a wide range of possibilities for customization, automation, and advanced data manipulation within Excel.


In this comprehensive guide, we explored the process of adding the Developer tab in Excel. We discussed its significance in unlocking advanced features and functions that enhance customization and automation capabilities. Additionally, we highlighted the benefits of using WPS Office, a powerful office suite that offers a range of productivity-enhancing features. With the Developer tab and WPS Office, you can take your Excel experience to new heights of efficiency and effectiveness.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.