Find cells that have data validation rules

You can find cells in a workbook that contain data validation by using the Go To Special dialog box.

  1. On the Edit menu, point to Find, and then click Go To.

  2. Click Special.

  3. Select Data Validation.

  4. To find all cells with data validation, select All, and then click OK.

    To find cells that have the same validation rules as another cell, select Same, and then click OK.

  1. On the Edit menu, click Go To.

  2. Click Special.

  3. Select Data Validation.

  4. To find all cells with data validation, select All, and then click OK.

    To find cells that have the same validation rules as another cell, select Same, and then click OK.

See also

Apply data validation to cells

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×