In the Controls group, click Insert, then click the Combo Box in the ActiveX Controls section.On the Excel Ribbon, click the Developer tab (If you don’t see a Developer tab, click here for instructions on how to add it).To add a combo box on an Excel sheet, follow these steps: This named range is used in the data validation list, and we will also use it as the source for the combo box. There are instructions on my Contextures website, for naming a range of cells. In this example, there is a named range - MonthList - with a list of the 12 month names. use the AutoComplete feature to make data entry easier.
Unlike data validation, the combo box can be formatted and fine tuned.
Instead of using data validation, you can use a combo box on an Excel worksheet to show a drop down list.Īt the left, in the screen shot below, is a combo box, and you can compare it to the data validation drop down list on the right. Not all your dreams can come true in Excel, but this tip might fulfill a few of them. Would you prefer a bigger font size for items in a data validation drop down list? Would you save typing time if the words were completed automatically, as you started typing them?
