{"id":1256,"date":"2012-11-15T13:58:19","date_gmt":"2012-11-15T13:58:19","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=1256"},"modified":"2026-01-02T05:33:52","modified_gmt":"2026-01-02T05:33:52","slug":"how-to-add-yes-and-no-options-to-a-drop-down-list-in-excel","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/how-to-add-yes-and-no-options-to-a-drop-down-list-in-excel\/","title":{"rendered":"How to add Yes and No options to a drop down list in Excel"},"content":{"rendered":"<p>The previous post showed how to add a drop down list using a short list of terms. \u00a0Entering a drop down list can be even quicker when applying yes\/no choices to Excel.<\/p>\n<figure id=\"attachment_1261\" aria-describedby=\"caption-attachment-1261\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"\/b\/wp-content\/uploads\/2012\/11\/worksheet-for-yes-no-e-xcel-training.png\"><img decoding=\"async\" class=\"size-medium wp-image-1261\" src=\"\/b\/wp-content\/uploads\/2012\/11\/worksheet-for-yes-no-e-xcel-training-300x75.png\" alt=\"worksheet-for-yes-no-excel-training\" width=\"300\" height=\"75\" \/><\/a><figcaption id=\"caption-attachment-1261\" class=\"wp-caption-text\">I want to add &#8220;yes and no&#8221; options to this worksheet<\/figcaption><\/figure>\n<ol start=\"1\">\n<li>To set up the drop down list, I <strong>select the cells<\/strong> where I want the drop down lists to appear &#8211; in this example, I want to apply it to E2 to E6.<\/li>\n<li>In the\u00a0<strong>Data tab<\/strong>\u00a0select\u00a0<strong>Data Validation<\/strong>, and in the\u00a0<strong>Settings<\/strong>\u00a0menu, select\u00a0<strong>List<\/strong><\/li>\n<li>I can add yes and no options, straight into the <strong>Source<\/strong>section.\n<p><figure id=\"attachment_1262\" aria-describedby=\"caption-attachment-1262\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"\/b\/wp-content\/uploads\/2012\/11\/yes-no-source-box-excel-training.png\"><img decoding=\"async\" class=\"size-medium wp-image-1262\" src=\"\/b\/wp-content\/uploads\/2012\/11\/yes-no-source-box-excel-training-300x235.png\" alt=\"yes-no-source-box-excel-training\" width=\"300\" height=\"235\" \/><\/a><figcaption id=\"caption-attachment-1262\" class=\"wp-caption-text\">Adding the text options directly into the source section is quicker than creating a reference list.<\/figcaption><\/figure><\/li>\n<li>I tick the boxes for\u00a0<strong>Ignore blank<\/strong>\u00a0and\u00a0<strong>In-cell drop down<\/strong>. Then click ok.<\/li>\n<li>The drop down list is now applied.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>For more <a href=\"\/microsoft\/excel-training-london.php\">details on Excel courses London<\/a>, take a look.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The previous post showed how to add a drop down list using a short list of terms. \u00a0Entering a drop down list can be even quicker when applying yes\/no choices to Excel. To set up the drop down list, I select the cells where I want the drop down lists to appear &#8211; in this [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"singular-low-link.php","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[24],"class_list":["post-1256","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-exceltraining"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1256","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=1256"}],"version-history":[{"count":2,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1256\/revisions"}],"predecessor-version":[{"id":7825,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1256\/revisions\/7825"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}