Add Developer Tab [Windows + Mac]

Developer tab in excel is one of the most important and highly useful options in excel. But, before you use it you need add it on ribbon.

When you install Excel, you need to activate it for first time.

So today in this post, you will learn 3 different methods to add developer tab in Excel for windows as well as in Excel 2011 for mac.

To enable it follow these simple steps.

• Go to File Tab → Options → Customize Ribbon.
• In the main tab list, tick mark check box for the developer.

• Click OK.

Here is another method to display developer tab.

• Right click on Excel ribbon and select customize ribbon.

• In main tab list, tick mark check box for the developer.
• Click OK.

After following any of the above methods you can activate developer tab in Excel for Windows.

Here are the steps to add developer tab in Excel 2011 for Mac.

• Go to Excel Menu → Preferences.

• Click on Ribbon in "Sharing & Privacy Group" and then Click OK.

• Now, you will get a pop-up dialog box. In customization section, select Developer Tab & click OK.

After following any of the above methods you can activate developer tab in Excel 2011 for Mac.

What's Next

Try these 101 useful VBA examples.