{"id":1588,"date":"2015-08-18T21:16:12","date_gmt":"2015-08-18T19:16:12","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1588"},"modified":"2024-02-06T16:02:50","modified_gmt":"2024-02-06T15:02:50","slug":"dynamic-data-validation-list-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/dynamic-data-validation-list-in-excel\/","title":{"rendered":"Dynamic Data Validation List"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/dynamic-data-validation-list-in-excel\/#Want_to_know_how_to_use_the_Excel_List_Validation\" title=\"Want to know how to use the Excel List Validation?\">Want to know how to use the Excel List Validation?<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Want_to_know_how_to_use_the_Excel_List_Validation\"><\/span><em><strong>Want to know how to use the Excel List Validation?<\/strong><\/em><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n<p>Watch it on <a href=\"https:\/\/youtu.be\/DDElOrPxJsY\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a> and give it a thumbs-up!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/DDElOrPxJsY?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/ListDemo.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/ListDemo.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download the youtube excel practice file<\/strong><\/span><span class=\"postTitle px-3\">ListDemo.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p>What\u00b4s a dynamic data validation drop down list in Excel, you say?<\/p>\n<p>Well, as you add new data into your Excel Table, your drop down list automatically gets updated.<\/p>\n<p>That is a cool feature and it means that you do not need to update your data validation source reference each time you update your data with a new entry, saving you heaps of time in the long run.<\/p>\n<p>In a few steps you too can create this:<\/p>\n<p>1. Convert your data to an Excel Table (Ctrl+T)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Dynamic Data Validation List\"  class=\"alignnone size-full wp-image-19307\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-01.png\" alt=\"Dynamic Data Validation List\" width=\"594\" height=\"232\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-01.png 594w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-01-300x117.png 300w\" sizes=\"(max-width: 594px) 100vw, 594px\" \/><\/p>\n<p>2. Select your table\u00b4s column by hovering over the Excel Table and left clicking when the arrow pointer shows<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Dynamic Data Validation List\"  class=\"alignnone size-full wp-image-19308\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-02.png\" alt=\"Dynamic Data Validation List\" width=\"229\" height=\"229\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-02.png 229w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-02-150x150.png 150w\" sizes=\"(max-width: 229px) 100vw, 229px\" \/><\/p>\n<p>3. In the ribbon go to <em><a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"Formulas\" data-wpil-keyword-link=\"linked\">Formulas<\/a> &gt; Define Name &gt;<\/em> enter a custom name with no spaces (we will put this name in step 5) and press OK<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Dynamic Data Validation List\"  class=\"alignnone size-full wp-image-19313\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-03.png\" alt=\"Dynamic Data Validation List\" width=\"558\" height=\"420\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-03.png 558w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-03-300x226.png 300w\" sizes=\"(max-width: 558px) 100vw, 558px\" \/><\/p>\n<p>4. Click in a cell and go to the ribbon and choose <em>Data &gt; Data Validation &gt; List<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Dynamic Data Validation List\"  class=\"alignnone size-full wp-image-19309\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-04.png\" alt=\"Dynamic Data Validation List\" width=\"857\" height=\"520\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-04.png 857w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-04-300x182.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-04-768x466.png 768w\" sizes=\"(max-width: 857px) 100vw, 857px\" \/><\/p>\n<p>5. In the Source box enter the name you created in <strong>Step 3<\/strong> and press OK<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Dynamic Data Validation List\"  class=\"alignnone size-full wp-image-19310\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-05.png\" alt=\"Dynamic Data Validation List\" width=\"394\" height=\"319\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-05.png 394w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-05-300x243.png 300w\" sizes=\"(max-width: 394px) 100vw, 394px\" \/><\/p>\n<p>6. If you want to add extra data into your Excel Table, hover with your mouse in the bottom right hand corner and when you see a double arrow, drag down.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Dynamic Data Validation List\"  class=\"alignnone size-full wp-image-19311\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-06.png\" alt=\"Dynamic Data Validation List\" width=\"574\" height=\"265\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-06.png 574w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-06-300x139.png 300w\" sizes=\"(max-width: 574px) 100vw, 574px\" \/><\/p>\n<p>7. Enter a new entry and this will automatically be updated in your drop down list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Dynamic Data Validation List\"  class=\"alignnone size-full wp-image-19312\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-07.png\" alt=\"Dynamic Data Validation List\" width=\"588\" height=\"268\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-07.png 588w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/dynamic-data-validation-list-07-300x137.png 300w\" sizes=\"(max-width: 588px) 100vw, 588px\" \/><br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/_zKj8IQ7jDo?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><br \/>\n<span style=\"text-decoration: underline; color: #0000ff;\">\u00a0<a class=\"IRPP_minimalist icon-download\" style=\"color: #0000ff;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Dynamic-Data-Validation.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download workbook<\/span><span class=\"postTitle px-3\">Dynamic-Data-Validation.xlsx<\/span><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/www.powerquery.training\/course\/?ref=4\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" title=\"Excel Chart Layouts\"  class=\"alignnone wp-image-1466 size-full\" style=\"display: none !important;\" hidden=\"\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/728x90.png\" alt=\"Excel Chart Layouts\" width=\"728\" height=\"90\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/728x90.png 728w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/728x90-300x37.png 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Want to know how to use the Excel List Validation? *** Watch our video and step by step guide below with free downloadable Excel workbook to practice *** Watch it on YouTube and give it a thumbs-up! \ufeff\ufeff\ufeff download the youtube excel practice fileListDemo.xlsx &nbsp; What\u00b4s a dynamic data validation drop down list in Excel, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17499,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[34,6],"tags":[88,96],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1588"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=1588"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1588\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17499"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}