Nuacht

Susan Harkins shows you a quick method for removing validation rules for multiple ranges in Excel, at the same time.
Go to the Data Validation dialog menu in the same way as if you were deleting the menu options, but instead of deleting them all, simply delete only the ones you want to remove.