Data Validation Icon Excel. Open the data validation dialog box. To insert symbol in data validation list you can use numbers alt to do a favor.
In microsoft excel 2007 2010 2013 2016 2019 and 365 the data validation command is moved into data tools group under data tab. Select a cell and then hold alt key and type 30 in the number keyboard to insert symbol. How to do data validation in excel 1.
For example you might want to check to see if the cell is wide enough to show all your entries.
Select a cell and then hold alt key and type 30 in the number keyboard to insert symbol. After you create your drop down list make sure it works the way you want. Add an input message. Create drop down list with symbol in excel.
