How to Enable the Developer Tab in Excel for Mac

To show the Developer tab in Excel for Mac, click Excel > Settings (or Preferences) in the menu bar, click Ribbon & Toolbar, check Developer in the Main Tabs list, and click Save. The tab appears on the ribbon right away and stays there in every workbook until you turn it off.

These steps are for Excel for Microsoft 365 for Mac and recent one-time purchase versions such as Excel 2024 and 2021 for Mac. Older versions follow the same idea with a slightly different settings page, covered below. Microsoft lists the steps in its guide to using the Developer tab in Excel for Mac.

You Need the Desktop App

  • You need the desktop app. The Developer tab exists only in Excel installed on your Mac. Excel for the web doesn’t have it.
  • Settings or Preferences? On recent versions of macOS, the Excel menu item is called Settings. On older Macs it’s Preferences. Both open the same window, and Command + comma opens it either way.
  • It’s a setting on your Mac, not in the file. Showing the tab doesn’t change any workbook. Someone else who opens your file has to turn the tab on in their own copy of Excel.
  • It’s off by default. A missing Developer tab doesn’t mean anything is broken.

How to Enable the Developer Tab in Excel for Mac

  1. Open Excel. Any workbook, or a blank one, is fine.
  2. Click Excel in the menu bar at the top of the screen, next to the Apple menu, and choose Settings (or Preferences). The Excel settings window opens with a grid of icons.
  3. Under Authoring, click Ribbon & Toolbar.
  4. Make sure Ribbon is selected at the top of the window. In the list on the right under Customize the Ribbon, make sure the menu above it shows Main Tabs.
  5. Check the Developer box.
Excel for Mac Ribbon & Toolbar settings with the Developer box checked
Check Developer under Main Tabs, then click Save.
  1. Click Save, then close the settings window.

The Developer tab now appears on the ribbon, usually after the View tab. It stays there for every workbook you open on this Mac.

Illustration of the steps to show the Developer tab in Excel for Mac
Illustration: the steps to show the Developer tab in Excel for Mac.

If you see a View option instead

Some older versions of Excel for Mac put the switch on a different page. Microsoft’s Excel for Mac forms article gives this route: choose Excel > Preferences, click View under Authoring, and check Developer tab under In Ribbon, Show.

That View page is also where you hide zero values in Excel for Mac.

How to hide the Developer tab again

Go back to Excel > Settings > Ribbon & Toolbar, clear the Developer box, and click Save. Hiding the tab doesn’t delete any macros or controls in your workbooks.

What Is on the Developer Tab in Excel for Mac?

The Developer tab is where you write and run macros, work with form controls, and use add-ins. On a Mac, the main buttons are:

  • Visual Basic: opens the Visual Basic Editor, where you write and edit macro code (VBA, short for Visual Basic for Applications).
  • Macros: lists the macros you can run, edit, or delete.
  • Record Macro and Use Relative References: record your clicks and typing as a macro you can replay.
  • Excel Add-ins: turns on built-in add-ins such as the Analysis ToolPak and Solver.
  • Form controls: buttons such as Button, Check Box, Combo Box, List Box, Option Button, and Scroll Bar for fill-in forms.
Illustration of what the Developer tab in Excel for Mac contains
Illustration: what the Developer tab in Excel for Mac contains.

Excel for Mac supports form controls but not ActiveX controls. ActiveX controls are a Windows-only kind of control, so a workbook built with them on a PC won’t run those controls on a Mac.

Shortcuts that work without the tab

If you only need the editor or the macro list now and then, Microsoft’s Excel keyboard shortcuts list gives these Mac shortcuts:

Task Mac shortcut
Open the Visual Basic Editor Option + F11
Open the Macro dialog box Option + F8

On many Mac keyboards, the top row controls brightness and volume by default, so you may need to hold fn as well.

How to Record Your First Macro

A recorded macro replays a set of steps, such as formatting a header row, with one click or shortcut.

  1. On the Developer tab, select Use Relative References if you want the macro to work from whichever cell is active, rather than always the same cells.
  2. Select Record Macro.
  3. Type a Macro name. It must start with a letter, can’t contain spaces, and shouldn’t look like a cell reference, so use something like Format_Header.
  4. Under Store macro in, choose This Workbook.
  5. Optional: type a letter in Shortcut key and add a Description. Then click OK. Recording starts.
  6. Do the steps you want to record, such as applying bold and a fill color.
  7. On the Developer tab, select Stop Recording.

A macro shortcut key overrides the matching Excel shortcut while that workbook is open, so pick a letter you don’t use for something else.

