How to Enable the Developer Tab in Excel

How to enable the Developer tab in Excel

To enable the Developer tab in Excel on Windows, go to File > Options > Customize Ribbon, tick Developer under Main Tabs, and click OK. On Mac, the same setting lives under Excel > Preferences > Ribbon & Toolbar.

Worth knowing before you start: if you only want to run a macro someone sent you, you do not need this tab at all. More on that below.

TL;DR: Key takeaways

• Windows: File > Options > Customize Ribbon, tick Developer, click OK.
• Mac: Excel > Preferences > Ribbon & Toolbar, tick Developer, click Save.
• The setting sticks. It applies to Excel itself, not to one workbook.
• Alt + F8 runs a macro and Alt + F11 opens the code editor, both without the tab.
• Excel for the web has no Developer tab, because it cannot run VBA at all.

Enable it on Windows

1. Click the File tab.
2. Choose Options, then Customize Ribbon.
3. In the right-hand list under Main Tabs, tick the Developer check box.
4. Click OK.

Developer now appears on the ribbon, usually to the right of View.

Enable it on Mac

1. Open the Excel menu and choose Preferences.
2. Click Ribbon & Toolbar.
3. Under Customize the Ribbon, select Main Tabs and tick Developer.
4. Click Save, then close Preferences.

The wording differs from Windows, and the setting is saved rather than confirmed with OK, but the result is identical.

You may not need the tab at all

Most people enabling the Developer tab are trying to do one of two things, and neither requires it.

Running a macro. Press Alt + F8 on Windows or Option + F8 on Mac. That opens the same Macros dialog the tab's Macros button opens. If you downloaded a macro and just want it to work, this is the whole job. See running a macro you downloaded.

Looking at the code. Press Alt + F11 to open the Visual Basic Editor directly.

The tab is a shortcut to commands that already have keyboard shortcuts. It becomes genuinely useful when you record macros often, or when you need the parts of it that have no shortcut, such as form controls or macro security settings.

What the Developer tab is actually for

Microsoft lists what the tab exists to do:

• Write macros, and run macros you previously recorded
• Use form controls and ActiveX controls
• Use XML commands
• Build applications that work with Microsoft 365 programs

For most Excel users the useful half is the Code group on the left: Visual Basic, Macros, Record Macro, and Macro Security. The controls and XML sections matter mainly if you are building interactive sheets with buttons, checkboxes and dropdowns.

If recording is what brought you here, recording a macro covers the full process and the one limitation worth understanding before you rely on it.

If the tab disappears or will not stick

The setting is durable by design. Microsoft is specific that once shown, "the Developer tab stays visible, unless you clear the check box or have to reinstall a Microsoft 365 program."

That gives you the two real explanations when it vanishes. Either the check box got cleared, or Office was reinstalled or repaired, which resets ribbon customisation. Re-tick the box and it returns.

Two other things people mistake for a bug. The setting belongs to your Excel installation, not to a file, so a workbook that shows the tab on your machine will not show it on a colleague's until they enable it themselves. And it is per application: turning it on in Excel does not turn it on in Word.

If the check box is missing entirely rather than unticked, you are probably in a version that does not offer it, which in practice means the browser version.

Frequently asked questions

Where is the Developer tab in Excel?

It is hidden by default and does not appear until you add it. On Windows, tick Developer under File > Options > Customize Ribbon. On Mac, tick it under Excel > Preferences > Ribbon & Toolbar. Once enabled it sits on the ribbon, generally after the View tab.

Do I need the Developer tab to run a macro?

No. Alt + F8 opens the Macros dialog without it, and Alt + F11 opens the Visual Basic Editor. The tab is a convenience. You need it for things with no keyboard shortcut, such as inserting form controls or changing macro security settings.

Why does the Developer tab keep disappearing?

Almost always because the check box was cleared, or because Microsoft 365 was reinstalled or repaired, which resets ribbon customisation. Microsoft names those as the two cases. Re-enabling it takes a few seconds and it stays until one of those happens again.

Can I get the Developer tab in Excel for the web?

No. The browser version cannot create, run, or edit VBA macros, so there is nothing for the tab to do. Microsoft's own page lists only the desktop versions of Excel. Open the file in desktop Excel on Windows or Mac instead.

Is enabling the Developer tab a security risk?

No. Showing the tab only changes which buttons you can see. It does not change your macro settings or allow anything to run that could not run before. Whether a macro is allowed to execute is governed separately, under Trust Center.

What to do next

With the tab on, the Code group is where nearly everything useful lives. Record a macro to see Excel write VBA for you, then edit or delete it once you want to change what it does. If you would rather not write any code, the free tools library has ready-made macros for common cleanup jobs.