We can illustrate this technique by adding such a validation data control to the Membership Number column as follows: Select all existing data cells in the column in question.

Susan Harkins shows you a quick method for removing validation rules for multiple ranges in Excel, at the same time.