Go to the data tab in the ribbon.
How to create drop down list in excel yes or no. On the data tab, in the data tools group, click data validation. On the first sheet, select cell b1. If necessary, scroll horizontally to the first blank.
On the second sheet, create the following named ranges. Web it can be in the same worksheet or another one. Web you can add a yes/no field to a new or existing table in datasheet view.
Web select one or more cells for your dropdown (d3:d7 in our case). Then, customize the list using the data validation options. Web to the right, you see labels and formats in preparation for creating the excel drop down list.
Web select the range of cells in which you want to add a dropdown with the yes or no values. Click the data tab and then click data validation in the data. Web go to data and select data validation.
Click on the data validation option in the. Add to an existing table open the table in datasheet view.