How to Add the Developer Tab in Excel (Windows & Mac)

The Developer tab in Excel is hidden by default — not because Microsoft wants to keep it secret, but because most casual users never need it. Once you know it exists and how to enable it, you unlock a layer of Excel that lets you build macros, create form controls, manage add-ins, and work directly with XML data. Whether you're automating repetitive tasks or building interactive spreadsheets, the Developer tab is where that work begins.

What Is the Developer Tab?

The Developer tab is a ribbon tab in Microsoft Excel that surfaces tools not included in the standard interface. These include:

• Macros — record, run, and manage automated sequences of actions
• Visual Basic for Applications (VBA) — Excel's built-in programming environment
• Form controls — buttons, checkboxes, dropdowns, and scroll bars you can embed in sheets
• ActiveX controls — more advanced interactive elements with deeper customization
• Add-ins — third-party or custom extensions that extend Excel's functionality
• XML tools — import, export, and map XML data directly in a spreadsheet

None of these appear unless the tab is enabled. Excel ships with it turned off to keep the ribbon clean for users who don't need them.

How to Enable the Developer Tab on Windows 🖥️

The process takes under a minute.

1. Open Excel and click File in the top-left corner
2. Select Options near the bottom of the left menu
3. In the Excel Options dialog, click Customize Ribbon in the left panel
4. On the right side, you'll see a list of Main Tabs with checkboxes
5. Scroll down and check the box next to Developer
6. Click OK

The Developer tab now appears between the View tab and any add-in tabs in your ribbon. It persists across sessions — you won't need to re-enable it every time you open Excel.

Alternative Method: Right-Click the Ribbon

You can also right-click anywhere on the Excel ribbon and select Customize the Ribbon. This opens the same Excel Options panel directly at the Customize Ribbon section, skipping a couple of steps.

How to Enable the Developer Tab on Mac 🍎

The Mac version of Excel follows a slightly different path:

1. Open Excel
2. Click Excel in the top menu bar (not the ribbon)
3. Select Preferences
4. Click Ribbon & Toolbar
5. Under the Customize the Ribbon section, look for the Main Tabs list
6. Check the box next to Developer
7. Click Save

The tab appears immediately in your ribbon.

Mac vs. Windows: Key Differences to Know

ActiveX controls are a Windows-only feature. If you're building spreadsheets that rely on ActiveX components and need to share them with Mac users, those elements won't function on the Mac side. Form controls, by contrast, work across both platforms.

What Excel Version Do You Have?

The steps above apply to Excel 2016, 2019, 2021, and Microsoft 365 on both platforms. Older versions like Excel 2010 and 2013 follow nearly identical steps on Windows — the Customize Ribbon option has been in Excel since 2010.

Excel for the web (Office Online) does not support the Developer tab. It's a browser-based version of Excel with a reduced feature set, and VBA macros don't run in that environment at all. If the Developer tab option doesn't appear in your settings, you're likely using the web version rather than the desktop application.

Common Issues After Enabling the Tab

The tab isn't showing up after I checked the box This occasionally happens if Excel needs to be restarted. Close and reopen the application.

I can see the tab but macro options are greyed out Your organization's IT policy may have macro execution disabled at the administrative level. This is common on corporate-managed devices. Even with the Developer tab visible, macro security settings — found under Developer > Macro Security — control what runs and what doesn't.

The VBA editor opens but I get a "macros disabled" warning Excel's Trust Center settings govern macro behavior. Go to File > Options > Trust Center > Trust Center Settings > Macro Settings to review what's allowed. The four levels range from disabling all macros to enabling all of them, with options in between based on digital signatures.

What You Can Actually Do Once It's Enabled

Enabling the tab is just the door. What's useful behind it depends heavily on your workflow:

• Recording macros requires no coding knowledge — you hit record, perform actions, stop recording, and Excel writes the VBA for you
• Editing macros in VBA requires at least basic familiarity with programming logic
• Form controls like checkboxes and dropdowns can be added to any worksheet without any code at all
• Add-in management matters most if you work with third-party tools like data analysis packs or industry-specific plugins

The technical skill floor varies significantly across these features. Someone who only needs a checkbox on a budget tracker has a very different experience than someone building a multi-sheet automated reporting tool with custom VBA functions.

How useful the Developer tab becomes — and which parts of it you'll actually use — depends on what you're trying to build, how comfortable you are with Excel's deeper mechanics, and whether you're working solo or within a system that restricts macro execution by policy.