I am trying to figure out why my data validation drop downs are not working. I have created my list, named the list and selected the desired cells for the list. I have then went to the cell that I want my drop down in and entered the appropriate data validation settings >List>List Name and made sure the dropdown box is checked and yet my data validation is not showing up. Any ideas if I'm missing something or if a setting needs to be changed?