Hi there! Creating a simple Yes/No drop down box in Microsoft Excel is actually quite easy. Here are the steps you can follow:
- Open a new or existing Excel spreadsheet.
- Click on the cell where you want to create the drop down box.
- Go to the Data tab in the top menu bar.
- Click on Data Validation in the "Data Tools" section.
- In the Settings tab of the Data Validation window, select List from the "Allow" drop down menu.
- In the Source field, type (without the quotes).
- Click OK to close the Data Validation window.
That's it! You should now have a drop down box in the selected cell with
Yes and
No as the options. When you click on the drop down arrow, you will see the two options listed. Simply select the option you want and it will be entered into the cell.