Remove Data Validation Excel. That s the mouse way. Select a blank cell and press ctrl c.
Select the cell s with data validation. On the format menu click data validation. Select data tab data tools data validation.
That s the mouse way.
Normally to remove data validation in excel worksheets you proceed with these steps. Press alt e s n which will launch the paste special dialog box with the validation option selected. That s the mouse way. Select the cells with validation or to find all cells with data validation in the worksheet.