Excel Developer Tab: How to Open It on Windows and Mac

How-to basics · Updated November 21, 2026

In Excel for Microsoft 365 on Windows, select File > Options > Customize Ribbon, check Developer under Main Tabs, then select OK. On a Mac, open Excel > Settings (or Preferences) > Ribbon & Toolbar, enable Developer, and save. The tab gives you access to tools such as macros, Visual Basic for Applications (VBA), form controls, and add-ins.

You do not need to change a workbook or turn on macros just to display the tab. The steps below explain how to reveal it in the desktop app, what to do if the option is missing, and what to expect in Excel for the web.

What You’ll Need

  • A desktop version of Excel for Windows or Mac. The ribbon customization steps apply to Microsoft 365 desktop Excel; some labels may differ slightly in older releases.
  • Permission to change Excel’s ribbon settings. On a managed work or school computer, an administrator may restrict some options.
  • A workbook is optional. You can change the ribbon setting from Excel’s start screen without opening a file.

Step-by-Step

  1. Confirm that you are using the desktop app. Open Excel and look at the application window. If you are working in a browser at Microsoft 365 or Excel on the web, you are not in the desktop app. The classic Developer tab is not available there; skip to the web-specific guidance below. If Excel is installed on your computer, launch that app instead. You can also use the workbook’s app menu, if available, to choose an option such as opening it in the desktop app.
  2. Check whether the tab is already visible. Look along the ribbon at the top of Excel, where tabs such as Home, Insert, and View appear. Developer may already be at the right end of the tab row. If you see it, click it; there is no need to change settings. If the ribbon itself is collapsed, expand it first by selecting a visible tab or using the ribbon display control near the top-right of the window. A collapsed ribbon can hide commands, but it does not usually remove the Developer tab from the tab list.
  3. Open ribbon customization in Windows Excel. Select File in the upper-left corner, then select Options near the bottom of the File screen. In the Excel Options window, choose Customize Ribbon in the left-hand list. The right-hand side shows the available ribbon tabs, generally grouped under Main Tabs. If you do not see Options, make sure you are in the desktop application and not looking at a browser version or a workbook’s in-cell menu.
  4. Turn on Developer in Windows. In the right-hand list of Main Tabs, find the checkbox beside Developer and select it. Do not confuse this with the list of commands on the left: that list is for adding individual commands to custom groups, while the checkbox on the right controls whether a whole tab is displayed. Select OK to apply the change and close Excel Options. The Developer tab should now appear on the ribbon, often toward the right side.
  5. Use the Mac ribbon settings if you are on macOS. In the menu bar at the top of the screen, select Excel > Settings. In some releases, this menu item is called Preferences. Open Ribbon & Toolbar, then view the list of Main Tabs or the ribbon customization area. Select the checkbox for Developer and choose Save or close the settings window if that is how your version applies changes. Return to the workbook and check the ribbon. The precise wording and placement can vary a little between Mac releases, but the setting is in Excel’s ribbon customization controls.
  6. Make sure the change is visible in the workbook window. If you had several Excel workbooks open, click back into the window you want to use and inspect its tab row. The ribbon can look different if the window is narrow, so maximize the window or use the ribbon display control if you cannot see all the tabs. The Developer tab is a ribbon setting; enabling it does not insert a button, worksheet, or visible change into the workbook itself.
  7. Open the tab and choose the tool you need. Select Developer to see the available groups, which can include Code, Add-ins, Controls, and XML. For example, the Code group provides access to Visual Basic and macro-related commands, while Controls includes tools for adding form controls. The exact commands shown can depend on your Excel version and setup. Displaying the tab only makes these tools accessible; it does not create, run, or enable a macro.
  8. If you are using Excel for the web, switch to a supported workflow. Excel for the web does not provide the classic desktop Developer tab or the full VBA editor. Open the file in the Windows or Mac desktop application to use those features. If your organization and account provide the Automate tab, you may be able to use Office Scripts in the browser instead. Office Scripts are not VBA macros, so they are not a direct replacement when you need to edit or run existing VBA code.

Common Mistakes

Looking for the tab in the wrong version of Excel: Browser Excel and desktop Excel do not have identical ribbon features. If you cannot find Excel Options or the Developer checkbox, first confirm that you have launched the installed desktop app.

Changing the wrong list: In Windows’ Customize Ribbon window, the left list contains commands and the right list contains tabs. Checking a command on the left does not reveal the entire Developer tab. Use the Developer checkbox in the Main Tabs list on the right.

