So , let’s enter the values in the range a1 to a3 as shown.
How to create drop down list and color in excel. Select one or more cells where we want the dropdown list to appear. Then, customize the list using the data validation options. On the insert tab, in the tables group, click.
You can add or delete items from your drop. On the second sheet, select a list item.