find data validation cell in worksheet in Excel

Q103. In Excel, how can I identify all cells with Data Validation in my WorkSheet?

Note: This would be very helpful if you have inherited a complex WorkSheet and want to understand how the WorkSheet has been set up.

For example, in the table below, I would like to quickly identify the cells that have Data Validation.

excel find data validation cell in worksheet

To do it in Excel, here is the answer:

a) Press F5 and in the "Go To" dialog that pops up, click on "Special" (Alternatively, click on "Find & Select" under "Home". Click on "Go To Special").

excel excel find data validation cell in worksheet

b) In the "Go To Special" dialog box, click on "Data validation", click OK.

excel excel excel find data validation cell in worksheet

c) All the cells with "Data validation" are selected / highlighted as shown below.

excel excel excel excel find data validation cell in worksheet

 

You can find similar Excel Questions and Answer hereunder

1) How can I display fractions as it is in a cell (instead of displaying as a decimal)?

2) How can I hide a specific Shape in my WorkSheet?

3) How do I use Find to determine last occurrence of a string in a WorkSheet range using VBA?

4) How do I know which cells on the worksheet contain Conditional Formatting?

5) How can I plot 2 series on the same chart with different scales / measurement unit for Values (Ex: Pareto chart)?

6) How can I update a listbox based on data in a list using VBA?

7) How can I enter a text in a cell with subscript and superscript?

8) How can I set the Source Data of charts using VBA?

9) How can I enter multiple lines of data in a cell?

10) Is there any way I can see more region of my WorkSheet?

11) How to change the color of gridlines in a worksheet in Excel

12) How do I add a shape using VBA?

13) How can I filter and copy only filtered data using VBA?

14) Given a raw data Table, how can I find the value of a field for a specific value of another field?

15) How can I hide all comments in my WorkSheet using VBA?