I have a data validation list which worked great at first. I have it set for all of column A. Now I had to delete some rows, and now those rows show as blanks in the drop down despite having the ignore blanks box checked. How do I fix this? Why is this happening? Please and thank you! Excel 2016 Windows