Kiến thức

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

Bạn đang xem: How to add Yes and No options to a drop down list in Excel

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-trainingworksheet-for-yes-no-excel-trainingworksheet-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-trainingyes-no-source-box-excel-trainingyes-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

Categories

Excel Training

,

Uncategorized

Tags

/excel/training/

Chuyên mục: Kiến thức

Related Articles

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *

Check Also
Close
Back to top button