2 Ways to Create a Dropdown List in Excel

In this video, I show you two ways to create a dropdown list in Excel. Both methods use the data validation tool on the data tab and we select "list" from the allow field. In the first method, we enter each item we want on the dropdown list in the source field, separated by a comma (spaces are not required, but may make it easier to read). In the second method, we create the list on another sheet, name the selection and enter that name preceded by an equals sign in the source field.
-Click on the Data tab
-Click on Data Validation
-In the validation criteria, choose Allow: List
Method 1: best for shorter lists
-Source: Enter dropdown data separated by commas (i.e. XS, SM, MED, LG, XL, 2XL, 3XL)
Method 2: best for longer lists (starts around 2:01)
-Source: create a list with 1 item per row, highlight the row & name the selection, enter the selection as the source (i.e. =shirt_sizes)
Don't forget to subscribe to my channel for more tutorials!
Check out my website at simplesoftwaretutorials.com
Video recorded using Screencast-O-Matic (www.screencast-o-matic.com)
Thanks for tuning in!