Find cells that have data validation

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.

What do you want to do?


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.

Excel Ribbon Image

  1. 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 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.

Excel Ribbon Image

  1. Click Data Validation, and then click Same.

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

Top of Page Top of Page

 
 
Applies to:
Excel 2010, Excel 2007