Using controls on worksheets
Where to find the controls
Excel 2007 and up
In Excel 2007 and later versions, the form controls and control toolbox controls are slightly hidden. First of all, you need to show the "Developer" tab of the ribbon. Here is how that's done:
- Click the Office button and select "Excel options..." (for Excel 2010 and up: Click File, Options and then locate this option on the "Customize ribbon" tab).
- Click the "Popular" tab and check the box next to "Show Developer tab in the ribbon":
Fig 1: Showing the Developer tab on the ribbon (Excel 2010 and up).
- After you've checked the box and clicked OK, you will find a new tab called "Developer" on your ribbon. This tab houses a group called "Controls", which in turn contains a button "Insert". The dropdown list shows all available controls:
Fig. 2: The controls on the Developer tab.
In older Excel versions the controls are housed on two toolbars; the "Forms" toolbar and the "Control toolbox" toolbar. You can show both toolbars using the menu "View", "Toolbars":
Fig. 3: Access to the controls toolbars in Excel 97-2003.
After turning on these two toolbars they are shown:
Fig. 4: The control toolbars in Excel 97-2003.