Show the Developer tab

1. On the File tab, select Options. 

2. On the Customize Ribbon tab, select the Developer checkbox in the list on the right.

3. Select OK.

1. On the Excel menu at the top of the screen, select Preferences and choose Ribbon & Toolbar.

2. Under Main Tabs in the Customize the Ribbon pane, scroll down and select the Developer check box.

3. Select Save.

The Developer tab isn't currently available in Excel for the web. You can, however, use the Developer tab in the Excel desktop app.

• To open the desktop app, at the top of the ribbon, select Editing > Open in Desktop App.

  

Don't have the Excel desktop app? Try or buy Microsoft 365.