In the source field, select the range of cells that you want in the drop down list.In the Settings tab, select List from the drop down.Go to Data –> Data Tools –> Data Validation.Select the cell where you want to create the drop down list.Once you have the items you want to show in a drop down list, here are the steps to create it: Now we can use these symbols in cells (as shown above in the pic) to create a drop down list. Select another cell to insert another symbol.This inserts the selected symbol in the cell. In the Symbol dialog box, select the symbol you want to insert and click on Insert.However, you should test this in case you are using symbols from other fonts. Any symbol you use from Tahoma font also usually works with other regularly used fonts such as Arial, Calibri, Trebuchet MS, Verdana, etc. An excel drop-down list displays the content in Tahoma font (info credit: Debra Dalgleish).In the Symbol dialog box, select the font from the drop down.Here is how you can insert symbols in excel cells:
To use any symbol in a drop down list, we first need to get it in a cell.
In this tutorial, I will show you how to show symbols in drop down lists in Excel.