Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default 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
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I want a simple Yes No selector drop down box for a cell. UPFinnboy Excel Worksheet Functions 1 January 14th 09 04:18 PM
Simple drop down list validation KerryOrr New Users to Excel 3 October 9th 07 11:54 PM
question about creating a simple drop down list [email protected] Excel Worksheet Functions 4 March 18th 06 07:03 AM
Help please simple drop and drag I can't make work Anthony Excel Worksheet Functions 2 July 10th 05 06:28 AM
How do I create a simple drop down box/List SweetShellyGal Excel Discussion (Misc queries) 1 March 11th 05 06:00 PM


All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"