Remove Data Validation Excel. On the settings tab click the clear all button and then click ok. Click the control that you want to add data validation to.
Select a blank cell and press ctrl c. You can use the find. Regular way to remove data validation.
That s the mouse way.
You can use the find. Normally to remove data validation in excel worksheets you proceed with these steps. In the first box click select a field or group and then select the field or. That s the mouse way.