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 developed, 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.

What do you want to do?

Find all cells with data validation

Find cells that match certain data validation settings

Find all cells with data validation

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

   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 Edit menu, click Go To.
3. Click Special.
4. Click Data validation.
5. Click Same, and then click OK.

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

Top of Page