Select one or more cells where we want the dropdown list to appear.
How to create drop down list in excel and color code. Inserting drop down list 3. Web simply click the arrow and select an option. This process of how to add a dropdown in excel.
You can add or delete items from your drop. So , let’s enter the values in the range a1 to a3 as shown.