title: Simple way to remove blank cells dynamic dropdown list Excel
body: <p>Whenever I do a dependent dynamic drop down list , I see a bunch of blank cell in the drop-down list , I search many topics that explain how to remove them while   by adding two additional ranges like explained her <a href="http://blog.contextures.com/archives/2014/02/27/dynamic-list-with-blank-cells/" rel="noreferrer">http://blog.contextures.com/archives/2014/02/27/dynamic-list-with-blank-cells/</a></p>
  
  <p>but my question is: Is there anyway to avoid blank cell or remove them using a simple approach without the need of two additional ranges or a complex formula?</p>
  
  <p>the drop down list that contains blank cell  all I did is go to data validation and wrote in source <code>=MYCode</code> then I named the list that contains the codes like that <code>MyCode</code>and I checked ignore blank case (even tho It seems to be useless ) </p>