Once you know what macros you'd like to set up and have the Developer tab ready, here's what to do in Excel on Windows or macOS: Click the Developer tab and find the Code group.

If Developer tab in Microsoft Office is missing, you can add Developer tab in Word, Excel, etc. via Settings, Group Policy, Registry Editor.

Via the Registry Editor The Options Menu is the easiest method to enable the Developer tab in Excel. 2] After enabling the Developer tab, select it and then click Macros. Give a name to your Macro.

To enable the Developer tab, open Excel and go to the File menu. From there, select Options, then Customize Ribbon. In the right pane of the dialog box that appears, check the Developer box.