Categories
Excel Training

How to add Yes and No options to a drop down list in Excel

The previous post showed how to add a drop down list using a short list of terms.  Entering a drop down list can be even quicker when applying yes/no choices to Excel.

worksheet-for-yes-no-excel-training
I want to add “yes and no” options to this worksheet
  1. To set up the drop down list, I select the cells where I want the drop down lists to appear – in this example, I want to apply it to E2 to E6.
  2. In the Data tab select Data Validation, and in the Settings menu, select List
  3. I can add yes and no options, straight into the Sourcesection.

    yes-no-source-box-excel-training
    Adding the text options directly into the source section is quicker than creating a reference list.
  4. I tick the boxes for Ignore blank and In-cell drop down. Then click ok.
  5. The drop down list is now applied.

 

for more details on  /excel/training/ , take a look at https://www.stl-training.co.uk/excel-2007-intermediate.php

By Richard Bailey

I love what I do; I get to work with an outstanding team to help hundreds of people with their challenges. I’ve learnt a lot from the teams I’ve worked with, no matter the size or industry we all have challenges to overcome, difficult customers, creating a budget or keeping a project on track.