Assuming the setting enables macros: Showing Developer only reveals ribbon tools. Excel’s macro security settings are separate, and a file downloaded from the internet may have additional security restrictions. Do not enable macros in an unfamiliar file simply because the tab is available.

Expecting the tab to be saved inside every workbook: Ribbon visibility is normally an Excel application customization for your account or installation, not a change to the workbook’s cells. If you open Excel on another computer or under another account, you may need to enable the tab there too.

Confusing a hidden ribbon with a missing tab: A compact or collapsed ribbon can make commands hard to see. Expand the ribbon and check the row of tab names before changing customization settings.

Tips

Before changing settings, decide what you want to do with the tab. If you only need to record a simple macro, the Developer tab provides a Record Macro command; you may also find macro-related commands under the View tab, depending on your setup. If you need to write or inspect VBA, use the desktop app and open the Visual Basic editor from Developer. Showing the tab itself does not require you to create a macro-enabled workbook.

When you do create or edit VBA, save a working copy first and choose a macro-capable file format, such as Excel Macro-Enabled Workbook (.xlsm), if the workbook needs to retain VBA code. A standard .xlsx file cannot store VBA macros. Keep the original file unchanged until you have confirmed that the copied workbook works as intended.

You can customize the ribbon further from the same settings area, for example by moving tabs or adding a custom group. Make one change at a time so it is clear which setting affected the display. If you later decide you do not want Developer visible, return to the same customization screen and clear its checkbox; hiding the tab does not delete macros or remove workbook data.

On a shared or managed computer, avoid changing settings that belong to another user. If an option is disabled or reverts after restarting Excel, check whether your organization applies a policy to the application. Ask your IT administrator before attempting workarounds on a work device.

Troubleshooting

Developer is checked, but the tab is still not visible: Select OK or Save to apply the setting, then return to the workbook. Expand the ribbon, maximize the Excel window, and look across the full tab row. If the Excel window was open before the setting changed, close and reopen the app as a next step, then check Customize Ribbon again to see whether Developer remains selected.

You cannot find File > Options: That path is for Windows desktop Excel. On a Mac, use Excel’s application menu and open Settings or Preferences, then Ribbon & Toolbar. In Excel for the web, you will not find the desktop Options dialog; open the workbook in the installed application for classic Developer tools.

The Developer checkbox is missing or unavailable: Verify that you are in Excel, not another Office app, and that the window is the desktop version. If you are on a managed device, your administrator may control ribbon features. Update or repair Office only if other signs suggest the installation is damaged; first check with your organization’s support team if the computer is managed.

The tab appears, but a command is disabled: A visible command can still depend on the selected workbook, installed add-ins, security policy, or the feature’s availability in that Excel version. Select a normal worksheet cell and check again. For VBA or macro commands, ensure that you are in desktop Excel; browser Excel does not support the VBA editor. Follow your organization’s security rules rather than lowering protection to make a command available.

Your setting disappears after changing computers or accounts: Ribbon customizations do not necessarily travel with a workbook or sync between installations. Repeat the steps on the other device or sign-in. If the setting disappears on the same computer each time Excel restarts, check for an organization-managed configuration or contact support.

Frequently Asked Questions

Is the Developer tab hidden by default in Excel?
Often, yes. Excel can hide it in the default ribbon configuration. You can show it by checking Developer in the ribbon customization settings; this does not change the workbook’s contents.

Can I open the Developer tab with a keyboard shortcut?
There is no single universal shortcut that toggles the tab’s visibility. Use File > Options > Customize Ribbon on Windows or Excel > Settings > Ribbon & Toolbar on Mac. After the tab is visible, Windows ribbon Key Tips may help you navigate commands, but the displayed letters can depend on your setup.

Can I use the Developer tab in Excel for the web?
No. The classic Developer tab and VBA editor are desktop features. Open the workbook in desktop Excel to work with VBA or form controls. Office Scripts may be available through Automate for eligible web accounts, but they use a different system from VBA.

Does showing Developer make macros safe to run?
No. The tab only exposes commands. Macro security still applies, and you should run code only when you trust its source and understand its purpose. If a file is blocked by your organization or Excel, follow the relevant security guidance instead of bypassing it.

Will the Developer tab appear for someone else who opens my workbook?
Not necessarily. The visibility setting is generally part of the user’s Excel ribbon configuration, not a workbook-wide setting. Another person may need to enable the tab in their own desktop Excel installation.

How do I hide the tab again?
Return to the same Customize Ribbon or Ribbon & Toolbar settings and clear the Developer checkbox, then apply or save the change. Hiding the tab does not remove existing macros, add-ins, or workbook content.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.