Data Validation Icon Excel. Create drop down list with symbol in excel. On the settings tab click on allow drop down under validation criteria.
To copy validation from one cell to other cells. A data validation pop up will open. Add an input message.
For example you might want to check to see if the cell is wide enough to show all your entries.
Here is some common used symbols you may use in drop down list. For example you might want to check to see if the cell is wide enough to show all your entries. Copy data validation from one cell to another. Select the range f2 f20 and click the conditional formatting drop down and chose the last option manage rules.
