List boxes are form controls that allow you to see all options at once. You can set a list box to force the user select only one option or allow multiple selections. In this guide, we’re going to show you how to insert a list box in Excel.
Developer Tab and List Box command
The command for inserting a list box can be found under the Developer tab, which is not active in Excel by default. This tab contains macro tools, along with advanced controls, such as list boxes.
If the tab is hidden, follow the steps below.
- Open Excel Options under File.
- Select Customize Ribbon.
- Find and enable the checkbox for Developer in the list box on the right.
- Click OK to see the tab in the Ribbon.
Inserting a list box
Once the Developer tab is visible, you can find the List Box command under the Insert button in the section Controls. When you click the Insert button, you will see same controls under two sections:
- Form Controls
- ActiveX Controls
Clicking the List Box button changes the cursor to a plus. Click anywhere to insert a default list box, or hold and drag the cursor to define the list box size.
Populate items in a list box and bind to a cell
- You need enter list items into a one-column range.
- Right-click on your list box.
- Select Format Control.
- Activate the Control tab.
- Select list items for Input Range.
- Enter or select a cell by using Cell link
- Set Selection type to Single.
- Click OK to apply.
After binding, click on a list box to see the index of the selected list box in the cell.
By default, Excel assumes all list boxes in a worksheet are related with each other. To gather list boxes into multiple groups, you need to combine them under Group Boxes. You can bind each list box in different groups to different cells. This is necessary for using multiple questions within the same worksheet.
List box form control in Excel gives you 3 alternative use cases:
The Single mode is the default approach, which only allows selecting one item. Also, the index of the selected item is displayed in the linked cell.
In Multi type, you can select multiple items by clicking on them. For example, if the first item is selected and you click the second, both items become selected. However, the linked cell does not express the selected items.
Extend mode is an alternative to Multi. When Extend is selected, you need to use either Ctrl or Shift keys to select multiple items. Once again, the linked cell does not express the selected items.