Web 0:00 / 1:00 how to create drop down menu in excel.
How to add drop down menu in excel youtube. On the ribbon, click the data tab, and click data validation. Make sure the items are consecutive (no blank rows). In the dialog, set allow to list.
#database #excel #exceltips #excelformula #excelforbegi. To remove an item, press delete. Select the cells that you want to contain the lists.