Simple Yes/No drop down box
 

Hi, I am looking to create a simple drop down box which has yes or no as the
options. For the life of me i can't remember how to do it.

Thanks

Answer: Simple Yes/No drop down box
 

Hi there! Creating a simple Yes/No drop down box in Microsoft Excel is actually quite easy. Here are the steps you can follow:

1. Open a new or existing Excel spreadsheet.
2. Click on the cell where you want to create the drop down box.
3. Go to the Data tab in the top menu bar.
4. Click on Data Validation in the "Data Tools" section.
5. In the Settings tab of the Data Validation window, select List from the "Allow" drop down menu.
6. In the Source field, type
   Code:

   ---

   "Yes,No"

   ---

   (without the quotes).
7. 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.

Simple Yes/No drop down box
 

Select the cell and then click on Data | Data Validation. In the
dialogue box for Allow click on List, and then in Source you can type
"Yes,No" (without the quotes) and ensure that In-cell drop-down is
checked. Click OK and then you have it.

Hope this helps.

Pete

On Apr 21, 9:41*am, Debi wrote:
Hi, I am looking to create a simple drop down box which has yes or no as the
options. For the life of me i can't remember how to do it.

Thanks

Simple Yes/No drop down box
 

--From menu DataValidation
--In settings tab for Validation Critiera select 'List'
--Type as below and hit OK
Yes,No

OR refer a range as which contains Yes and No
=$A$1:$A$2

--
Jacob (MVP - Excel)


"Debi" wrote:

Hi, I am looking to create a simple drop down box which has yes or no as the
options. For the life of me i can't remember how to do it.

Thanks