Then you can use the entries as the source for your drop-down list of data. If the list is not large, you can easily refer to it and type the entries directly into the data validation tool. Create a list of valid entries for the drop-down list, typed on a

You can use Excel formulas, for example, to create a simple drop down list. You can even create a dynamic drop down list that can easily be extended when necessary. But, that’s a tutorial for ...

Enter the list of values for your drop-down in a column. Make sure to enter each drop-down entry in a separate, consecutive cell in the same column. For example, if you want your drop-down list to include "New York," "Boston," and &quo