Wednesday, September 9, 2015

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)