Remove Data Validation Excel. Now let s work through another method. To remove the data validation t applied to the cells follow the below steps.
In the first box click select a field or group and then select the field or. On the format menu click data validation. Normally to remove data validation in excel worksheets you proceed with these steps.
Click the control that you want to add data validation to.
Regular way to remove data validation. Under if this condition is true add a condition. Select the range you re removing validation from. Now let s work through another method.