You may want to easily locate which cells in a worksheet have data validation. Perhaps you inherited a worksheet to update that a former employee created, or your worksheet is large, and you forgot in which cells you have added data validation. Fortunately, you can easily highlight cells with data validation.

• Find all cells with data validation

• Find cells that match certain data validation settings

Find all cells with data validation

1. On the Home tab, in the Editing group, click the arrow next to Find & Select, and then click Go To Special.

   

2. Click Data Validation, and then click All.

   If any cells are found that contain data validation, they are highlighted; otherwise, the message "No cells were found" is displayed.

 Top of Page

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 Home tab, in the Editing group, click the arrow next to Find & Select, and then click Go To Special.

   

3. Click Data Validation, and then click Same.

   If any cells are found that contain matching data validation, they are highlighted.

 Top of Page