For example, Excel sees "Texas" and "Tezas" as two different ... Choose "Data Validation" from the drop-down menu. 6. In the "Settings" tab in the top menu, under "Allow," click "List." ...