Type in the Title and Input message required. To set up a message to inform the users of the worksheet that they need to select from a drop-down list, select the Input Message tab and check the Show input message when cell is selected check box.

Unchecking In-cell dropdown would mean that “Yes” or “No” would have to be typed in (or copy-pasted), rather than selected from a drop-down list in a cell. Note that unchecking Ignore blank would mean an empty cell is considered invalid. Type in Yes, No as the Source for the drop-down list. In the Settings tab, select List under Allow, and ensure that Ignore blank and In-cell dropdown are checked.In the Ribbon, select Data > Data Tools > Data Validation.Data Validation to Add a Yes/No Drop-Down List You can achieve this in Excel by means of Data Validation. Restricting user input by means of a drop-down list is very useful when you wish the user to select from a list of preset values. This tutorial will demonstrate how to create a yes/no drop-down in Excel and Google Sheets.

Insert a drop down menu in excel 2016