css下拉框带三角符号
To make data entry easier, you can create a drop down list in an Excel cell, using data validation.
为了简化数据输入,您可以使用数据验证在Excel单元格中创建一个下拉列表 。
![symbollist03](https://i-blog.csdnimg.cn/blog_migrate/86a3db01d6f96389608bfa7ca6b532a8.png)
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.
这适用于单词列表,但是如果以Webdings等字体创建列表,则该列表不显示符号。 在下面的示例中,我在单元格B2:B4中输入5、0和6,并使用Webdings格式化单元格。
The drop down list shows the number values, instead of the formatted symbols.
下拉列表显示数字值,而不是格式的符号。
![symbollist04 symbollist04](https://i-blog.csdnimg.cn/blog_migrate/668923e24af7bfc51ee1996d1409c460.png)
使用内置符号 (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.
在下面的屏幕快照中,单元格B2:B4的格式为Tahoma字体,该字体与下拉列表中使用的字体相同。
![symbollist05](https://i-blog.csdnimg.cn/blog_migrate/b22356121d3d864c2d64b4f370c29323.png)
-
- 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. 然后,在单元格B3和B4中使用相同的技术,编号为29和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, visit my Contextures website: Data Validation Tips and Quirks. ______________
要下载示例文件,请访问我的Contextures网站: 数据验证技巧和古怪 。 ______________
翻译自: https://contexturesblog.com/archives/2013/04/02/create-a-drop-down-list-with-symbols/
css下拉框带三角符号