Excel: Add drop down list in cell


I found instructions on how to do this but I want to take it a step further. I havent been able to find how to do this or not sure what to search for. In the drop down box after I make a selection I would like that choice to disappear from the drop down. So that way I dont select the same option twice. This would help out greatly when creating the order of my lists. Is there a way I can do this?


This question generated 26 answers. To proceed to the answers, click here.

This thread is current as of September 11, 2014.


For more resources for Microsoft Excel