These values should be entered in a single column or row without any blank cells.įor example, let's create a drop-down list of ingredients for your favorite recipes:
Select the entries you want to appear in your drop-down menu in an existing worksheet or type the entries in a new sheet. Type the entries for your drop-down list. This method of creating an Excel data validation list takes a bit more time, but it may save even more time in the long run. Creating an Excel drop-down list based on a named range If it's not the case, consider using one of the following options. This method works well for small Excel data validation lists that are unlikely to ever change. Well, your drop-down box is ready in under a minute. Now, Excel users simply click an arrow next to a cell containing a dropdown box, and then select the entry they want from the drop down menu.
Select a cell or range for your drop-down list. This is the fastest 3-step way to create a drop-down box in all versions of Excel 2016, 2013, 2010, 20.