 Create a drop-down list in less than one minute. Identify where you want your list. Navigate to the tab data. Find data validation. Select list. Enter your values separated by a comma. Click OK. You now have a drop-down list available with those values. Go to data, data validation. Select list. Select the range containing your values. Click OK. Your drop-down list is now populated from your supplied range. If you change your value, this will also update into your drop-down list. Be sure to like and subscribe for more videos.