Run, edit, or delete a macro

  1. On the Developer tab, click Macros. The Macro dialog box lists your macros.
  2. Select a macro, then click Run to play it, Edit to open its code in the Visual Basic Editor, or the delete button (the minus sign) to remove it.

Save the workbook so the macro stays

Regular .xlsx workbooks can’t store macros. Click File > Save As, choose Excel Macro-Enabled Workbook (.xlsm) under File Format, and click Save. If you save a macro workbook as .xlsx, Excel warns you, and the macros are removed if you continue. If you do this often, change the default save type in Excel for Mac to .xlsm.

Add a Button or Check Box From the Developer Tab

Button: Click Developer > Button, then drag on the worksheet to draw it. In the Assign Macro box, choose a macro and click OK. Clicking the button now runs that macro. To change it later, right-click the button and choose Assign Macro. Microsoft’s button guide covers both Mac and Windows.

Check box: Click Developer > Check Box and draw it on the sheet. Right-click it, choose Format Control, and set Cell link to an empty cell. That cell shows TRUE when the box is checked and FALSE when it’s clear, so formulas can use it. Microsoft’s form controls guide explains the other controls. Excel for Microsoft 365 also has a newer checkbox that lives inside the cell, covered in converting TRUE and FALSE to checkboxes in Excel.

A button doesn’t write a macro for you, so record or write the macro first. For a simple list of choices inside a cell, you don’t need the Developer tab at all: insert a drop-down list in Excel with Data Validation instead.

Let Macros Run Safely on a Mac

Showing the Developer tab doesn’t change macro security. That is a separate setting:

  1. Click Excel > Settings (or Preferences).
  2. Click Security.
  3. Choose one option. Disable all macros with notification is the default and asks you each time. Disable all macros without notification blocks them silently. Enable all macros runs everything without asking, including harmful macros.
Excel for Mac Security settings with macro security options
Leave Disable all macros with notification selected.

Microsoft’s enable or disable macros in Office for Mac page describes each choice. Leave the default on, and only enable macros in files from people you trust. For more on the security prompt, read about enabling macros in Excel.

How to Show the Developer Tab in Excel for Windows

  1. Click File > Options. On a narrow window you may need to click More first.
  2. Click Customize Ribbon.
  3. Under Main Tabs on the right, check Developer.
  4. Click OK.

You can also right-click any ribbon tab and choose Customize the Ribbon to jump to step 3. Microsoft’s Show the Developer tab article says the tab stays visible unless you clear the box or reinstall Office.

The same File › Options window is where you turn off automatic hyperlinks in Excel, under Proofing.

If Excel for the Web Has No Developer Option

  • No Developer option in Excel for the web: You can’t create, run, or edit VBA macros in Excel for the web. Open the file in the desktop app. The web version’s Automate tab uses Office Scripts, a different tool that doesn’t run VBA.
  • Developer isn’t in the list: Check that the menu above the right-hand list says Main Tabs, then scroll down. The box sits among Home, Insert, Formulas, and the other main tabs.
  • The tab disappeared: Check the box again. Reinstalling Office can reset it.
  • The setting won’t change on a work Mac: Your organization may manage Office settings. Ask your IT department.
  • Macros won’t save: Save as Excel Macro-Enabled Workbook (.xlsm).
  • A macro won’t run: Check the macro security setting above, and confirm the file came from someone you trust.

Excel for Mac Developer Tab Questions

Does the Developer tab change my workbook?

No. It only adds buttons to the ribbon. Nothing in your files changes until you record a macro or add a control.

Do I need the Developer tab to record a macro?

It’s the easiest way on a Mac, because Record Macro, Stop Recording, and Use Relative References all sit there. You can open the Macro dialog box or the editor with Option + F8 or Option + F11 without it.

Will the Developer tab show on my other Mac?

Not automatically. Turn it on in Excel on each computer you use.

Can I add the Developer tab to Word or PowerPoint on a Mac?

Yes. Each app has its own setting. Open Word (or PowerPoint) > Settings > Ribbon & Toolbar and check Developer there.

Word has its own Developer tab setting, which you need to create a drop-down list in Word.

Which version of Excel do I have?

Click Excel > About Microsoft Excel to see it. Finding which version of Excel you’re using explains what the number means.

If you plan to build forms or reports next, counting colored cells in Excel includes a short VBA function you can paste into the Visual Basic Editor.

To size columns to fit your macro’s output, use the keyboard shortcuts to AutoFit columns and rows in Excel.