How to create a drop-down list in Excel ... sheet, select the cells where you want the drop-down list to appear. You can also select a whole column. 3. Click on the "Data" tab in the top menu ...