you want to delete the empty cells or ignor them in the validation? if you want to ignore them in the validation there is a check box to ignore blanks in data validation.