Find cells that have data validation

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.