On the insert tab, in the tables group, click.
How to create drop down list and color in excel. Then, customize the list using the data validation options. On the second sheet, select a list item. Web simply click the arrow and select an option.
So , let’s enter the values in the range a1 to a3 as shown. Inserting drop down list 3.