Creating a yes/no drop-down in Excel uses the process we followed for the example above. All you need to do is follow these steps: Also: How to add a drop down list in Google Sheets No formula is ...

An curved arrow pointing right. Data validation in Excel allows you to create drop-down menus right inside individual cells. You can also restrict the types of values entered into different cells.