To add the Developer tab to your ribbon, follow the steps for your operating system:
Enable the Developer Tab on Windows (Microsoft 365 / 2016 and newer)
Enable the Developer Tab on macOS (Microsoft 365 / 2019 and newer)
How to Hide the Developer Tab Again?
Repeat the steps for your platform and clear the Developer check box, or in Windows select Reset ► Reset only selected Ribbon tab to restore the default layout. Excel stores this ribbon preference in your user profile, so the tab remains visible whenever you open Excel—even in new workbooks. With the tab unlocked, you can record simple macros, write VBA procedures, insert ActiveX or Form controls, and import or export XML data—transforming basic spreadsheets into dynamic applications.
