Create a Drop Down List With Symbols

To make data entry easier, you can create a drop down list in an Excel cell, using data validation.

symbollist03

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.

symbollist04

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.

symbollist05

  • 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.

______________

Related Posts Plugin for WordPress, Blogger...

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest

1 comment to Create a Drop Down List With Symbols

  • John

    Thanks for this tip Debra. I have always been amazed that Microsoft never allowed dropdowns of other fonts like a tick in a validation dropdown would be so useful in many situations. This symbol "√" is the closest I have found. A Tick and a cross (OK X will do for this) is not much to ask is it?

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>