-
Select Excel at the top of the screen and go to Preferences > Ribbon & Toolbar.
-
In the Customize the Ribbon pane, under Main Tabs, scroll down and select the Developer check box.
-
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.