Excel Drop Down Lists and Data Validation, and the Paste That Removes Them

Build a dropdown in four clicks, put the list somewhere it can grow, and know the gap: an ordinary paste replaces the rule entirely. Dependent lists, custom rules, and finding what got in.