Double-click on the Display Developer tab in the Ribbon setting and choose the Enabled option. Click the Apply and OK buttons to save the change and restart Excel to find the Developer tab.

If opening the Developer tab and clicking a button is a little too much work, you can also open the editor with the keyboard shortcut Alt+F11, which works whether the Developer tab is enabled or not.

Click the Developer tab on the menu bar. Click the Legacy Tools button in the Controls group section. The Legacy Tools feature allows users to Insert Active X buttons and Form Controls into their ...