Select a cell in which you want the dropdown to appear (d3 in our case).
How to create drop down list in excel for time. Back on the first sheet, select the blank cell to the. Web in the ribbon, click data > sort. Which menu in the ribbon can create a dropdown list?
Web it’s easy and we’ll show you how. All you need to do is follow these steps: In the source box, enter the formula that indirectly refers to table1's column named items.
On the first sheet, select cell b1. Simply click the arrow and select an option. Web set up your first drop down list.
You can add or delete items from your drop. Then, customize the list using the data validation options.