totn Excel

MS Excel 2011 for Mac: Display the Developer tab in the toolbar

This Excel tutorial explains how to display the developer tab in the toolbar in Excel 2011 for Mac (with screenshots and step-by-step instructions).

Question: In Microsoft Excel 2011 for Mac, how do I get the Developer tab to display in the toolbar at the top of the screen?

The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form/ActiveX Controls like buttons, checkboxes, etc.

Answer: To display the Developer tab, click on the Preferences under the Excel menu at the top of the screen.

Microsoft Excel

When the Excel Preferences window appears, click on the Ribbon icon in the Sharing and Privacy section.

Microsoft Excel

In the Customize section, check Developer in the list of tabs to show. Then click on the OK button.

Microsoft Excel

Now you should see the Developer tab in the toolbar at the top of the screen. All of the Developer tab option groups should be available - Visual Basic, Add-Ins, and Form Controls (see below).

Microsoft Excel