Excel : Insert Combo Box

Inserting Combo Box in Excel

1.      Select the cell where you want to put the combo box .

2.      Goto  Tool Bar>Data>Data Validations >In Allow ,select “List”

3.      In Data Validation> Source field  , Click on the icon located at the end  and goto the column where the data is present and select all the data you want to listed inside the como box.

4.      Click on Ok .