Find Cells That Have Data Validation. C Under the Data tab on the Ribbon in the Data Tools group. If the sheet contains multiple data validation results you want to find out specific data validation then you need to follow the below steps.
First select the range of cells you want to apply the validation to. On the Edit menu click Go To. How to find cells with data validation in Excel.
In the Settings tab select the validation rule criteria.
Put a check beside Data Validation then All as pictured below. C Under the Data tab on the Ribbon in the Data Tools group. This will however only put the validation option onto that first cell. A Under the Insert tab on the Ribbon in the Text group.
