Add Drop Down Excel. Step 1 open the excel spreadsheet file you want to edit. Drop down lists are created using the data validation feature.
To add an item go to the end of the list and type the new item. If the item you want to delete is somewhere in the middle of your list right click its cell click delete and. To create a drop down list in excel execute the following steps.
However do not include the header cell.
Select shift cells down and click ok. You can add drop down lists to cells in excel containing options such as yes and no male and female or any other custom list of options. You can position the drop down list in most any cell or even multiple cells choose data validation from the data ribbon. Make sure to enter each drop down entry in a separate consecutive cell in the same column.
