How to Create a Drop Down List in Microsoft Excel

office 2010 support ― Step 1: Open your work sheet and write down all the items you need in the list anywhere on it. Make sure that the list is written vertically and you sort and arrange the items carefully as the same order will be reflected in the list.Step 2: Now, select all the items and name your list by writing it down in the name box.Step 3: Select the cell where you want to create the dropdown list and click on Data –> Data Validation in the ribbon. Step 4: In the Data Validation dialog window choose[...]