The Developer tab is hidden by default, but you can turn it on in three clicks

The Developer tab in Excel gives you access to tools for macros, form controls, and XML features — things most everyday users never need. If you work with macros or need to build interactive spreadsheets, you'll want this tab visible in your ribbon. Excel hides it by default, but turning it on takes less than a minute.

The steps are the same whether you use Excel on Windows or Mac, though the menu names differ slightly. Once you've turned it on, the Developer tab stays visible until you hide it again.

Key Takeaways

  • The Developer tab is hidden by default and must be turned on through Excel Options or Preferences.
  • On Windows, go to File > Options > Customize Ribbon and check the Developer box.
  • On Mac, go to Excel > Preferences > Ribbon & Toolbar and check the Developer box.
  • Once enabled, the Developer tab appears in your ribbon permanently until you turn it off.
  • You only need the Developer tab if you work with macros, form controls, or XML mapping.

How to enable the Developer tab on Windows

Open Excel and look at the top left of your screen. Click File, then click Options at the bottom of the menu that appears. A window titled "Excel Options" will open.

On the left side of this window, click Customize Ribbon. You'll see two columns: one labeled "Choose commands from" on the left, and one labeled "Customize the Ribbon" on the right. The right column shows all the tabs currently visible in your ribbon — Home, Insert, Draw, Page Layout, Formulas, Data, Review, View, and Help.

Look at the right column and find the box next to Developer. It will be unchecked. Click the box to check it. Then click OK at the bottom right of the window. The Developer tab now appears in your ribbon, positioned between the View tab and the Help tab.

How to enable the Developer tab on Mac

Open Excel. At the top of your screen, click Excel in the menu bar (the first menu on the left), then click Preferences. A window will open with several icons across the top.

Click the icon labeled Ribbon & Toolbar. You'll see a list of tabs on the right side of the window. Scroll down until you see Developer in the list. Click the checkbox next to it to turn it on. Then click the red close button at the top left of the window. The Developer tab now appears in your ribbon.

What you'll find in the Developer tab

Once the Developer tab is visible, clicking it shows you several groups of tools. The Code group contains the Visual Basic Editor button, which is where you write and edit macros. The Controls group holds buttons for inserting form controls like checkboxes, dropdown lists, and buttons into your spreadsheet.

The XML group appears only if your version of Excel supports XML mapping — this is rarely used outside of specialized business workflows. Most people who turn on the Developer tab only use the Code and Controls groups.

When you actually need the Developer tab

You need the Developer tab if you want to record or write macros — small programs that automate repetitive tasks in Excel. For example, if you run the same formatting steps on dozens of spreadsheets every week, a macro can do that work in seconds.

You also need it if someone has sent you a spreadsheet with form controls — buttons, checkboxes, or dropdown menus built into the sheet itself. Without the Developer tab visible, you can't edit or troubleshoot these controls.

If you only use Excel to enter data, create charts, and write formulas, you will never need the Developer tab. Leaving it hidden keeps your ribbon cleaner and less cluttered.

How to hide the Developer tab again

If you turned on the Developer tab but no longer need it, you can hide it the same way you turned it on. On Windows, go to File > Options > Customize Ribbon, uncheck the Developer box, and click OK. On Mac, go to Excel > Preferences > Ribbon & Toolbar, uncheck Developer, and close the window.

Hiding the tab doesn't delete any macros or controls you've created — it just removes the tab from view. You can turn it back on anytime.

Frequently Asked Questions

Will turning on the Developer tab slow down Excel?

No. The Developer tab is just a menu — turning it on doesn't change how Excel runs or use any extra memory. It only makes certain tools visible that were already in the program.

Can I move the Developer tab to a different position in the ribbon?

Yes. In the Customize Ribbon window (Windows) or Ribbon & Toolbar preferences (Mac), you can click Developer and use the up and down arrow buttons to move it left or right in the tab order.

What's the difference between form controls and ActiveX controls?

Form controls are simpler and work reliably across different computers. ActiveX controls are more powerful but can cause compatibility problems if the spreadsheet is shared with others. Most people should use form controls unless you have a specific reason to use ActiveX.

If I record a macro, where does it get saved?

By default, macros are saved inside the workbook you're editing. When you save the file, the macro saves with it. You can also save macros to your Personal Macro Workbook, which makes them available in every Excel file you open on that computer.