-
Select the cell(s) with data validation.
-
Go to Data and select
Data Validation. -
On the Settings tab, select Clear All and OK.
-
Select the cell(s) with data validation.
-
Go to Data and select
Data Validation. -
On the Settings tab, select Clear All and Apply.