Excel Guides

Adding and Using a Combo Box in Excel

A combo box is a drop-down list from which the user can select an option. The list of options in the drop-down can be populated from a range of cells in the workbook.

To add a combo box in Excel, do the following:

  1. Click on the Developer tab. If you don't see the Developer tab, click here to learn how to display it.
  2. In the Controls group, click Insert, and then under ActiveX Controls, click Combo Box.
  3. Click the worksheet location where you want to place the control. A combo box is inserted.

To populate the drop-down list with values from a range of cells, do the following:

  1. Right-click on the combo box and select Format Control.
  2. In the Format Control dialog box, on the Control tab, in the Cell link box, enter a cell address that contains the value you want to display in the drop-down list.

  1. Click OK.

Using the Combo Box



The value selected in the combo box will be displayed in the linked cell (in this case, cell B1).


Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.