Add Drop Down Excel. However do not include the header cell. Similarly you can enter the items in a single row such as a1 d1.
To add the drop down list in our example to an excel sheet do the following. Right click and then click insert. You can position the drop down list in most any cell or even multiple cells choose data validation from the data ribbon.
Simply click the arrow and select an option.
Go to the data tab on the ribbon then click data validation. If the item you want to delete is somewhere in the middle of your list right click its cell click delete and. Go to the data tab on the ribbon then click data validation. Create the data validation list in cells a1 a4.
