Find cells with dropdown list

[Goddess]

Hi,

I have just updated a template, but found out some of the dropdown list referred to the wrong cells/sheet. Is there a way to search for cells with dropdown list instead of checking each and every cell? For example, the list should refer to data from Sheet 1, but instead, they are referred to Sheet 2.

Thanks!

 

[Wookiee]

if you press CTRL+G, you will get the Go To menu

at the bottom of that menu, there is a button labeled Special...

press that button and it will display another form which allows you to look for cells according to a number of different formats

click on Data validation and All, then click OK

 

[Goddess]

if you press CTRL+G, you will get the Go To menu

at the bottom of that menu, there is a button labeled Special...

press that button and it will display another form which allows you to look for cells according to a number of different formats

click on Data validation and All, then click OK

Hi Wookiee,

Thanks for your suggestion. I actually did that before, but somehow it also selected some random cells (cells with formula, reference and even blank cells). Not sure what's wrong