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.

The Developer tab on the ribbon in Excel is selected. The Excel ribbon right-click menu is opened, and Customize The Ribbon is selected.

Before creating a macro, activate the Developer tab in Microsoft Excel. This works on PC and Mac, but the steps to activate the Developer tab differ slightly from one operating system to the other.

To do this, first display the Developer tab if it isn’t yet visible by clicking the Office button, choosing Excel Options > Popular, and enabling the Show Developer tab in the Ribbon checkbox. Click ...

1] First, you have to enable the Developer tab in Excel. For this, go to “ File > Options.” Now, click on the Customize Ribbon on the left pane and select the Developer checkbox on the right pane.

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.

How to show the Developer tab in Excel, Word or PowerPoint Open Excel, Word or PowerPoint Click on File > Options Select Customize Ribbon > Customize the Ribbon > Main Tabs.