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