Show All

Remove data validation

1. Select the cells where you no longer want to validate data.

   To remove data validation from all similar cells or from all cells that have validation on a worksheet, find the cells.

   How?

   Find all cells with data validation

   1. On the Edit menu, click Go To.
   2. Click Special.
   3. Click Data validation.
   4. Click All.

   Find cells that match certain data validation settings

   1. Click a cell that has the data validation settings for which you want to find matches.
   2. On the Edit menu, click Go To.
   3. Click Special.
   4. Click Data validation.
   5. Click Same.
2. On the Data menu, click Validation, and then do one of the following:

   If prompted to erase current settings and continue, click OK, and then click Cancel.

   If the Data Validation dialog box appears, click the Settings tab, and then click Clear All.

Note  You cannot remove the data validation for cells in a list that is linked to a SharePoint site.