Find cells that have data validation rules

You can find cells in a workbook that contain data validation by using the Go To Special dialog box.

2016 2011



1. On the Edit menu, point to Find, and then click Go To.

2. Click Special.

3. Select Data Validation.

4. To find all cells with data validation, select All, and then click OK.

   To find cells that have the same validation rules as another cell, select Same, and then click OK.

1. On the Edit menu, click Go To.

2. Click Special.

3. Select Data Validation.

4. To find all cells with data validation, select All, and then click OK.

   To find cells that have the same validation rules as another cell, select Same, and then click OK.

See also

Apply data validation to cells