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

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.

    Excel Ribbon Image

  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.

    Excel Ribbon Image

  3. Click Data Validation, and then click Same.

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

Top of Page

Applies To: Excel 2007, Excel 2010



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language