totn Excel

MS Excel 2013: Display the Developer tab in the toolbar

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

Question: In Microsoft Excel 2013, 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 File menu and then select Options from the drop down menu.

Microsoft Excel

When the Excel Options window appears, click on the Customize Ribbon option on the left. Click on the Developer checkbox under the list of Main Tabs on the right. 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 - Code, Add-Ins, Controls, XML, and Modify (see below).

Microsoft Excel