. Here are the steps to create a drop down list in a cell: For our example, this is cell a2 where you pick either entree or dessert. from venturebeat.com This tutorial takes the occupation as example. To remove the arrow, uncheck show dropdown list in cell. if you enter data in a cell that doesn’t match an item on the list, you’ll see a warning. In data validation dialogue box, select the settings tab.