How to create drop down list with symbols in excel

 

If you want to create drop down list like below,

 

1. Click on data menu
2. Data validation - data validation - list
3. Allow -- Click on List button
4. On Source - Select the list of values that to be displayed on the list.
5. Click on OK

 

 

 

 

 If  you want to create drop down list like below but with sybmols,

 

1. Click on data menu
2. Data validation - data validation - list
3. Allow -- Click on List button
4. On Source - Select the list of values that to be displayed on the list.
5. Click on OK

If you want to get symbols then you need to type alt + 0245 (from numeric key pad)