To make data entry easier, you can create a drop down list in an Excel cell, using data validation.
This works well with a list of words, but the list doesn’t show symbols if you create the list in a font such as Webdings. In the example below, I entered 5, 0, and 6 in cells B2:B4 and formatted the cells with Webdings.
The drop down list shows the number values, instead of the formatted symbols.
Use Built-In Symbols
You can’t create a drop down list of symbols based on formatted cells, but you can use some well-hidden symbols instead.
In the screen shot below, cells B2:B4 are formatted in Tahoma font, which is the same font used in the drop down list.
- To create the Up Arrow in B2, I pressed the Alt key, and typed 30 on the number keypad.
- NOTE: You have to use the number keypad – not the numbers at the top of the keyboard.
- Then, use the same technique in cells B3 and B4, with numbers 29 and 31.
Watch the Video
This video shows you the steps for creating a drop down list, to show a selection of symbols.
Download the Sample File
To download the sample file, please visit my Contextures website: Data Validation Tips and Quirks.