Can you use the Data Validation function on words in a column of city names?
B babslou Nov 8, 2003 #1 Can you use the Data Validation function on words in a column of city names?
D Debra Dalgleish Nov 8, 2003 #2 You can create a list of city names, and use the list as the source for the data validation dropdown. There are instructions in Excel's Help files, and on the following page: http://www.contextures.com/xlDataVal01.html
You can create a list of city names, and use the list as the source for the data validation dropdown. There are instructions in Excel's Help files, and on the following page: http://www.contextures.com/xlDataVal01.html
